Your Instructor
My mission is to help Finance/Account staff to go home earlier by preparing report faster, reduce at least 20% of their time.
Course Curriculum
Essential Basic Powerquery Skill
Available in
days
days
after you enroll
-
PreviewHome Tab - How to use GroupBy (10:56)
-
StartHome tab > Append Queries (7:09)
-
StartHome Tab > MergeQueries ...just like VLookup but faster (2:57)
-
StartHome Tab > Merge Query - Get All Sales from Each Customer (5:00)
-
StartTransform Tab > Unpivot Columns and Pivot Columns (3:25)
-
StartDuplicate Query - Add As New Query (6:11)
-
StartAdd Column Tab > Index Column (2:50)
-
StartUsing Index Column - Turn Area Code from Single Column to 2 column Like Transpose (3:32)
-
StartUsing Fill Down - Saving tons of hours of data cleasing work for Shopee/Lazada seller (3:10)
-
StartData Transformation using FIll Up Conditional Column (3:07)
-
PreviewCombine Both Columns value into Single Column on Condition (3:27)
Some cool Powerquery ideas
Available in
days
days
after you enroll
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
Try us for first 10 days, if you like the course, let's continue the journey together.