Power Query Lesson 7: Group By
Summarise data inside Power Query with Group By: basic and advanced grouping, several aggregations (sum, count, count distinct), grouping by two columns, and when…
Read article →Power Query & Pivots
Clean, combine and summarise data without formulas.
Power Query Lesson 6: Append and Combine a Folder of Files
Power Query Lesson 6: Append and Combine a Folder of Files
Stack tables with Append Queries, then combine every file in a folder with From Folder: sample file transform, file name as a column, filtering…
Read article →Power Query Lesson 5: Merge Queries — Lookups Without VLOOKUP
Power Query Lesson 5: Merge Queries — Lookups Without VLOOKUP
Bring product names and categories into an orders table with Merge Queries: matching columns, join kinds (left outer, inner, anti), expanding columns, and finding…
Read article →Power Query Lesson 4: Unpivot and Pivot
Power Query Lesson 4: Unpivot and Pivot
Turn a cross-tab with months across the top into a proper data table with Unpivot Other Columns, pivot data back into columns, and know…
Read article →Power Query Lesson 3: Removing Junk Rows, Duplicates and Errors
Power Query Lesson 3: Removing Junk Rows, Duplicates and Errors
Clean an ERP-style export: remove top rows, promote headers, fill down group labels, filter out subtotals, remove duplicates and rows with errors, and keep…
Read article →Power Query Lesson 2: Cleaning Text — Trim, Case and Split
Power Query Lesson 2: Cleaning Text — Trim, Case and Split
Clean messy text columns in Power Query: Trim and Clean, Capitalize Each Word, Replace Values, Split Column by delimiter, and Extract text — the…
Read article →Power Query Lesson 1: What Power Query Is and Your First Query
Power Query Lesson 1: What Power Query Is and Your First Query
Meet Power Query in Excel: import a CSV with Get Data, the Power Query Editor, Applied Steps, setting data types (including dd-mm-yyyy dates), Close…
Read article →Excel Pivot Tables: The Complete Guide from First Click to Dashboard
Excel Pivot Tables: The Complete Guide from First Click to Dashboard
Build pivot tables step by step: layout, value settings, Show Values As, grouping dates, slicers and timelines, calculated fields, distinct counts, GETPIVOTDATA, refresh tricks…
Read article →Combine All Excel Files in a Folder with Power Query (No VBA, No Copy-Paste)
Combine All Excel Files in a Folder with Power Query (No VBA, No Copy-Paste)
Use Excel’s Power Query “From Folder” to merge every workbook or CSV in a folder into one table that refreshes with one click —…
Read article →Unpivot Monthly Columns into a Clean Table with Power Query
Unpivot Monthly Columns into a Clean Table with Power Query
Turn a wide report with Jan–Dec columns into a tidy Month/Value table using Power Query’s Unpivot — so pivot tables, charts and SUMIFS finally…
Read article →Power Pivot and DAX: Your First Data Model and Measures
Power Pivot and DAX: Your First Data Model and Measures
Start with Power Pivot in Excel: load tables to the Data Model, create relationships, write first DAX measures (SUM, DIVIDE, CALCULATE), build a pivot…
Read article →