What you'll learn:
- Build a repeatable data pipeline in Excel that reloads next month's file in one click, instead of redoing the work
- Filter rows, fix data types, split and remove columns, and add calculated columns in the Power Query Editor
- Write conditional IF rules inside Power Query to categorize your data without a single worksheet formula
- Merge two tables on a matching column, and append separate files into one table ready for analysis
- Group and summarize data with Group By, and write custom calculations inside the query itself
- Find and fix dirty data using Query Editor Diagnostics, so errors surface before they reach your report
- Load data from SQL Server, CSV, XML, JSON, web pages and Excel tables using the same repeatable workflow
- Choose where each query lands with the Load To option, and feed a cleaned table straight into Power Pivot
This course contains the use of artificial intelligence.
Every lesson in this course is written, created and recorded by me. AI is used only to help produce supporting images and written materials around the lessons.
Most people spend more time preparing their data than analyzing it. Power Query changes that. You build the cleaning and reshaping steps once, Excel remembers them, and next month's file takes one click instead of an afternoon.
If you are tired of repeating the same tidy-up every month, this is the course for you. It is two hours, it is Power Query only, and you will have a working, refreshable query before the end of section 2.
WHAT YOU WILL BUILD
Basic transformations - filter rows, fix data types, split and remove columns, add calculated columns, and choose where each query lands with the Load To option
Advanced transformations - merge two tables on a matching column, append separate files into one table, group and summarize, and write custom calculations inside the query
Conditional rules - categorize your data with IF logic in Power Query, without a worksheet formula
Data cleansing - find and fix dirty data with Query Editor Diagnostics, before it reaches your report
Connect to data sources - SQL Server, CSV, XML, JSON, web pages and Excel tables, all through the same workflow
A Power Pivot case study - feed a cleaned query straight into the data model
Every section sets a practical activity and then walks through the answer on video, and eleven training data files mean you are working on exactly the data I am.
MEET YOUR INSTRUCTOR
I have been training business people to work with data since 2008, and publishing on Udemy since 2013. I now have 16 live courses, more than 450,000 enrolments and more than 139,000 reviews, averaging 4.6.
I specialise in teaching business users the analysis methods behind the tools - Microsoft Excel, Copilot in Excel, Microsoft Power BI, Looker Studio and Amazon QuickSight. I teach the analysis, not just the software.
WHAT STUDENTS ARE SAYING
"Easy to follow. Ian explained the steps well, gave reasons for why certain things happen and some pitfalls you might encounter."
"This course is highly beneficial, especially for those who work with multiple dates and tables. It makes your job much easier."
"Great course for learning the basics of Power Query and to be able to apply it to current data I need to sort through more efficiently."
Ready to stop redoing the same work every month? Start with the first transformation and see how far two hours gets you.
