Excel: Introduction to Power Query: Easily Clean, Combine & Transform Data
Category: Technology | Date: 17/09/2025 12:00 | Duration: 1hr | Tag: WEBEC25ADD1 | Type: Webinar | Speaker: Alan Murray | Course level: Intermediate | Channel: ProfitPro
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 webinar Alan Murray will cover 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.
By attending this webinar, you will…
- Learn Power Query basics and its role in Excel.
- Be able to clean and transform raw data quickly without using formulas.
- Know how to automate repetitive data prep tasks and streamline your monthly processes.
- Be confident in handling messy or inconsistent data.
- Discover how Power Query improves accuracy and reduces manual effort.
This webinar will be of most interest to accountants, finance professionals, and business analysts who work regularly with data that requires cleanup and consolidation.
Course level: Intermediate
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.