Instructor
Mike Thomas
Category
MS Excel
Date
July 8, 2026
Time
1 PM EST | 10 AM PST | Wednesday | 90 Minutes
Review
Power Query - Automate Your Data Prep and Save Hours
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 You Should 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.
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 or Power BI 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.
SHRM Certified
HRtrainup is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for [1.00] PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org.
• 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.
Mike Thomas
Speaker
Mike Thomas is a leading UK-based IT Trainer and Content Creator renowned for his expertise in Microsoft Office, particularly Excel and Power BI. Throughout his distinguished 35-year career, Mike has delivered thousands of courses and produced an extensive library of written and video tutorials, available on his blog and YouTube channel. As a Microsoft MVP and Fellow of The Learning and Performance Institute, Mike has collaborated with numerous global and UK-based companies, providing tailored training and developing innovative Microsoft Office solutions that streamline business processes. His passion for teaching, knowledge-sharing and technology makes him a sought-after speaker and trainer, continually inspiring others to harness the full potential of Microsoft Office tools.
Write a Review
Customer Reviews
No reviews yet. Be the first to review!
Pricing Details
Membership Details
Become a member of our platform and you'll get a discounted ticket. All pricing has a membership rate attached to it. Check the prices.
Membership Plan