Power Query Training for Teams in Sydney, Brisbane and Online
- 100% customised for your teams
- Why learn with strangers? Your team, your pain points, our solutions
- Trusted by Westpac, TJX, NSW Government, NSW Fire & Rescue, Transurban, and many others
- Choose onsite in your office or virtual
- Use your sample business data during the course
- Please note, we do not cater to individuals
How Teams Use Power Query in Excel
- Automate messy data cleaning across multiple files
- Eliminate manual reporting in Excel
- Build refreshable datasets from raw exports
- Replace VLOOKUP-heavy workflows with Power Query
- Combine multiple data sources without formulas
Duration 1 Day
1 Day
Prerequisites
Participants should have as a minimum basic Excel knowledge including familiarity with formulas, cell referencing, and basic data manipulation.
Quick Glance
Participants will learn how to import, clean, transform, and normalise data using PowerQuery, enabling efficient data analysis and reporting workflows.
Power Query
Power Query for Excel Training
Master Power Query to clean and transform data for faster, smarter reporting. No more copying and pasting data between files, no more manual monthly report cleaning, no more broken formulas across spreadsheets.
Tables & Structured References
- Purpose and creation of Excel Tables
- Benefits of structured references
- Structured reference formulas in Tables
- Linking Tables between sheets
Get Data – Sources & Connections
- Importing from Excel Tables, CSV files, SharePoint Lists
- Connecting to Folder and SharePoint Folder
- Understanding dynamic growth with folder connections
Data Types & Column Tools
- Importance of correct data types
- Troubleshooting errors and inconsistencies
- Column Quality, Distribution, Profiling
- Replace Values, Replace Errors
Transform (Sanitise)
- Split by delimiter
- Format:
- Clean wrapping
- Trim spaces
- Lower, Upper, Capitalise each word
Extract text - Columns from example
- Pivot, Unpivot, Transpose
- Creating workable headers
- Working with Applied Steps
- Understanding the Applied Steps pane
- Renaming, reordering, and deleting steps
- Best practices for step management
Combine and Append
- Append tables for unified datasets
- Combine files from folders
- Practical walkthrough using SharePoint folder
Calculations, Formulas and Functions in PowerQuery Columns
- Basic arithmetic formulas
- Conditional formulas (If, Then, Else)
- Duplicate vs Reference Tables
- GroupBy Aggregate tables
Normalising Flat Files
- What is a flat file?
- Normalising into related tables
- Creating surrogate keys (indexing)
- Merging tables
- Loading and Refreshing
- Relationship modelling (Fact and Dimension tables)
Course Inclusions
What’s Included
Free Skills Assessment
Identify your current skill level before training begins.
Course Materials
Digital handouts, labs and exercises.
Expert-Led Training
Delivered by experienced qualified trainers with real-world corporate expertise.
Contextualised Content
Training can be tailored to your organisation’s needs and skill levels.
Hands-On
Practical activities to reinforce learning and build confidence.
Certificate of Completion
Recognising your achievement and new skills.
Our Clients
Our Clients
Power Query Training FAQS
What is Power Query training?
Power Query training teaches you how to import, clean, and transform data in Excel, helping automate reporting and improve accuracy.
What will I learn in a Power Query course?
You’ll learn how to connect data sources, clean and reshape data, combine datasets, and automate workflows for reporting.
Is Power Query Training suitable for beginners?
Yes, it’s suitable for beginners with basic Excel skills, and progresses into more advanced data transformation techniques.
Can the training be customised?
Yes, the training can be contextualised to your organisation’s data, and skill levels for practical, real-world use.
How long is a Power Query course?
Our Power Query for Excel training courses are delivered as a 1-day workshop focused on practical, job-ready skills.
Onsite Training
Roving Trainers
Virtual Training
Training Roll-outs
We're Here To Help!
Call Us
02 9454 7702
Hours
M-F: 9am - 5pm
S-S: Closed