Data Cleaning & Automation with Power Query
Turn a multi-hour monthly consolidation into a one-click refresh.
Who it is for
Anyone who consolidates monthly files, exports or system downloads by hand.
You will learn
- Connect to Excel, CSV and folder sources
- Clean, split, merge and unpivot messy data
- Append monthly files automatically
- Merge queries as a robust alternative to lookups
- Build one-click refresh workflows
- Document steps for handover
Outcome
Turn a multi-hour monthly consolidation into a repeatable, one-click refresh.