Microsoft Excel Advanced Training

Course Duration: 1 Day

This Course Covers Version(s): Microsoft Excel versions 2013, 2016 and 2019. (Does not cover Excel for Mac OS)

Available Delivery Methods

In this Microsoft Excel Advanced training course, students will learn how to use features in Excel to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply complex formulas and functions. Students will see how to create Links and External References to Worksheets and Workbooks, use Lookup functions like VLOOKUP and HLOOKUP, and watch and evaluate formulas to find and fix logic errors. Students will also learn how to protect worksheets and workbooks from inadvertent changes being made, apply data validation to ensure correct data is entered in the worksheet and will see how to use Macros to automate common tasks in Excel. Finally, students will learn about visualizing data using Sparklines and Maps and how to forecast data trends in Excel.

After successful completion of this course students will be able to:

  • Perform advanced data analysis.
  • Collaborate on workbooks with other users.
  • Use Lookup functions and formula auditing.
  • Share and protect workbooks.
  • Automate workbook functionality using Macros.
  • Create Sparklines and map data visually.
  • Forecast data.
  1. Referencing Data in Other Worksheets or Workbooks
    • How to Use Links and External References
    • How to Use 3-D References
    • Consolidating Data
  2. Working with Lookup Functions and Auditing Formulas
    • Lookup Functions: LOOKUP(), VLOOKUP(), HLOOKUP(), MATCH(), INDEX(), TRANSPOSE()
    • Display Cell Relationships using Trace Cells
    • Watch and Evaluate Formulas to Find and Fix Errors
  3. Secure and Share Workbooks
    • Share a Workbook to Collaborate
    • How to Protect Excel Worksheets and Workbooks
  4. Validate Data and Automate Worksheets
    • How to Use Data Validation
    • Find Invalid Data and Formulas with Errors
    • Use Macros to Automate Tasks
  5. How to Use Sparklines and Map Data
    • Using Sparklines
    • How to Map Data in Excel
  6. Using Forecasting Tools in Excel
    • Use Data Tables to Determine Possible Outcomes
    • Use Scenarios to Determine Potential Outcomes
    • Using Goal Seek in Excel
    • How to Forecast Data Trends in Excel

Students should have attended, or have experience with the topics covered in the Microsoft Excel Introduction and Microsoft Excel Intermediate Training courses.

Live, Instructor-Led Online Class for INDIVIDUALS


  • Open Enrollment Class for Individuals
  • Live Class with an Instructor
  • Six Months of Instructor Email Support
  • Hands-on Exercises and Student Labs
  • Classes Never Cancelled Due to Low Enrollment
  • Money-back Guarantee
Click here to load this Caspio Online Database.

Live, Instructor-Led Online or Onsite Class for GROUPS

Contact Us For Quote

  • For Private Groups as small as 2 people
  • Live, Instructor-led Online or Onsite Class for your group.
  • Hands-on Exercises and Student Labs
  • Customizable
  • Six Months of Email Support After Class
  • Money-back Guarantee
Click here to load this Caspio Online Database.