Microsoft Excel Training – Level 3: Advanced

Course overview

This advanced Excel course builds on the concepts from Microsoft Excel Level 2 and focuses on data analysis, automation, and complex problem-solving. Participants will learn to use advanced tools such as data linking, consolidation, and outlining, as well as advanced PivotTable and Lookup functions. The course also covers What-If analysis, data validation, and the creation of form controls and recorded macros for automation.

Why take this course?

• Practical, workplace-focused content rather than theory
• Taught live by an experienced industry instructor
• Small class sizes with time for your questions
• Downloadable exercise files and reference guides

Who should attend?

• Anyone who wants to master advanced Excel features for data analysis, reporting and automation
• Analysts and finance professionals managing large datasets
• Report builders who want to automate repetitive tasks
• Completion of Microsoft Excel Level 2 (Intermediate) or equivalent knowledge is recommended

Learning outcomes

• Import, link and consolidate complex datasets across multiple workbooks
• Use advanced Lookup and PivotTable functions for comprehensive data analysis
• Perform scenario and What-If analyses to support strategic decision-making
• Apply data validation, grouping and outlining to manage large datasets efficiently
• Create form controls and recorded macros to automate repetitive tasks
• Design dynamic, interactive reports and Pivot Charts for professional data presentation

Course modules

Hands-on practical activities

• Guided hands-on lab with provided sample files

• Scenario-based exercise drawn from a real workplace task

• End-of-course mini project reviewed by the instructor

Software & tools used

What's included

• PowerPoint slides
• Hands-on exercises and practice files
• 30 days of post-course instructor email support

Career benefits

• Add a genuinely practical skill to your CV
• Save hours every week on repetitive work
• Contribute to digital projects with confidence
• Progress toward specialist or lead responsibilities

Next online sessions

Fixed weekday dates, one session each week. All times shown in AEST.

Schedule & pricing

Frequently asked questions