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
Pre-requisites: Basic familiarity with Excel formulas
Version: Suitable for 2010, 2013, 2016 and Office 365
- 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
|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|