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.

Snapshot

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
3 June 2024 09:30 am - 11:00 am Online 4 $195.00
3 July 2024 09:30 am - 11:00 am Online 5 $195.00
23 July 2024 12:00 pm - 01:30 pm Online 5 $195.00
6 August 2024 09:30 am - 11:00 am Online 5 $195.00
3 September 2024 09:30 am - 11:00 am Online 5 $195.00
9 September 2024 12:00 pm - 01:30 pm Online 5 $195.00