Online Class: Advanced Excel 2019

no certificate
with CEU Certificate*
-
20Lessons
-
36Exams &
Assignments -
2,361Students
have taken this course -
16Hours
average time -
1.6CEUs
Course Description
Excel is one of the most powerful tools in Microsoft Office. You can import, query, analyze and manipulate data to create powerful reports that can be used by individuals and enterprise businesses alike. This course explores some of the more advanced features of Microsoft Excel to give you a more powerful experience when you need the most out of spreadsheet software.
- Outlines, Custom Views, and Templates
- Mathematical Functions
- Data Functions and Data Lookups
- The IF Function
- Manipulating Text
- Conditional Formatting
- Sparklines
- Importing, Cleaning and Validating Data
- Pivot Tables and Pivot Charts
- The What-If Analysis
- Goal Seek and Solver
- The Analysis ToolPak
- Using Get & Transform to Perform Queries
- Macros
- And Much More!
Pivot tables are one of the most beneficial tools in Excel, and this course covers pivot tables both basic and advanced features. It then moves on to pivot charts, which are graphs that can be used with pivot table data.
Analysis tools in Excel 2019 are some of the most advanced and useful to users that want to run complex reports. Excel has three What-If analysis tools that can be run on your data and provide reports on goals that give answers to your problems. The Solver and Analysis Toolpak are two add-ins that expand on these tools, and they are also covered in this course.
The final lessons cover data validation, troubleshooting, querying data and macros. These lessons provide ways to work with data and clean up unstructured information. This course fully covers advanced features in Excel so that you can create complex spreadsheets for business or individual use.
- Completely Online
- Self-Paced
- Printable Lessons
- Full HD Video
- 6 Months to Complete
- 24/7 Availability
- Start Anytime
- PC & Mac Compatible
- Android & iOS Friendly
- Accredited CEUs

