Monthly Archives: May 2017

Archive of posts published in the specified Month

Excel 2016: Relative and Absolute Cell References


Introduction There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant…

Read more

Excel 2016: Creating More Complex Formulas


Introduction You may have experience working with formulas that contain only one operator, such as 7+9. More complex formulas can contain several mathematical operators, such as 5+2*8. When there’s more than one operation in a formula, the order of operations tells Excel which…

Read more

Excel 2016: Intro to Formulas


Introduction One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. In this lesson, we’ll show you how to use cell references to create simple…

Read more

Excel 2016: Page Layout and Printing


Introduction There may be times when you want to print a workbook to view and share your data offline. Once you’ve chosen your page layout settings, it’s easy to preview and print a workbook from Excel using the Print pane. Optional: Download our…

Read more

Excel 2016: Checking Spelling


Introduction Before sharing a workbook, you’ll want to make sure it doesn’t include any spelling errors. Fortunately, Excel includes a Spell Check tool you can use to make sure everything in your workbook is spelled correctly. If you’ve used the Spell Check feature…

Read more

Excel 2016: Using Find & Replace

find and replace

Introduction When working with a lot of data in Excel, it can be difficult and time consuming to locate specific information. You can easily search your workbook using the Find feature, which also allows you to modify content using the Replace feature. Optional:…

Read more

Excel 2016: Working with Multiple Worksheets


Introduction Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content. You can also group worksheets to quickly add…

Read more

Excel 2016: Understanding Number Formats


What are number formats? Whenever you’re working with a spreadsheet, it’s a good idea to use appropriate number formats for your data. Number formats tell your spreadsheet exactly what type of data you’re using, like percentages (%), currency ($), times, dates, and so…

Read more

Excel 2016: Formatting Cells


Introduction All cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections…

Read more

Excel 2016: Modifying Columns, Rows, and Cells


Introduction By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells. Optional: Download our practice workbook.…

Read more