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.
About this Course
When you know that your data is stored in one place, is clean, and ready for analysis, you can spend more time mining for insights. Power Query helps to prepare your data before you begin working with it. This course will guide you through the tool’s use.
Across 17 lessons, you’ll learn how to create a query, edit and manipulate it, merge it with others, and run the query to best serve your needs.
By the end of this course, you’ll feel confident in prepping your data before importing it to Excel, where your analysis can begin.
Who Should Attend?
This course is suitable for intermediate learners who are familiar with Microsoft Excel. It is best suited to accountants, management consultants, analysts, and other business professionals.
Course Overview
This Kubicle course contains 17 lessons, 3 exercises, and 1 exam. It covers the following topics:
- Power Query Overview and Installation
- Connecting to an Excel File
- Connecting to a Folder
- Pivoting and Unpivoting
- Q&A - Connecting to Data
- Data Types
- Merging Queries and Columns Part 1
- Merging Queries and Columns Part 2
- Q&A - Unpivoting and Merging Queries
- Filtering
- Formatting Columns
- Q&A - Filtering and Formatting Columns
- Adding Custom Columns
- The M Formula Language in Power Query
- Editing and Loading Queries
- Adding New Data
- Q&A - Adding Columns and Managing Queries
Key Outcomes
- Connect to files or folders in Power Query
- Pivot and unpivot a dataset
- Adjust the types of your data
- Merge columns of data and merge queries
- Filter and format your data
- Add custom columns to a dataset
- Load queries into Excel
- Refresh a query when the underlying data updates
Contact Us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930.