Automate Your Data Cleaning with Power Query

**Please note: This workshop will be held across two days on December 16th and 17th.**

Take your Excel skills to the next level by learning how to automate your data cleaning process using Power Query, Excel’s most powerful yet underused tool. Designed for professionals who already know their way around Excel but want to save hours of repetitive work, this workshop will show you how to transform messy datasets into clean, analysis-ready files—with just one click.

Led by experienced instructors who use Power Query daily in their own analytics work, this two-day, hands-on workshop will guide you through practical automation techniques such as:

• Merging datasets from multiple sources into one seamless table

• Splitting and restructuring columns for better organization and analysis

• Creating conditional and custom fields to simplify transformations

• Appending new data automatically without rebuilding your analysis

• Documenting and rerunning cleaning steps to make your process repeatable and error-free

Through live demonstrations and real-world datasets, you’ll learn by doing—building workflows that automatically clean and update your data whenever new information arrives. By the end, you’ll have the skills to replace hours of manual cleaning with efficient, repeatable processes that make your analyses faster and more reliable.

This workshop is ideal for evaluators, researchers, and analysts ready to stop wasting time on tedious data prep and start focusing on what matters most: analyzing and interpreting results. Our supportive, step-by-step approach ensures you’ll leave with both the confidence and capability to automate your work in Excel.

Don’t just work in Excel—let Excel work for you. Enroll in Automate Your Data Cleaning with Power Query and discover how to build a smarter, more streamlined analytics workflow.

What our attendees are saying:
"Your approach to data cleaning completely changed how I handle messy files. I’ve saved hours every week since taking this class."
"I finally understand Power Query! The hands-on examples made everything click... literally."