Current Status
Not Enrolled
Get Started

Mastering Excel 2019 – Advanced

Play Video

You are not yet enrolled in this course.


There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to use links, Lookup functions, Data Validation, Macros, data tables, and more.  

This is our most requested training course!

If you are comfortable with using Excel for a variety of tasks, let our Microsoft Certified Trainer, Kathy Jones, walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data.

Topics covered include:

  • Linking cells and consolidating data
  • Sharing and protecting worksheets
  • Automating data validation and tasks
  • Using Lookup functions
  • Auditing formulas
  • Forecasting data
  • Creating geographic visuals like Map Charts and 3D Map Tours
  • Importing and exporting data
  • Creating a Web Query
  • Working with Forms and ActiveX controls

Over four hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Average Review Score:

You must log in and have started this course to submit a review.

ATS eLearning
Scroll to Top