Excel: Introduction to Power Query: Easily Clean, Combine & Transform Data (Sep 25)
Category: Technology | Duration: 1hr | Tag: VODECADD1 | Type: Video | Course Level: Intermediate | Speaker: Alan Murray | Date: 17/09/2025 10:00
Course Details
Power Query is one of Excel’s most powerful tools—but it’s often overlooked. For accountants handling messy spreadsheets, performing manual adjustments and time-consuming data prep, Power Query has changed the game. This session shows you how to automate cleaning tasks, consolidate files in seconds, and prepare data with ease. Next time you need it, update the workflow with the click of a button.
In this course Alan Murray covers the following topics:
- How to import data from multiple sources including Excel, PDF, SharePoint, and a folder containing many files.
- Cleaning up data: removing and filling blanks, splitting columns, removing unwanted rows/columns, performing calculations, converting data types, and much more.
- Combining data from multiple files and sheets using Append and Merge.
- Creating reusable transformation steps that update automatically with new data.
- Using Power Query with Excel Tables and PivotTables for dynamic reporting
CPD Course Speaker
Computergaga
Alan Murray
Alan Murray is an experienced Excel trainer and Microsoft MVP. With over 23 years of experience as an Excel trainer, he helps users build confidence and expertise in Excel and Power BI - empowering them to solve problems, automate tasks, and work more efficiently.
Alan is the author of the ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books and has a YouTube channel – named Computergaga – with 118,000+ subscribers and over 50 million views.
He organises the London Excel Meetup group to provide a community event for professionals to network, share, and develop their Excel skills.
Alan loves showing people what’s possible with the tools they already have. His training approach is relaxed, practical, and always focused on the needs of the people in the room. Everyone should feel confident using Excel and empowered to ask any question - no matter how simple or advanced.
Alan is the author of the ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books and has a YouTube channel – named Computergaga – with 118,000+ subscribers and over 50 million views.
He organises the London Excel Meetup group to provide a community event for professionals to network, share, and develop their Excel skills.
Alan loves showing people what’s possible with the tools they already have. His training approach is relaxed, practical, and always focused on the needs of the people in the room. Everyone should feel confident using Excel and empowered to ask any question - no matter how simple or advanced.