Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master Power query
1-What is get and transform
1-Intro about get transform (2:20)
2-Power query Example (9:57)
3-Diffrence between Excel & power query (8:38)
exercise files
2-Working with quires
1-Query data from a table or range (3:05)
2-Import from file (1:32)
3-Query data from a folder and import multiple files (2:50)
4-Load data only as a connection (4:41)
3-Working with columns
1-Fill up and fill down (4:25)
2-Split Column by Delimiter (4:25)
3-Add conditional and custom columns (4:55)
4-Add Column by Example (3:28)
4-Working with formulas
1-Work with formulas in Get Transform (8:57)
2-Use IF formulas (3:01)
3-Use if with and (2:46)
4-Exact match equivalent of VLOOKUP (5:04)
5-Approximate match equivalent of VLOOKUP (3:25)
5-Pivoting and unpivoting data
1-Pivot data (1:52)
2-Pivot and Append (3:19)
3-Don-t Aggregate (2:36)
4-Unpivot (1:46)
6-Grouping
Grouping (2:47)
7-Appending a qurey
1-Append 2 Data Sets (2:17)
2-Multiple tables (2:38)
3-Combining tables with different headers (1:52)
Teach online with
3-Diffrence between Excel & power query
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock