Data Cleaning and Transformation with Power Query
About This Course
Power Query is a practical data preparation and automation tool built into Microsoft Excel and Power BI. This course equips participants with hands-on skills to clean, reshape, and combine data from multiple sources, helping to reduce manual effort and improve data accuracy in everyday work.
Designed for working professionals who handle data regularly, the course focuses on guided practice using realistic workplace datasets. Participants will learn how to build simple, repeatable data transformation workflows that can be applied directly to reporting, consolidation, and analysis tasks, with support from Generative AI tools to speed up and simplify the process.
The course emphasises practical demonstrations and scenario-based exercises that reflect common data challenges faced by organisations.
What You'll Learn
1. Describe the role of Power Query in preparing and organising data.
2. Import data from common sources such as Excel, Comma-Separated Values (CSV), and web links.
3. Apply core cleaning and transformation steps using the Power Query Editor.
4. Build simple, repeatable workflows to automate data preparation tasks.
5. Combine datasets using basic merge and append techniques.
6. Use basic M expressions to customise selected transformations.
7. Export cleaned data for reporting or further analysis.
Entry Requirements
Basic proficiency in English, numeracy, and computer skills (Microsoft Excel).