2-Pivot and Append | Excel Masters

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

2-Pivot and Append

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock