Essential Basic Powerquery Skill
-
Home Tab - How to use GroupBy (10:56)
-
Home tab > Append Queries (7:09)
-
Home Tab > MergeQueries ...just like VLookup but faster (2:57)
-
Home Tab > Merge Query - Get All Sales from Each Customer (5:00)
-
Transform Tab > Unpivot Columns and Pivot Columns (3:25)
-
Duplicate Query - Add As New Query (6:11)
-
Add Column Tab > Index Column (2:50)
-
Using Index Column - Turn Area Code from Single Column to 2 column Like Transpose (3:32)
-
Using Fill Down - Saving tons of hours of data cleasing work for Shopee/Lazada seller (3:10)
-
Data Transformation using FIll Up Conditional Column (3:07)
-
Combine Both Columns value into Single Column on Condition (3:27)
Some cool Powerquery ideas
0 comments