Module 4 – Power Query

This Power Query workshop helps teams automate data cleaning, improve reporting workflows, and build confidence in managing larger Excel datasets.

This workshop builds on the previous sessions and is best suited for users already confident with Pivot Tables.

Who it’s for

• Users working regularly with Excel spreadsheets and datasets
• Anyone already familiar with Pivot Tables
• Users who want to automate repetitive data tasks and processes

What you’ll learn

• How to import and transform data using Power Query
• How to automate repetitive data preparation tasks
• How to clean and structure data efficiently
• How to prepare data for reporting and analysis

Training content (what we cover)

• Understanding what Power Query is and how it works
• Creating and managing Power Queries
• Transforming and cleaning data effectively
• Key techniques and best practices for Power Query
• Creating Pivot Tables from Power Query outputs

What this means in practice 💜

• Spend significantly less time preparing data
• Automate repetitive manual processes
• Work with large and complex datasets more efficiently
• Build a more structured and scalable reporting process

Details

• Duration: 3 hours
• Small group training (maximum 6 participants)