Microsoft Office Excel Advanced: Master Macros and Automation
Intended Organizations
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Skill LevelAdvanced
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Skill Level & Progression
Skill level reflects the recommended course experience and helps match training to your team's needs. Most training courses support all learning levels.
General WorkforceDevelops team-ready capabilities across business roles and experience levels while strengthening skills and organizational results.
FundamentalsBuilds introductory proficiency in essential terminology, core concepts, and workplace best practices for real-world application.
IntermediateStrengthens existing knowledge through advanced functions, skill strategies, and deeper exploration of core concepts.
Advanced(this course)Deepens expertise through complex subject matter, specialized skills, advanced analysis, and higher-level instruction.
Course Formats
Train on your terms. Choose virtual or onsite delivery, schedule sessions around your team’s availability, and align course content with your objectives and real-world challenges.
Virtual Training4 hours/day, 1 DayLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 1 DayEngaging, instructor-led training delivered in person at the location of your choice.
Course Duration
Course duration varies by training format and time needed to effectively cover the material, with hours per day and total days listed.
Generates a branded PDF — downloads directly to your device
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.
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
Use Links and External References
Use 3-D References
Consolidate Data
2Sharing and Protecting WorkbooksTopics 4–5
Collaboration on a Workbook
Protecting Excel Worksheets and Workbooks
3Sharing and Protecting WorkbooksTopics 6–8
Applying Data Validation
Invalid Data and Formulas with Errors
How to work with Macros
4Lookup Functions, Dynamic Arrays, & Formula AuditingTopics 9–12
Using Lookup Functions
Using Dynamic Arrays and Functions
Trace Cells
Watch and Evaluate Formulas
5Forecasting DataTopics 13–16
Potential Outcomes Using Data Tables
Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends
6Creating Sparklines & Mapping DataTopics 17–18
Create Sparklines
Map Data
About our Trainers
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.
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.
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.
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.