Key features
- Connecting to External Data Sources - Learn how to import data from CSVs, folders, PDFs, and other structured files, including automating folder-based reporting.
- Cleaning and Transforming Data - Explore practical steps to reshape data: removing rows, splitting columns, changing data types, unpivoting, and more — all without formulas or VBA.
- Merging and Appending Queries - Combine data from multiple tables, match lists, and stitch together files with ease using the powerful Merge and Append tools.
- Loading to Excel and Beyond - Understand how to send your cleaned data to Excel tables, PivotTables, or the data model for seamless reporting and analysis.
By the end of the session, you’ll be equipped to automate repetitive tasks, prepare cleaner data for decision-making, and eliminate manual cut-and-paste jobs from your workflow — making Power Query an indispensable part of your Excel workflow.
