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