Welcome to ONLC Training Centers

Excel 2016 On-Demand: Comprehensive (Basic, Intermediate & Advanced)


Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Excel 2016 On-Demand: Comprehensive (Basic, Intermediate & Advanced) Course Outline

*** Note: This is an On-Demand (self-study)course, 180-day, 24/7 access via the internet ***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time; there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and exercises. Note: The 180-day course access period begins at time of purchase.

About This Course
This Online On-Demand (self-study) training course includes expert lectures, PowerPoint visuals, and demonstrations. You will be able to follow along and successfully complete the course by completing the quizzes and exams. You do not need to own the software for the course and will be able to access the course from any device, provided you have internet access.

When you purchase this On-Demand course from ONLC you will receive a printed Learning Guide with access to downloadable practice files to supplement your learning. You must have the software (purchased version or free trial) to access the practice files. (Note: printed materials are not provided when you purchase the Office On-Demand Comprehensive bundle or when Office On-Demand is included with the All You Can Learn offer.)

Prefer a Live, Instructor-led Class?
If you don't feel On-Demand is right for you, consider our live, instructor-led format (ILT). For more details on the ILT option, click on the link below:
Microsoft Excel Training Classes

This course takes 3 days to complete and includes 10h 47m of video presentation.

Course Outline

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

View outline in Word


Attend hands-on, instructor-led Excel 2016 On-Demand: Comprehensive (Basic, Intermediate & Advanced) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Courses and select the one that's right for you.


Class Format
Class Policies
Student Reviews

First Name

Last Name