08 6210 8500
Pay my invoice
This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query.
Power Query is Excel’s best feature and it’s also key to the popularity of Power BI. It gives Excel and Power BI analysts the power to draw information out of multiple sources, link it together and perform calculations on it that can then be sliced & diced any way you want.
The course covers the core elements needed to get an understanding of what Power Query can do and how to apply multiple techniques to convert messy data into clean tables for analysis.
What you get from this course
- Be able to import data from a variety of disorganised layouts to quickly deliver key information in minutes not weeks
- Utilise best practice techniques
- Provides a solid framework and rules to allow you to automate your reporting and analysis immediately on returning to work.
Agenda Highlights
Pre-requisites
This is a beginner’s course and assumes attendees have no prior knowledge of Power Query.
Previous use of Excel, VLOOKUP / XLOOKUP / Pivot Tables or Power BI would be considered a sensible base level of experience to get the most from this course.
The exercises will be conducted using the desktop version of Excel 365 or Power BI desktop. The techniques are the same in both with minor User Interface differences.
Software Required
Excel 365 or Power BI Desktop
Download and install the free Microsoft Power BI Desktop
For Excel 365 ensure you have a build version greater than 2203 (you can check via File > Account > the About Excel section contains the Version (2203 means March of 2022)
Windows only (No Mac)
Who Should Attend
- Excel users & analysts that focus on extracting, re-organizing and analysing data
- Power BI users connecting to data sources that are poorly organised
- Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards
Delivery Options
Previous Training Courses
Why Choose Access Analytic?
At Access Analytic, we don’t just provide training and consulting—we lead the industry. With a 25-year track record of excellence, we are the trusted choice of top global companies for training and consulting in Power BI, advanced financial modelling, data analytics, and AI-driven business solutions.
Industry-Leading Expertise
Our Course Facilitators are internationally recognised thought leaders, speaking at major conferences around the world. One of our directors has been a Microsoft MVP for over seven years—and is the only combined Excel and Data Platform MVP in Australia—highlighting our elite-level expertise.
Global Reach, Local Presence
We deliver world-class training across Australia, Oceania, the South Pacific, the Middle East, Africa, and Asia, helping professionals and organisations harness the power of Power BI, Excel, and AI. Our expertise extends beyond consultancy—we train and educate thousands of professionals worldwide.
Top-Ranked YouTube Channel
We run one of the world’s top YouTube channels for Power BI and Excel, where thousands of professionals look to us for cutting-edge insights and practical expertise.
Trusted by the Biggest Names
Many of the world’s most trusted and respected companies rely on Access Analytic for innovative, data-driven solutions. Our vast experience across industries means we bring the best global ideas and strategies directly to your business.
Elite Team,
No Juniors
We only give you highly experienced facilitators. Every Facilitator assigned to your training course will have the right mix of expertise in areas such as Power BI, finance, AI, best-practice financial modelling, and data analytics. Our team’s depth of real-world knowledge ensures your business benefits from proven insights that streamline processes, enhance decision-making, and deliver measurable results.
Perth-Based, but Borderless Support
Our team is locally based in Perth, but we run courses all around the world.
Setting the
Standard
At Access Analytic, we don’t just keep up with the industry—we set the standard. Partner with us for world-class expertise, cutting-edge solutions, and long-term success.
Meet Our Speakers
Our Clients
Client testimonials
We are thrilled to have helped hundreds of businesses in Perth and worldwide over the years.
Head of Analysis large multinational client
Chevron Employee
Other courses you might be interested in
Trusted by the Biggest Names
Many of the world’s most trusted and respected companies rely on Access Analytic for innovative, data-driven solutions. Our vast experience across industries means we bring the best global ideas and strategies directly to your business. At Access Analytic, we don’t just keep up with the industry—we set the standard. Partner with us for world-class expertise, cutting-edge solutions, and long-term success.
Contact us today to learn more about our Power BI training options