Excel – Introduction to Power Query

Whether you are working with large or small datasets, Power Query provides a simple and intuitive interface to help you clean and transform your data to meet your business needs.

Want to extract, transform, and load data from various sources to create meaningful insights? With Power Query, you can pull your data apart and make it beneficial to you by organizing, filtering, merging, and aggregating data from different sources.


Duration: 90 minute

Level: Experienced

Pre-requisites: Basic familiarity with Excel formulas

Version: Suitable for 2010, 2013, 2016 and Office 365

Learning outcomes

  • Reshape your data making it ready for Reports
  • Extracting blank columns and row
  • Change Cases
  • Remove Duplicates
  • Split data and more in essence cleaning up the data
  • Get your data ready for Pivot Tablet

Upcoming Sessions

Date Time (AEDT) Location Available Spaces Cost
19 June 2023 09:30 am - 11:00 am Online 5 $195.00
17 July 2023 12:00 pm - 01:30 pm Online 5 $195.00
4 August 2023 12:00 pm - 01:30 pm Online 5 $195.00