Microsoft Excel Power Query
(2013, 2016, 2019, 2021, 365)
What You'll Learn in Microsoft Excel Power Query
Course Length
Learning Objectives
- Connect to data sources
- Transform and cleanse data
- Send Power Query data to other destinations
- Pivot and transpose data
- Group Power Query data
- Create calculated columns
- Understand Power Query parameters
Target Student
This course is for individuals who are familiar with the basics of Excel and who wish to further their learning about Power Query.
Course Outline
Microsoft Power Query is a free tool provided by Microsoft for Excel users. Power Query is available for all users of Excel and in 2016 it was renamed to “Get & Transform”. It is a tool for reshaping and combining your data and can connect directly to Excel, Access, Text, CSV and many other different sources of data.
In this course, you will become familiar with Power Query and its advanced selection of features. You will learn how to connect to external data sources, transform and cleanse your data, pivot and transpose your data, and create custom calculated columns.
Section 1: Getting Started
Introduction to Power Apps
Versions and Compatibility
The Power Excel Workflow
When to Use Power Query and Power Pivot
What Is Power Query?
Power Query Interface
Section 2: Connecting to Data Sources
Introduction to Connecting to Data Sources
Loading Data from an Excel File and Excel Table
Loading Data from a Text File
Loading Data from a Database
Loading Data from a Folder
Loading Data from the Web
Section 3: Transforming and Cleansing Data
Introduction to Cleansing Data
Editing Queries
Editing Column Headers
Understanding Data Types
Splitting Column Data
Replacing Data
Sorting and Filtering Data
Removing Duplicates from a List
Using the Fill Command
Section 4: Sending Power Query Data to Other Destinations
Loading to an Excel Workbook
Loading to a Data Model
Power Query Load Settings
Power Query Refresh Settings
Deleting Power Queries
Section 5: Pivot and Transpose Data
Transposing Query Data
Pivoting and Unpivoting Column Commands in Action
Section 6: Grouping Power Query Data
Duplicating a Query
Grouping and Summarizing Data
Advanced Data Grouping
Section 7: Creating Custom Calculated Columns
Creating Conditional Columns
Creating a Date Calculation
Creating a Custom Column Calculation
Creating an Index Column
Section 8: Working with Multiple Data Sources
Working with Multiple Excel Tables
Understanding Table Relationships
Merging Queries
Appending Queries
Section 9: Advanced Transformations
Understanding the Importance of Clean, Organized Data
Converting Columns to Rows
Cleaning Up Nested Data
Delivered by Great Canadian Training
Microsoft Excel Power Query
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| March 12, 2025 9:00 AM to 4:00 PM ET | $495.00 Online | |
| June 19, 2025 9:00 AM to 4:00 PM ET | $495.00 Online | |
| October 8, 2025 9:00 AM to 4:00 PM ET | $495.00 Online |
Groups of 6 or more? Consider private training
I want a quote for private or customized training
Have questions about this course? See below or reach out to our training coordinators.
The Great Canadian Training & Consulting Company Advantage
When you train with us, your training will not just check a box. We make sure it is GREAT!
- Experienced Trainers
- Learn or Come Back Free Policy on Public Classes
- 24/7 After Training Support
All of our courses include
PDF Reference Guide
Want a summary of what you’ve learned? Save paper and use your PDF Reference Guide, accessible on any of your devices.
Certificate of Completion
Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.
24/7 After-Training Support
Receive a 30-day after-training support voucher, offering assistance as you apply your new skills on the job. Need help with a specific step? We’re here to provide extra support and clarity even after you’ve left the class!
Want even more?
Check out our add-ons
Printed Reference Guide
While we love technology, we understand that there is something about having a paper copy. Add a printed reference guide to your training, which we will have shipped to your location.
Extended After-Training Support
Extend your support beyond the standard 30 days for ongoing assistance.
Upskilling
You’ve learned how to effectively and efficiently use Microsoft Excel Power Query - now you can stay up to date! Book your Upskilling Workshop now and save for when you want to fill in the gaps and explore Microsoft’s latest tools and features.
Can I customize my course?
OF COURSE!
Customized to meet your unique needs
We can customize your training to fit your exact needs, whether it's making small adjustments or creating entirely new courses. From setting specific objectives and including your own files to addressing unique challenges, we're here to help. We can even tailor the training to align more closely with how you work and to fit perfectly into your schedule. Our goal is to provide training that's as unique as your goals.
Use your own files instead of our exercise files
You can opt to use your working files in your private training sessions (instead of our standard exercise files). This allows you to see how the lessons apply directly to your day-to-day role and get work done while you train—a true win-win!
Access to your recorded session for 60 days
You can request your private session be recorded. You can have access for 60 days to revisit what you’ve learned.