Power Query: Getting Started
OVERVIEW
Duration: 90 minutes
Delivery method: Online via Zoom
Tired of manually tidying up spreadsheets every week? Power Query does the heavy lifting for you, turning tedious tasks into one-click refreshes. If you're spending hours cleaning and preparing data for reports, dashboards, or analysis, this session will show you how to reclaim that time with tools that work smarter, not harder.
If your spreadsheets are full of inconsistent data, awkward formatting, or endless copy-paste routines, you need Power Query! Power Query is Excel’s powerful data-cleaning and automation tool, designed to handle messy, repetitive tasks in a fraction of the time.
In this session, you’ll learn how to transform raw, inconsistent spreadsheets into clean, structured data that’s ready for analysis. No formulas, no VBA, just a smarter way to combine, reshape, and clean up your data using Power Query’s user-friendly interface. From removing duplicates and fixing column issues to combining data from multiple sheets or files, you’ll see how much time (and frustration) Power Query can save you.
TOPICS COVERED
- What Power Query is and where to find it in Excel
- Connecting to and importing data from spreadsheets and other sources
- Cleaning and transforming data without formulas
- Removing duplicates, fixing column headers, and splitting/merging columns
- Combining data from multiple sheets, files, or folders
- Automating routine data preparation steps with queries
- Refreshing data at the click of a button
This session is perfect for Excel users at an intermediate level who regularly work with reports, exports, or large datasets that require cleaning or restructuring. It's especially valuable for analysts, HR and finance professionals, admin teams, and anyone handling recurring data tasks. No coding knowledge is required.
You’ll need Excel 365 or Excel 2016 or later. Note: Power Query is available in Excel for Mac, although some features differ from the Windows version. However, Mac users will still benefit from the concepts, techniques, and time-saving workflows covered in this session.
Recording Included: The price includes lifetime access to a recording of the session so you can watch it again whenever you like, or catch up if you’re unable to attend live
Private One-Company Sessions
For private one-company courses I don't charge per-person.
Whether you send 5 or 50, a 90-minute session has a flat price of £300 GBP (that's approx. $400 USD for US-based folk).
If you'd like to organise a session, please get in touch.
Public Scheduled Sessions
Prefer to join a scheduled session instead? This course is occasionally run as an open session. See below for upcoming dates.
Price: £97 per person (approx $130 USD)
Note: The time displayed is in your timezone