• Module 1: Introduction to Power Query
• Module 2: Connecting & Importing Data
• Module 3: Cleaning & Standardising Data
• Module 4: Managing Data Types
• Module 5: Transforming Columns
• Module 6: Reshaping Data for Analysis
• Module 7: Combining Data with Append
• Module 8: Combining Data with Merge
• Module 9: Automating Multiple Files & Worksheets
• Module 10: Creating Custom Transformations
• Module 11: Grouping & Aggregating Data

Turn messy data into reliable information—and repetitive preparation into a refreshable process.

This practical, 2-day intensive course equips participants with the skills to use Microsoft Power Query to clean, standardise, transform and combine data for business analysis and reporting. Through guided exercises and realistic workplace examples, participants will learn to replace time-consuming manual steps with repeatable processes that improve consistency, reduce errors and accelerate data preparation.

Covering the complete journey from importing raw data to producing management summaries, the course develops participants’ confidence in consolidating files, resolving common data issues, applying business rules and preparing structured datasets for PivotTables and reporting. Participants will leave ready to apply these techniques to recurring tasks across finance, HR, administration, sales and operations.

1. Saving time on repetitive data preparation by building reusable queries that apply the same cleaning and transformation steps whenever source data is refreshed.
2. Turning messy spreadsheets into analysis-ready datasets by removing duplicates, managing missing values and errors, and standardising inconsistent text.
3. Importing and organising data with confidence from Excel worksheets, tables, CSV files and text files for a more efficient reporting workflow.
4. Resolving frustrating date and number issues by applying appropriate data types and locale settings to support accurate calculations and reporting.
5. Transforming awkward report layouts into usable tables by splitting and merging columns, extracting information, filling gaps, and pivoting or unpivoting data.
6. Consolidating monthly, departmental and regional data faster by appending multiple datasets into a consistent table without repetitive copying and pasting.
7. Matching information across tables more effectively by using Merge Queries to bring related records together, identify unmatched items and reduce reliance on repeated lookup formulas.
8. Streamlining recurring file consolidation by combining files from folders and applying established preparation steps as new reporting files become available.
9. Applying business rules consistently through conditional columns, custom calculations and text or date transformations tailored to workplace requirements.
10. Producing useful management summaries by grouping data and calculating totals, counts, averages, minimums and maximums across relevant business categories.
11. Improving the consistency and traceability of reporting data through recorded transformation steps, validation checks and retained source file information.
12. Spending less time preparing data and more time interpreting results, with structured datasets ready for PivotTables, analysis and business reporting.

• Executives and Managers
• Administrative and Operations Personnel
• Finance and HR Personnel
• Data Analysts and Reporting Personnel
• Excel users who regularly clean, combine or prepare data
• Anyone who wants to automate repetitive data preparation tasks

• Trainer-led Guided Learning, group-paced, hands-on classroom training with real life examples for business applications.
• Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc.