1 - GETTING STARTED WITH EXCEL 2016

Navigate the Excel User Interface

Use Excel Commands

Create and Save a Basic Workbook

Enter and Edit Cell Data

Fill Cells with Series of Data (AutoFill and Flash Fill)

Use Excel Help

2 - PERFORMING CALCULATIONS

Create Worksheet Formulas

Insert Functions and use Autocomplete

Reuse Formulas and Functions

Create an Absolute Reference

3 - MODIFYING A WORKSHEET

Insert, Delete, and Adjust Cells, Columns, and Rows

Move and Copy Data between Cells

Search for and Replace Data

Use Spellcheck and Proofing

4 - FORMATTING A WORKSHEET

Apply Text Formats

Apply Number Formats

Align Cell Contents

Apply and Copy Cell Styles

Apply Basic Conditional Formatting

5 - PRINTING WORKBOOKS

Preview and Print a Workbook

Controlling Page Layout

Adding Headers and Footers

Set Print Titles and Print Ranges

6 - MANAGING WORKBOOKS

Manage Worksheets

Insert and Delete Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties