Skip to main content
Power Pivot and Power Query Essentials

Power Query

You probably spend a lot of time importing, cleaning and transforming data before you analyze it. In this course, you’ll learn how to speed up that process with a tour of the Power Query tool in Excel.

Intermediate        17 Lessons        120 Minutes        CPD Credits
Start Today

About This Course

When you know that your data is stored in the one place, is clean, and ready for analysis, you can spend more time on 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.

Start Today

Learning 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


1. Power Query Overview and Installation
2. Connecting to an Excel File
3. Connecting to a Folder
4. Pivoting and Unpivoting
5. Q&A - Connecting to Data
6. Data Types

Read More

7. Merging Queries and Columns Part 1
8. Merging Queries and Columns Part 2
9. Q&A - Unpivoting and Merging Queries
10. Filtering
11. Formatting Columns
12. Q&A - Filtering and Formatting Columns
13. Adding Custom Columns
14. The M Formula Language in Power Query
15. Editing and Loading Queries
16. Adding New Data
17. Q&A - Adding Columns and Managing Queries
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world