Microsoft Office Excel 2016 - Basic:

Chapter 01 - Getting Started with Microsoft Office Excel 2016

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data

Chapter 02 - Performing Calculations

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

Chapter 03 - Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

Chapter 04 - Formatting a Worksheet

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Chapter 05 - Printing Workbooks

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Chapter 06 - Managing Workbooks

• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Microsoft Office Excel 2016 - Intermediate:

Chapter 01 - Working with Functions

• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

Chapter 02 - Working with Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Chapter 03 - Analyzing Data

• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Chapter 04 - Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

Chapter 05 - Using PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers

Microsoft Office Excel 2016 - Advanced:

Chapter 01 - Working with Multiple Worksheets and Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Chapter 02 - Using Lookup Functions and Formula Auditing

• Use Lookup Functions
• The VLOOKUP Function
• Trace Cells
• Watch and Evaluate Formulas

Chapter 03 - Sharing and Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Chapter 04 - Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros
• Creating Sparklines and Mapping Data

Chapter 06 - Forecasting Data

• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature