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

$299.00 or 1 Token

Includes: Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts

  • 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

  • Importing and transforming text files into analysis-ready formats
  • Managing query steps with the Query Settings pane and Advanced Editor
  • Using Column From Examples to reshape and extract data
  • Merging and appending data from multiple files or lists
  • Unpivoting wide reports into filterable, normalized data structures
  • Cleaning problematic text (including non-breaking spaces) from web-based reports

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