MENU
Donate
=ARTICLES

Power Query

4 tutorials written here on power query, plus 42 public power query videos from other channels, filed by level and subtopic.

All articles

Original tutorials

4
intermediateJul 30, 2026

Power Query vs Excel formulas for data cleaning: when to use each

A practical guide to choosing between Power Query and worksheet formulas when you need to clean, reshape, or transform data in Excel.

intermediateJul 30, 2026

Power Query vs VBA for data cleanup: how to choose

When to use Power Query and when to use VBA for recurring data cleanup tasks in Excel.

intermediateJul 28, 2026

Power Query refresh checklist

Check source files, column names, data types, errors, and load settings before trusting a Power Query refresh.

beginnerJul 24, 2026

Getting started with Power Query: import and clean data automatically

How to pull data into Excel with Power Query, apply repeatable cleaning steps, and load the result — without touching a single formula.

Video resources

Every power query video we have filed, published by other channels. All 42 are listed — nothing hidden behind a cap.

42
Excel Power Query (Get & Transform): Excel learning resourceMixedLeila GharaniJul 28, 2026Excel Power Query Course: Power Query Tutorial for Beginners: Excel learning resourceMixedSimon Sez ITJul 28, 2026How to use Microsoft Power Query: Excel learning resourceBeginnerKevin StratvertJul 28, 2026How To Easily Merge Tables With Power Query: Vlookup Alternative: Excel learning resourceIntermediateExcel Campus - JonJul 28, 2026Powerful trick to combine all Excel files in a folder AUTOMATICALLY: Excel learning resourceIntermediateChandooJul 28, 2026Highline Excel 2016 Class 03: Data Analysis Fundamentals: Excel learning resourceIntermediateexcelisfunJul 27, 2026Introduction to Power Query & Power Pivot Data Model in Excel 2016: Excel learning resourceIntermediateexcelisfunJul 27, 2026How to easily automate boring Excel tasks with Power Query!: Excel learning resourceIntermediateMyOnlineTrainingHubJul 27, 2026How to use Power Query - Microsoft Excel Tutorial: Excel learning resourceBeginnerTeacher's TechJul 27, 202610 awesome Power Query tricks you NEED to know!: Excel learning resourceAdvancedExcel Off The GridJul 27, 2026Learn to Automate Everything with Power Query in Excel (Download Files): Excel learning resourceIntermediateLeila GharaniJul 27, 2026Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I): Excel learning resourceIntermediateJosh Aharonoff (Your CFO Guy)Jul 27, 2026Power Query Full Course (Beginner to Advanced): Excel learning resourceIntermediateAAA Excels PowerJul 27, 2026Master Data Cleaning Essentials with Power Query And Excel: Excel learning resourceIntermediateSimon Sez ITJul 27, 2026Power Query Import, Clean, Transform & Load Data in Excel: Excel learning resourceIntermediateexcelisfunJul 27, 2026Power Query for Beginners - (Complete Masterclass + Practice Files): Excel learning resourceIntermediateExcel ChampsJul 27, 2026Data Cleaning in Excel - Text Functions and Power Query in Excel!: Excel learning resourceIntermediateSimon Sez ITJul 27, 2026Power Query Tutorial - Beginner to Advanced [Full Course]: Excel learning resourceIntermediatePivotalstatsJul 26, 2026How to use Power Query to combine Excel spreadsheets!: Excel learning resourceIntermediateExcelbychrisJul 25, 2026Excel Power Query Tutorial: Fast Data Merge: Excel learning resourceIntermediateChange tips and toolsJul 25, 202613 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II): Excel learning resourceIntermediateJosh Aharonoff (Your CFO Guy)Jul 24, 202610 Power Query tips EVERY user should know!: Excel learning resourceIntermediateExcel Off The GridJul 23, 2026How to use Microsoft Power Query: Excel learning resourceIntermediateKevin StratvertJul 23, 2026Automate Power Query with VBA - Taking Power Query to the Next Level: Excel learning resourceIntermediateExcel Off The GridJul 23, 2026Power Query parameters: Excel learning resourceIntermediateExcel Off The GridJul 22, 2026Data Cleaning With Power Query (Better than Excel): Excel learning resourceIntermediateKenji ExplainsJul 22, 2026Power Query was HARD until I learned these 7 Tips: Excel learning resourceIntermediateExcel Campus - JonJul 22, 2026Still Guessing Between Power Query, Power Pivot, and VBA? (Watch This): Excel learning resourceIntermediateMyOnlineTrainingHubJul 22, 2026Subtotal and Column Total in Power Query: Excel learning resourceIntermediateGoodlyJul 22, 2026Master Data Cleaning with Power Query in Excel in 9 Minutes: Excel learning resourceIntermediateMyOnlineTrainingHubJul 22, 2026Power Query was HARD until I learned these 7 Tips: Excel learning resourceIntermediateExcel Campus - JonJul 22, 2026Automate your Excel work with Power Query: Excel learning resourceIntermediatePavan LalwaniJul 22, 2026Learn to Automate Everything with Power Query in Excel (Download Files): Excel learning resourceIntermediateLeila GharaniJul 21, 2026Power Query Tutorial - Beginner to Advanced [Full Course]: Excel learning resourceIntermediatePivotalstatsJul 21, 2026Power Query for Beginners - (Complete Masterclass + Practice Files): Excel learning resourceIntermediateExcel ChampsJul 21, 2026Master Power Query in Excel Complete Tutorial Beginner to Advanced: Excel learning resourceIntermediateEmpowering Finance with TechnologyJul 21, 2026Advanced Excel Power Query: Excel learning resourceIntermediateTutorialsPointJul 21, 2026This is how I actually clean data using Power Query: Excel learning resourceIntermediateMo ChenJul 19, 2026How to Clean Data in Excel Power Query: Excel learning resourceIntermediateSimon Sez ITJul 19, 2026Power Pivot Tutorial & Power Query in Excel - 1-Hour Class: Excel learning resourceIntermediateSimon Sez ITJul 18, 2026Excel Power Query Tutorial For Beginners: Excel learning resourceIntermediateSimplilearnJul 18, 2026Master Data Cleaning Essentials with Power Query And Excel: Excel learning resourceIntermediateSimon Sez ITJul 18, 2026

Sources we reference — not partners

26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.

Official documentation

Educators and channels

Course platforms

AI & data tools