Power Query
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Power Query Overview and Installation
Power Query Overview and Installation
Like Power Pivot, Power Query is not available in every version of Excel. Learn which versions are compatible and how to access Power Query in this lesson.
Connecting to an Excel File
Connecting to an Excel File
An advantage of Power Query is its ability to connect to various different data sources. In this lesson, we will import a single Excel file into Power Query.
Connecting to a Folder
Connecting to a Folder
In addition to connecting a single Excel file, it is possible to connect a folder of files to Power Query. See how this works in this lesson.
Pivoting and Unpivoting
Pivoting and Unpivoting
Often the data we import to Power Query has many columns and few rows, when we would prefer to have few columns and many rows. We can solve this problem by unpivoting columns, which we will see in this lesson.
Q&A - Connecting to Data
Q&A - Connecting to Data
This lesson reviews information around accessing Power Query and connecting to data.
Data Types
Data Types
In Power Query, every column of data must have a type. In this lesson, we'll learn about the different available types, how types can be assigned in Power Query and what types are used for in Power Query
Merging Queries and Columns Part 1
Merging Queries and Columns Part 1
When importing data from multiple sources, you can often find you have multiple queries you would like to merge. In this lesson, we will add a new dataset and look at how we can merge it with our existing data.
Merging Queries and Columns Part 2
Merging Queries and Columns Part 2
In order to merge our queries, we need to create a unique ID column. We can do this by merging columns together, which we will see in this lesson.
Q&A - Unpivoting and Merging Queries
Q&A - Unpivoting and Merging Queries
This lesson will review information around unpivoting columns, changing data types, and merging columns and queries.
Filtering
Filtering
If your data includes more rows than you actually need, you can use Power Query's extensive filtering capabilities to see only the data you need to use.
Formatting Columns
Formatting Columns
In this lesson, we will look at more things you might do with columns, such as splitting columns, replacing values and removing columns
Q&A - Filtering and Formatting Columns
Q&A - Filtering and Formatting Columns
This lesson will review information around filtering columns, splitting columns, and the find and replace function.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
