Replace VLOOKUP With Power Query: learn Merge, Append & Group By techniques
Exercise: Sales Report by Category & Region
Get more than 2 Million Rows from a CSV File
Blend data from 4 tables “Merge & Append”
Add Custom Column to calculate sales value (formula)
Summarize queries “Group By” (2m rows down to 20K rows)
Load to: Pivot Table
Group Date by Month and Year in Pivot Table
To download Practice files: (working sheet, and raw data)
https://drive.google.com/open?id=1E_z...
Auto Process new data with few clicks