Excel - Power Query

Level - Advanced

Designed for users who work with complex or repetitive data tasks, this course shows you how to use Power Query to connect, clean and reshape information before analysing it in Excel.

You’ll learn to automate data preparation, apply transformation steps and work confidently with the M language.

Location

Date

Duration

Half-Day

Time (AWST)

Address

Participants

Total

What to expect

Power Query is a powerful tool for importing, cleaning and restructuring data from a wide range of sources. This course introduces you to the core workflow so you can automate preparation steps and bring data into Excel in a reliable, repeatable format.

You will learn how to connect to different data sources, apply transformations and reshape complex information using tools such as grouping, summarising, transposing and unpivoting. These techniques help streamline analysis and reduce manual effort, particularly when you work with large or frequently updated data sets.

The course also introduces basic Power Query formulas and the M language, giving you the foundation to customise queries and enhance data models through PowerPivot. By the end of the program, you’ll be able to build efficient, automated processes that support cleaner, more accurate analysis.

Is this course for you

This course is ideal for Excel users who work with large or complex data sets and want to automate extraction, cleaning and transformation using Power Query.

This course is suited to individuals who want to:

analyse large data sets efficiently
identify and summarise key insights
present information clearly for decision-makers
support informed and timely decisions through data

What you will explore

During this training course, you will develop practical skills to clean, transform and manage data efficiently using Power Query. The course focuses on connecting to multiple data sources, reshaping and summarising data, automating refresh processes, and understanding the basics of Power Query formulas and the M language to support reliable analysis.

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

Connect to a variety of data sources and extract data
Group and summarise information for analysis
Transpose and unpivot complex data sets
Automate refreshes to reduce manual handling
Understand basic Power Query formulas and the M language

Where this course can take you

During this training course, you will explore how to connect to and import data from multiple sources. You will learn how to use Power Query to clean, transform, and reshape data, including grouping, summarising, transposing, and unpivoting complex or inconsistent data for meaningful outputs.

The course also focuses on automating data refresh to support ongoing workflows and applying basic Power Query formulas. You will gain an understanding of the fundamentals of the M language and learn how to enhance transformed data through PowerPivot for deeper analysis and reporting.