Power Query in a Day
Discover the full potential of your data with Power Query - one of Excel's most powerful tools for data transformation and process automation.
In this special in-depth 2 half-day Masterclass,Microsoft MVP Wyn Hopkins focuses on real-world techniques, utilising the amazing functionalities of Power Query. You will streamline your data workflows and enhance your reporting capabilities.
Whether you're cleaning messy data, combining data from multiple sources, or building automated reports, Power Query empowers you to work faster and smarter. Best of all, you will do it all without writing a single line of code. By mastering Power Query, you’ll reduce manual tasks, eliminate data entry errors, and create repeatable processes that save hours every week.
What you'll learn?
- Introduction to Power Query: Understand the basics and interface.
- Data Importing: Learn how to import data from a range of different sources.
- Data Transformation: Master data cleaning techniques.
- Merging and Appending Queries: Combine data from multiple sources effectively.
- Creating Custom Columns: Use formulas to add new insights.
- Best Practices: Implement strategies for efficient and maintainable queries.
This Masterclass will be delivered by Microsoft MVP Wyn Hopkins on 16 & 17 Oct 2025 as an online-only course.
Who is it for?
This Masterclass is perfect for professionals who work extensively with data and who would like to improve the efficiency and accuracy in their workflows. Typical attendees include:
- Analysts who extract, re-organise and analyse data on a regular basis
- Accountants, interested in automating their month end processes in Excel
- Buisness Intelligence professionals connecting to data sources that are poorly organised
- Anyone interested in saving huge amounts of time when creating recurring reports and dashboards
Download Course Brochure
What's included?
-min.avif)
-min.png)
✔︎ What is “extract, transform, load,”?
✔︎ How data profiling works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data
✔︎ Avoid memory-draining “Frankentables” and build relational data models and reports right from Excel
✔︎ Power Pivot and DAX for data analysis in Excel
✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.
✔︎ Boost Excel with generative Ai and Copilot
✔︎ Use natural language propmpts to simplify Python scripting, uncover insights and streamline workflows for even faster and easier analytics
✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn basic Python scripting to build compelling analyses and visualizations that would otherwise be difficult or impossible to do in Excel
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Training requirements
Skills Requirements
- This is a beginner’s class. No previous knolwedge of Power Query will be expected.
- Previous knowledge of Excel, VLOOKUP / XLOOKUP / Pivot Tables is highly recommended.
Software Requirements
- This class will be delivered, using Microsoft Excel 365. For Excel 365 ensure you have a build version greater than 2023 (you can check via File > Account > the About Excel section contains the Version (2023 means March of 2022)
- Windows only (No Mac)
About the trainer
Wyn Hopkins
Wyn Hopkins has been a Microsoft MVP every year since 2017. He is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
Wyn gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
What people think of
Wyn Hopkins
★★★★★
This course is really helpful!
I would highly recommend it!
★★★★★
Once you see the magic, you cannot unsee it.
JUST DO IT! Any finance person who works with data must take this course.
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.
✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query
Delve into Excel's advanced features with special in-depth sessions from Microsoft MVPs & experts. Designed to equip you with some of the most sought-after workplace skills.
September 2025
✔︎ 15 & 16 Sep | 18:00-21: 00 BST - Modern Data Analytics in Excel (with George Mount)
✔︎ 16 & 17 Sep | 9:00-12:00 BST - Budget and Forecast Modelling in Excel (with Danielle Stein Fairhurst)
✔︎ 18 & 19 Sep | 9:00-12:00 BST - Automate Your Month End in Excel (with Mark Proctor)
October 2025
✔︎ 9 & 10 Oct | 18:00-21:00 BST - Advanced Charting in Excel (with Ann K. Emery)
✔︎ 14 & 15 Oct | 18:00-21:00 BST - New Ways of Solving Problems in Excel (with Chandoo)
✔︎ 16 & 17 Oct | 09:00-12:00 BST - Power Query in a Day (with Wyn Hopkins)
And don’t worry if you miss one – everything is recorded, so you can catch up any time.
Instantly unlock 35+ hours of premium content from 7 expert-led courses, featured in our 2025 Special Edition May/June Masterclass series.
May 2025
✔︎ Financal Modelling with Dynamic Arrays (with Danielle Stein Fairhurst)
✔︎ Automate Your Month End in Excel (with Mark Proctor)
✔︎ Python in Excel for Enhanced Data Analytics (with George Mount)
✔︎ Building Interactive Data Visualisations (with Carlos Barboza)
✔︎ Automate Excel with Office Scripts and Power Automate (with Mark Proctor)
June 2025
✔︎ Advanced Formulas in Excel Beyond the Basics (with Alan Murray)
✔︎ Building Power BI Reports the Right Way (with Gašper Kamenšek)
The Global Excel Summit has been verified as a CPD-accredited event three years in a row. and so are our in-person and online Masterclasses. This serves as credible proof of its reputation as a premium event.
✔ Gain up to 6 CPD points per Masterclass
✔ Boost your standing in a fiercely competitive job market
✔ Receive a CPD certificate
Get Product
-min.avif){kind=logo}
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
