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
Download course outline

Upcoming Sessions

Date Time (AEDT) Location Available Spaces Cost
20 January 2025 09:30 am - 11:00 am ONLINE 5 $225.00
Group Bookings
Enrol
4 February 2025 09:30 am - 11:00 am ONLINE 5 $225.00
Group Bookings
Enrol
5 March 2025 12:00 pm - 01:30 pm ONLINE 5 $225.00
Group Bookings
Enrol
12 March 2025 02:30 pm - 04:00 pm ONLINE 5 $225.00
Group Bookings
Enrol
Enquire