Power Query Essentials

1 – Get Data
7 Lessons
Get & Transform
00:53 min
Get Data
02:12 min
Get data from a different Excel file
01:11 min
Get data from Folder
01:59 min
Load as a Connection
01:49 min
Get data from Web page
02:02 min
External Data Sources
2 – Basic data transformation
3 Lessons
Fill up and down
01:41 min
Split by Delimiter
01:32 min
Custom and Conditional columns
02:45 min
3 – Functions in Power Query
4 Lessons
Formulas and Functions in Power Query
01:59 min
IF Functions
01:22 min
IF & AND formulas
01:32 min
VLOOKUP in Power Query
01:39 min
4 – Grouping Queries
1 Lesson
Grouping data
01:53 min
5 – Combining Queries
2 Lessons
Multiple tables
01:39 min
Combine tables with different headers
01:16 min
6 – How to perform JOINS on tables
8 Lessons
Joining
Full Outer Join
01:38 min
Inner Join
01:30 min
Left Anti Join
01:21 min
Right Anti Join
01:21 min
Left Outer Join
01:40 min
Right Outer Join
01:41 min
Combining multiple fields
02:01 min
Quiz – Power Query

Formulas and Functions in Power Query

Power Query Essentials 3 – Functions in Power Query Formulas and Functions in Power Query

In this lesson we will learn how we work with functions in Power Query. Follow the link to find the many functions available in Power Query:

Lesson file
Previous Chapter
Back to Chapter
Next Lesson