Excel: Stop Cleaning Data Manually Let Power Query Do It

  • Wednesday
  • October
  • 8
  • 2025
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
90 Minutes
Mike Thomas Instructor:
Mike Thomas
Webinar Id:
54141

More Trainings by this Expert

Price Details
$149 Live
$299 Corporate Live
$199 Recorded
$399 Corporate Recorded
Combo Offers
Live + Recorded
$299 $348 Live + Recorded
Corporate (Live + Recorded)
$599 $698 Corporate
(Live + Recorded)
Price Detail Options
Overview:

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.

Why should you Attend: 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.

Areas Covered in the Session:

  • 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

Who Will Benefit:
  • 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
    • Anyone handling recurring data tasks. No coding or Power BI knowledge is required


Speaker Profile
Mike Thomas - In a career spanning over 30 years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.

He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.

Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.

In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes


You Recently Viewed