Welcome to ONLC Training Centers

Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3)


Need a price quote?

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

Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3) Course Outline

*** 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

You have 24/7 access for 180-days to this digital course that includes 12h 04m of video presentation. As a traditional course it would be a 3-4 day class.

Course Outline

Microsoft Office Excel 2019: Part 1

Chapter 01 - Getting Started with Microsoft Office Excel 2019
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help

Chapter 02 - Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions

Chapter 03 - Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools

Chapter 04 - Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates

Chapter 05 - Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers

Chapter 06 - Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties

Chapter 07 - Adding Borders and Colors to Worksheets
Topic A: Add Borders and Colors to Worksheets

Chapter 08 - Basic Excel Customization
Topic A: Customize General Options and the Excel UI

Microsoft Office Excel 2019: Part 2

Chapter 01 - Working with Functions
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date and Time Functions
Topic E: Work with Text Functions

Chapter 02 - Working with Lists
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data

Chapter 03 - Analyzing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting

Chapter 04 - Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Chapter 05 - Using PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers

Chapter 06 - Working with Graphical Objects
Topic A: Insert Graphical Objects
Topic B: Modify Graphical Objects
Topic C: Work with SmartArt

Chapter 07 - Using Array Formulas
Topic A: Use Array Formulas

Microsoft Office Excel 2019: Part 3

Chapter 01 - Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data

Chapter 02 - Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

Chapter 03 - Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros

Chapter 04 - Using Lookup Functions and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas

Chapter 05 - Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends

Chapter 06 - Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data

Chapter 07 - Importing and Exporting Data
Topic A: Import and Export Data

Chapter 08 - Internationalizing Workbooks
Topic A: Internationalize Workbooks

Chapter 09 - Working with Power Pivot
Topic A: Work with Power Pivot

Chapter 10 - Advanced Customization Options
Topic A: Customize Advanced Options

Chapter 11 - Working with Forms and Controls
Topic A: Work with Forms and Controls

View outline in Word


Attend hands-on, instructor-led Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3) 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