Loading...

Excel Explained: Power Query for Everyday Data Cleanup

Excel Explained: Power Query for Everyday Data Cleanup shows you how to transform messy, real-world data into clean, analysis-ready datasets—without complex formulas. Learn how to automate repetitive cleanup tasks and prepare data for reporting with confidence.
Upcoming
Beginner Friendly
DATE

Monday, October 26, 2026
2:30 pm - 4:30 pm

INSTRUCTOR

David Ringstrom

FORMAT

Webinar

  • Auditing
  • Branch Manager
  • Commercial Lender
  • Compliance Officer
  • Consumer Lender/Retail Banker
  • Controller/Accountant
  • Credit Analyst
  • Deposit Operations Manager/Specialist
  • Internal Auditor
  • IT Professional
  • Loan Operations Manager/Specialist
  • Mortgage Lender
  • Risk Manager
  • Senior Management
  • Training Manager
  • Trainer

Save on annual training costs with our Webinar Subscription Service and share webinars across your entire organization.

Become a subscriber

Learn about upcoming events, webinars and discounts.

Sign Up For Email Notifications

Power Query is one of Excel’s most powerful tools for importing, cleaning, reshaping, and combining data from multiple sources. In this session, you’ll learn how to transform text files into PivotTable-ready formats, reshape wide reports into filterable rows, and extract data into structured columns using practical, repeatable techniques.

You’ll also explore merging and appending data from multiple files, managing query steps with the Query Settings pane and Advanced Editor, and resolving common data issues such as non-breaking spaces from web-based reports. By the end of the session, you’ll understand how to streamline lookups, reduce manual cleanup work, and build refreshable processes that save time on recurring reports.

What You'll Learn

  • What You'll Learn to be Added.
  • Bullet Point
  • Bullet Point
  • Bullet Point
  • Bullet Point

    • Who Should Attend

    Banking professionals and Excel users who regularly clean, combine, or prepare data for reporting and want to automate repetitive data transformation tasks.
    David Ringstrom

    Instructor Bio

    David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant, educator, and speaker. He has presented more than 2,500 live webinars to professionals nationwide.


    David is the author or co‑author of ten books, including Microsoft 365 Excel For Dummies, Exploring Microsoft Excel’s Hidden Treasures, QuickBooks Online For Dummies, and Idiot’s Guide to Introductory Accounting.


     


     

    Print this page