Free ebook
Free ebook: Conditional Formatting Mastery
Everything you need to know about Excel's conditional formatting: highlight rules, top/bottom rules, data bars, color scales, icon sets, formula-based rules, managing and debugging rules, and real-world use cases. Hands-on examples throughout.
Get the ebookFree tools
Practice with free browser tools
Formula builder, formula explainer, CSV cleaner, and 7 more — no upload, no sign-up. Try what you learn in the lessons.
Browse free tools=COURSE.PATH
Power Query
Structured YouTube courses for importing, cleaning, merging, appending, and refreshing repeatable data workflows.
What this path is for
Use this page when you want a guided route through public Excel lessons without searching from scratch. Preview a tutor, open the full lesson on YouTube, and return here for the next option.
Learn
Import files, folders, tables, and external data into Power Query.
Learn
Clean, transform, merge, append, and refresh repeatable workflows.
Learn
Replace manual cleanup with reliable query steps.
Suggested course flow
- 01Excel Power Query (Get & Transform)Leila Gharani - preview available
- 02Excel Power Query Course: Power Query Tutorial for BeginnersSimon Sez IT - preview available
- 03How to use Microsoft Power QueryKevin Stratvert - preview available
- 04How To Easily Merge Tables With Power Query: Vlookup AlternativeExcel Campus - Jon - preview available
- 05Powerful trick to combine all Excel files in a folder AUTOMATICALLYChandoo - preview available
- 06Highline Excel 2016 Class 03: Data Analysis Fundamentalsexcelisfun - preview available
Previewable lessons
Showing the first 36 of 42 curated public lessons for this path.
01
02
Excel Power Query Course: Power Query Tutorial for Beginners
Simon Sez IT
Open on YouTube (opens in a new tab)03
04
How To Easily Merge Tables With Power Query: Vlookup Alternative
Excel Campus - Jon
Open on YouTube (opens in a new tab)05
Powerful trick to combine all Excel files in a folder AUTOMATICALLY
Chandoo
Open on YouTube (opens in a new tab)06
Highline Excel 2016 Class 03: Data Analysis Fundamentals
excelisfun
Open on YouTube (opens in a new tab)07
Introduction to Power Query & Power Pivot Data Model in Excel 2016
excelisfun
Open on YouTube (opens in a new tab)08
How to easily automate boring Excel tasks with Power Query!
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)09
10
10 awesome Power Query tricks you NEED to know!
Excel Off The Grid
Open on YouTube (opens in a new tab)11
Learn to Automate Everything with Power Query in Excel (Download Files)
Leila Gharani
Open on YouTube (opens in a new tab)12
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
Josh Aharonoff (Your CFO Guy)
Open on YouTube (opens in a new tab)13
14
Master Data Cleaning Essentials with Power Query And Excel
Simon Sez IT
Open on YouTube (opens in a new tab)15
Power Query Import, Clean, Transform & Load Data in Excel
excelisfun
Open on YouTube (opens in a new tab)16
Power Query for Beginners - (Complete Masterclass + Practice Files)
Excel Champs
Open on YouTube (opens in a new tab)17
Data Cleaning in Excel - Text Functions and Power Query in Excel!
Simon Sez IT
Open on YouTube (opens in a new tab)18
Power Query Tutorial - Beginner to Advanced [Full Course]
Pivotalstats
Open on YouTube (opens in a new tab)19
How to use Power Query to combine Excel spreadsheets!
Excelbychris
Open on YouTube (opens in a new tab)20
Excel Power Query Tutorial: Fast Data Merge
Change tips and tools
Open on YouTube (opens in a new tab)21
13 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II)
Josh Aharonoff (Your CFO Guy)
Open on YouTube (opens in a new tab)22
23
24
Automate Power Query with VBA - Taking Power Query to the Next Level
Excel Off The Grid
Open on YouTube (opens in a new tab)25
26
Data Cleaning With Power Query (Better than Excel)
Kenji Explains
Open on YouTube (opens in a new tab)27
Power Query was HARD until I learned these 7 Tips
Excel Campus - Jon
Open on YouTube (opens in a new tab)28
Still Guessing Between Power Query, Power Pivot, and VBA? (Watch This)
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)29
30
Master Data Cleaning with Power Query in Excel in 9 Minutes
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)31
Power Query was HARD until I learned these 7 Tips
Excel Campus - Jon
Open on YouTube (opens in a new tab)32
33
Learn to Automate Everything with Power Query in Excel (Download Files)
Leila Gharani
Open on YouTube (opens in a new tab)34
Power Query Tutorial - Beginner to Advanced [Full Course]
Pivotalstats
Open on YouTube (opens in a new tab)35
Power Query for Beginners - (Complete Masterclass + Practice Files)
Excel Champs
Open on YouTube (opens in a new tab)36
Master Power Query in Excel Complete Tutorial Beginner to Advanced
Empowering Finance with Technology
Open on YouTube (opens in a new tab)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
- Chandoo (opens in a new tab)
ExcelJet (opens in a new tab)- MrExcel (opens in a new tab)
- Contextures (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)- Simon Sez IT (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)- Edureka (opens in a new tab)
Course platforms
