What you'll learn:
- Import and connect data from multiple sources including SharePoint, CSV, web pages, and email
- Clean, reshape, and combine data from multiple Excel files and folders automatically
- Reduce repetitive data preparation work to a single click using Power Query's refresh capability
- Write custom Power Query M functions to handle transformations the interface alone can't do
- Build modern Excel dashboards using Power Query and Excel's Data Model
- Create error-resistant queries that handle messy, inconsistent, and changing data reliably
- Apply Power Query skills directly in Power BI to build and publish live reports
- Complete three real-world business projects including two interactive dashboards from scratch
If you work with data in Excel, Power Query will change how you work. Permanently.
Most Excel users spend hours on tasks that Power Query handles in minutes: cleaning messy downloads, combining files from multiple folders, transforming data from ERP systems, consolidating reports from different sources. Once you know Power Query, you won't go back to doing it manually.
This course takes you from zero to advanced, including writing custom M functions for scenarios the interface alone can't handle. Everything you learn applies directly to Power BI as well.
What you'll be able to do after this course:
Import and clean data from Excel files, CSV, web pages, SharePoint, databases, and Outlook
Combine and consolidate data from multiple workbooks or an entire folder automatically
Replace complex Excel formulas with repeatable, refresh-ready Power Query steps
Unpivot, reshape, and transform messy data into clean, structured tables
Write custom M functions to handle transformations the interface can't do on its own
Build a Data Model with relationships using Power Query and Power Pivot
Create interactive Excel dashboards powered by Power Query, Pivot Tables, and slicers
Use Power Query in Power BI and publish a live dashboard online
What makes Power Query worth learning right now:
Your steps are recorded. Every transformation you build runs automatically the next time you click Refresh. That means the 2-hour monthly report you dread becomes a 10-second task. The effort you put in once pays back every single time new data arrives.
This is also one of the highest-return skills you can add in Excel. Unlike VBA, you don't need to think like a developer. The interface does most of the work. You just need to know where to look.
What's inside:
This is a complete beginner to advanced course split into two parts.
The Essentials section covers everything you need to solve real data problems at work immediately: importing, transforming, combining, and loading data with confidence.
The Advanced section tackles complex real-world scenarios: messy data, custom M functions, Data Model integration, and full business projects from start to finish.
16+ hours of video content
3 complete business projects including 2 interactive dashboards
200+ practice workbooks with solution files
Downloadable course notes
Challenges and quizzes throughout
Who this is for:
This course works for complete beginners and experienced Excel users who have never used Power Query. If you already know the basics and want to go deeper into M language and advanced transformations, jump straight to the Advanced section.
Note: Power Query is available in Excel 2016 and above on Windows. It is not available on Mac.
Taught by Leila Gharani, Microsoft MVP, XelPlus founder, and trusted by 515,000+ students across 11 courses on Udemy.
Enroll now and build your first Power Query solution today.
