Monthly Archives: May 2017

Archive of posts published in the specified Month

Excel 2016: Relative and Absolute Cell References

references_relative_cell

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

complex_order1

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

simpform_graphic_formulas5

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

layout_pane_print_pane

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

spelling-check

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

sheets_new_done

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

number_date_dialog

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

font-size-dropdown-menu

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

mod_colwidth_select

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