Excel - Advanced

Level - Advanced

Master Excel’s advanced features for greater productivity.
If you’re ready to lift your Excel capability, this course shows you how to manage complex data with speed and confidence.

You’ll work with advanced functions, PivotTables, macros and automation tools to streamline analysis, reporting and decision making.

Location

Date

Duration

2 Days

Time (AWST)

Address

Participants

Total

What to expect

Advanced Excel skills can transform the way you manage, analyse and present information. This course builds on your existing knowledge and introduces the functions and tools used to handle large data sets, create efficient workflows and produce clear, meaningful insights.

You will explore advanced formulas, logical and lookup functions, outlining techniques and database operations that help you summarise, filter and refine data quickly. Guided practice with PivotTables, PivotCharts and automation tools gives you the confidence to work at a higher level and reduce manual effort.

Across the day, you will apply these techniques to realistic scenarios and learn how to consolidate information, design visual reports and automate repeat tasks with macros. You will leave with practical skills that support faster analysis and clearer reporting.

Is this course for you

This course is ideal for Excel users who already feel confident with intermediate features and want to expand into advanced techniques for greater productivity and insight. It is particularly useful if you need to handle large data sets, summarise numeric information, drill into details, filter and group subsets of data or use automation to streamline reporting.

This course is suited to individuals who want to:

work confidently with large data sets
summarise and analyse numeric information effectively
drill into, filter, and group subsets of data
use automation to streamline reporting and analysis

What you will explore

During this training course, you will develop advanced Excel skills to analyse, automate and streamline complex data and reporting tasks. The course focuses on using advanced functions, PivotTables, macros and automation tools to consolidate information, improve accuracy and support more efficient decision-making.

By the end of this training course, you should be able to:

Use advanced functions to develop complex worksheets
Analyse data sets using PivotTables and automation tools
Consolidate and summarise results from multiple worksheets
Record and repeat tasks by creating macros
Apply advanced techniques to streamline reporting and decision making.

Where this course can take you

During this training course, you will explore advanced Excel functions across logical, lookup and reference, statistical, and date and time categories. You will develop skills in creating outlines to summarise worksheet data, sorting data and using database tools, and applying the Subtotal command and function alongside AutoFilter and Advanced Filter.

The course also focuses on creating and manipulating PivotTables and PivotCharts, and consolidating worksheet data from multiple sources. You will learn to record and run macros, including combining data macros, add toolbar buttons, view VBA code, and create hyperlinks to files, web pages and workbook locations.