# Microsoft® Office EXCEL® 2016

# Course Content

## Level 1 (1 day)

**Lesson 1: Getting Started with Microsoft Office Excel 2016 **

Navigate the Excel User Interface

Use Excel Commands

Create and Save a Basic Workbook

Enter Cell Data

Use Excel Help

**Lesson 2: Performing Calculations **

Create Worksheet Formulas

Insert Functions

Reuse Formulas and Functions

**Lesson 3: Modifying a Worksheet **

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

Search for and Replace Data

Use Proofing and Research Tools

**Lesson 4: Formatting a Worksheet **

Apply Text Formats

Apply Number Formats

Align Cell Contents

Apply Styles and Themes

Apply Basic Conditional Formatting

Create and Use Templates

**Lesson 5: Printing Workbooks **

Preview and Print a Workbook

Set Up the Page Layout

Configure Headers and Footers

**Lesson 6: Managing Workbooks **

Manage Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties

## Level 2 (1 day)

**Lesson 1: Working with Functions **

Work with Ranges

Use Specialized Functions

Work with Logical Functions

Work with Date & Time Functions

Work with Text Functions

**Lesson 2: Working with Lists **

Sort Data

Filter Data

Query Data with Database Functions

Outline and Subtotal Data

**Lesson 3: Analyzing Data **

Create and Modify Tables

Apply Intermediate Conditional Formatting

Apply Advanced Conditional Formatting

**Lesson 4: Visualizing Data with Charts **

Create Charts

Modify and Format Charts

Use Advanced Chart Features

**Lesson 5: Using PivotTables and PivotCharts **

Create a PivotTable

Analyze PivotTable Data

Present Data with PivotCharts

Filter Data by Using Timelines and Slicers

## Level 3 (1 day)

**Lesson 1: Working with Multiple Worksheets and Workbooks **

Use Links and External References

Use 3-D References

Consolidate Data

**Lesson 2: Using Lookup Functions and Formula Auditing **

Use Lookup Functions

Trace Cells

Watch and Evaluate Formulas

**Lesson 3: Sharing and Protecting Workbooks **

Collaborate on a Workbook

Protect Worksheets and Workbooks

**Lesson 4: Automating Workbook Functionality **

Apply Data Validation

Search for Invalid Data and Formulas with Errors

Work with Macros

**Lesson 5: Creating Sparklines and Mapping Data **

Create Sparklines

Map Data

**Lesson 6: Forecasting Data **

Determine Potential Outcomes Using Data Tables

Determine Potential Outcomes Using Scenarios

Use the Goal Seek Feature

Forecasting Data Trends