Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This is an intermediate course, but does not require any prior knowledge of Power Query. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to learn how to use Power Query.
Course Overview
This Kubicle course contains 15 lessons, 3 exercises and 1 Exam. It covers the following topics:
- Power Query Overview
- Connecting to an Excel File
- Connecting to a Folder
- Pivoting and Unpivoting
- Data Types
- Merging Queries and Columns
- Filtering
- Formatting Columns
- Adding Custom Columns
- The M Formula Language
- Editing and Loading Queries
- Adding New Data
Key Outcomes
Once you’ve completed this course, you’ll understand how to transform a dataset into a suitable form for analysis. You’ll understand the common steps and transformations needed to clean up a dataset, and how to apply those steps in Excel using Power Query.
By applying the skills you’ll learn in this course, you’ll greatly improve your productivity as an analyst. You’ll be able to spend less time preparing data for analysis, and spend more time actually analyzing it and generating insights from it.