Home tab > Append Queries | AmazingExcel

Autoplay
Autocomplete

Previous Lesson Complete and Continue

POWERQUERY Level 1

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

Transform - Extract LEFT Convert Date-like Text Value to a Date Format in Excel and Powerquery (11:11)
Generate a List of Date (4:49)
Interesting M Language - Date.ToText (4:44)
8 ways to keep my mind sharp - Table.RowCount (12:07)

Teach online with

Home tab > Append Queries

Lesson content locked

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

Enroll in Course to Unlock