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.