Course Lessons
Lesson 1: Outlines, Custom Views, and Templates
Lesson 1 Video
Review 2 Articles: Free Excel Templates; How to Use Excel Custom Views Like a Pro
Take Survey: Reasons for Taking this Course
Complete Assignment: My Excel Experience
Complete: Lesson 1 Exam
Lesson 2: Mathematical Functions
Lesson 2 Video
Review 4 Articles: SUM function; AVERAGE function; How to Use the RAND and RANDBETWEEN Functions in Excel; Countif function
Complete: Lesson 2 Activity Assignment
Complete: Lesson 2 Exam
Lesson 3: Data Functions
Lesson 3 Video
Review 6 Articles: Excel ISERROR Function; ERROR.TYPE function; Excel ISNUMBER Function; Excel ISREF Function; Excel ISBLANK Function; Excel TYPE Function
Complete: Lesson 3 Activity Assignment
Complete: Lesson 3 Exam
Lesson 4: Data Lookups
Lesson 4 Video
Review 2 Articles: Excel VLOOKUP Function; HLOOKUP function
Complete: Lesson 4 Activity Assignment
Complete: Lesson 4 Exam
Lesson 5: The IF Function
Lesson 5 Video
Review 4 Articles: Excel IF Function; Conditional Formulas in Excel and Tricks Using the IF Function in Excel; Excel logical formulas: 12 simple IF statements to get started; Excel Nested IF statement: examples, best practices and alternatives
Complete: Lesson 5 Activity Assignment
Complete: Lesson 5 Exam
Lesson 6: Manipulating Text
Lesson 6 Video
Review 4 Articles: Excel FIND Function; Functions LEFT ? RIGHT ? MID; Change the case of text; Excel SUBSTITUTE Function
Complete: Lesson 6 Activity Assignment
Complete: Lesson 6 Exam
Lesson 7: Exploring Conditional Formatting
Lesson 7 Video
Review Article: Analyze and format in Excel
Review Video: Microsoft Excel 2019: Conditional Formatting
Complete: Lesson 7 Activity Assignment
Complete: Lesson 7 Exam
Lesson 8: Working with Sparklines
Lesson 8 Video
Review 3 Articles: Use formulas with conditional formatting; Use sparklines to show data trends; Excel Sparklines ? A Complete Guide with Examples
Complete: Lesson 8 Activity Assignment
Complete: Lesson 8 Exam
Lesson 9: Linking To and Consolidating Worksheets
Lesson 9 Video
Review Article: Consolidate data in Excel and merge multiple sheets into one worksheet
Complete: Lesson 9 Activity Assignment
Complete: Lesson 9 Exam
Lesson 10: Importing and Cleaning Data
Lesson 10 Video
Review 2 Articles: How to use Goal Seek in Excel for What-If analysis; Microsoft Excel: How to use Scenario Manager
Complete: Lesson 10 Activity Assignment
Complete: Lesson 10 Exam
Lesson 11: Pivot Tables
Lesson 11 Video
Review 3 Articles: How To Create A New Pivot Table With The Excel 2019 Quick Analysis Tool; Create a PivotTable to analyze worksheet data; Summarizing Text Data With Pivot Tables
Complete: Lesson 11 Activity Assignment
Complete: Lesson 11 Exam
Lesson 12: Continuing to Work with Pivot Tables
Lesson 12 Video
Review 4 Articles: Calculate values in a PivotTable; Calculated Field or Calculated Item; Use slicers to filter data; Create a timeline
Complete: Lesson 12 Exam
Lesson 13: Pivot Charts
Lesson 13 Video
Review 3 Articles: Create a PivotChart; Add a data series to your chart; Change the layout or style of a chart
Complete: Lesson 13 Activity Assignment
Complete: Lesson 13 Exam
Lesson 14: The What-if Analyses
Lesson 14 Video
Review 2 Articles: Find Quick Answers With Excel Goal Seek; Excel Scenarios Create and Show
Complete: Lesson 14 Exam
Lesson 15: Goal Seek and Solver
Lesson 15 Video
Review 3 Articles: How to Use Excel?s Goal Seek and Solver to Solve for Unknown Variables; Load the Solver Add-in in Excel; Define and solve a problem by using Solver
Complete: Lesson 15 Activity Assignment
Complete: Lesson 15 Exam
Lesson 16: The Analysis ToolPak
Lesson 16 Video
Review 3 Articles: Use the Analysis ToolPak to perform complex data analysis; Load the Analysis ToolPak in Excel; The t-Test Tool
Complete: Lesson 16 Exam
Lesson 17: All About Data Validation
Lesson 17 Video
Review 3 Articles: Apply data validation to cells; Display or hide circles around invalid data; How To Remove Duplicates In Excel 2019: Eliminating Records With Duplicate Fields
Complete: Lesson 17 Activity Assignment
Complete: Lesson 17 Exam
Lesson 18: Using Get & Transform to Perform Queries
Lesson 18 Video
Review 2 Articles: Overview of Excel tables; Create and format tables
Complete: Lesson 18 Exam
Lesson 19: Troubleshooting and Auditing in Excel 2019
Lesson 19 Video
Review 2 Articles: Troubleshooting Excel: The Five Minute Flowchart; Detecting And Correcting Errors In Excel 2019 Formulas
Complete: Lesson 19 Exam
Lesson 20: Exploring Macros in Excel 2019
Lesson 20 Video
Take Poll: End of Course Poll
Take Survey: Course Comments
Take Survey: Program Evaluation Follow-up Survey (End of Course)
Complete: Lesson 20 Activity Assignment
Complete: Lesson 20 Exam
Complete: The Final Exam
Learning Outcomes
- Demonstrate working with outlines, custom views, and templates in Excel 2019.
- Demonstrate using mathematical functions.
- Demonstrate using data functions, data lookups, and the IF function.
- Demonstrate using conditional formatting.
- Demonstrate working Sparklines.
- Demonstrate linking to and consolidating worksheets.
- Describe importing and cleaning data.
- Demonstrate creating and using Pivot Tables and Pivot Charts.
- Demonstrate creating and using the What-if Analyses.
- Demonstrate creating and using the Goal Seek and Solver.
- Demonstrate creating and using the the Analysis ToolPak.
- Demonstrate creating and using the using get & transform to perform queries, and
- Demonstrate mastery of lesson content at levels of 70% or higher.
Additional Course Information

- Document Your Lifelong Learning Achievements
- Earn an Official Certificate Documenting Course Hours and CEUs
- Verify Your Certificate with a Unique Serial Number Online
- View and Share Your Certificate Online or Download/Print as PDF
- Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media

Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificates & CEUs
Includes all 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 500+ |
Certificates & CEUs
Includes all 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 24 Months |
No. of courses | 500+ |