Power Query is one of the most powerful and transformative tools in Excel — and a must-have skill for anyone who works with data. In this session, we’ll explore how Power Query can revolutionise the way accountants and analysts prepare, clean, and combine data.
Designed for professionals who routinely deal with raw, messy, or repetitive data tasks, this session will guide you through the essential techniques that save time, reduce errors, and automate manual work — all with refreshable, repeatable steps.
This is session 2 of 3, you can purchase individual sessions or all 3 as a bundle for a discounted rate.
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.