1 – Get Data
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
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 – Grouping Queries
Grouping data
5 – Combining Queries
Multiple tables
Combine tables with different headers
6 – How to perform JOINS on tables
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
VLOOKUP in Power Query
Share
Share "VLOOKUP in Power Query"
Share a link to someone who will get access to this lesson for 24 hours.
Share "VLOOKUP in Power Query"
Share a link to someone who will get access to this lesson for 24 hours.
In this lesson we learn how to work with VLOOKUP in Power Query. In chapter 6 we thoroughly go through the the concept of connections.