Microsoft Office Excel Advanced: Master Macros and Automation

Intended Organizations
Skill LevelAdvanced
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Smiling professional in a wheelchair holding a phone beside data monitors

Course Overview

The course covers the latest version of Microsoft Excel (2021–2024);
earlier versions are available upon request.

This course aims to provide you with advanced Excel knowledge and skills. You’ll learn to organize, calculate, analyze, revise, update, and present your data. It will also make these tasks much easier for you to accomplish and in much less time than if you used traditional pen-and-paper methods or non-specialized software.

Course Prerequisite: Microsoft Excel Intermediate

Learning Objectives

  • Work with multiple worksheets and workbooks.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Use lookup functions, dynamic arrays, and formula auditing.
  • Forecast data.
  • Create sparklines and map data.

Who It's For

  • Excel users who want to develop advanced spreadsheet and automation skills.
  • Professionals managing complex data across multiple worksheets and workbooks.
  • Analysts who need advanced lookup functions and formula auditing tools.
  • Employees responsible for workbook collaboration, data validation, and protection.
  • Professionals who want to forecast trends and visualize data more effectively.

Course Agenda

Six modules · 18 topics
1Multiple Worksheets and WorkbooksTopics 1–3
  1. Use Links and External References
  2. Use 3-D References
  3. Consolidate Data
2Sharing and Protecting WorkbooksTopics 4–5
  1. Collaboration on a Workbook
  2. Protecting Excel Worksheets and Workbooks
3Sharing and Protecting WorkbooksTopics 6–8
  1. Applying Data Validation
  2. Invalid Data and Formulas with Errors
  3. How to work with Macros
4Lookup Functions, Dynamic Arrays, & Formula AuditingTopics 9–12
  1. Using Lookup Functions
  2. Using Dynamic Arrays and Functions
  3. Trace Cells
  4. Watch and Evaluate Formulas
5Forecasting DataTopics 13–16
  1. Potential Outcomes Using Data Tables
  2. Potential Outcomes Using Scenarios
  3. Use the Goal Seek Feature
  4. Forecasting Data Trends
6Creating Sparklines & Mapping DataTopics 17–18
  1. Create Sparklines
  2. Map Data

About our Trainers

PTR training instructor headshot
PTR training instructor headshot
PTR training instructor headshot

Our Mission

Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.

Frequently Asked Questions

What is the Microsoft Excel Advanced course about?

This course develops advanced Excel skills for managing complex workbooks, automating tasks with macros, analyzing data, forecasting outcomes, and creating effective data visualizations.

Who should attend Microsoft Excel Advanced training?

The course is suitable for experienced Excel users, data analysts, finance professionals, and business professionals who want to work more efficiently with complex spreadsheets.

What is the prerequisite for this course?

Participants should complete Microsoft Excel Intermediate or have equivalent knowledge of intermediate Excel features.

Will I learn how to use macros in Excel?

Yes. The course introduces working with macros to help automate workbook functionality and reduce repetitive spreadsheet tasks.

Does the course cover advanced formulas and lookup functions?

Yes. You will learn to use lookup functions, dynamic arrays, and dynamic array functions, along with tools for tracing cells and evaluating formulas.

Does this course cover data validation and formula errors?

Yes. You will learn to apply data validation and work with invalid data and formulas containing errors to improve spreadsheet accuracy and reliability.

Can I learn forecasting and what-if analysis in Excel?

Yes. The course covers data tables, scenarios, Goal Seek, and forecasting data trends to help evaluate potential outcomes and support decision-making.

Discover More Ways to Build Your Skills

Microsoft Office Excel Advanced: Master Macros and Automation

Request a Training Quote

Share your team’s goals, and we’ll recommend the right skills training.