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 | ||
| 17 May 2024 | 09:30 am - 11:00 am | Online | 4 | $195.00 | ||
| 3 June 2024 | 09:30 am - 11:00 am | Online | 5 | $195.00 |
Need a scalable, cost-effective solution to team training?
Try our Live Virtual Class Subscription. Access over 60 different training modules from just $10 per seat! Try it free for one month for you and one employee.