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
Excel Tables & Data Cleaning
Courses for Excel Tables, structured references, validation, duplicate cleanup, text cleanup, and repeatable data prep.
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
Convert fragile ranges into reliable Excel Tables.
Learn
Remove duplicates, blanks, hidden spaces, and inconsistent imported data.
Learn
Prepare clean source tables for formulas, pivots, and dashboards.
Suggested course flow
- 01Power Query - Beginner to PRO Masterclass in 30 minutesChandoo - preview available
- 02FREE Data Analyst CourseChandoo - preview available
- 03Power Query masterclassChandoo - preview available
- 04Import Data from TEXT Files in Excel using Power QueryTrumpExcel - preview available
- 05All About Excel TablesTechnology for Teachers and Students - preview available
- 06Only 1% of Excel Users Know Excel Tables! STAND OUT from the Crowd!MyOnlineTrainingHub - preview available
Previewable lessons
Showing the first 36 of 128 curated public lessons for this path.
01
02
03
04
Import Data from TEXT Files in Excel using Power Query
TrumpExcel
Open on YouTube (opens in a new tab)05
06
Only 1% of Excel Users Know Excel Tables! STAND OUT from the Crowd!
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)07
The Mistake Almost EVERY Excel User Makes (Free File)
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)08
09
How to Use Excel Tables Structured References
Online Training for Everyone
Open on YouTube (opens in a new tab)10
11
12
13
Table Structured References Aren't Hard - You're Using Them Wrong
Excel Off The Grid
Open on YouTube (opens in a new tab)14
Cleaning Data in Excel: Microsoft Excel Crash Course
Simon Sez IT
Open on YouTube (opens in a new tab)15
Master Data Cleaning Essentials on Excel in Just 10 Minutes
Kenji Explains
Open on YouTube (opens in a new tab)16
How to Use Structured References in Excel: Table, Column, and Item Specifiers
BrainBell
Open on YouTube (opens in a new tab)17
Structured References Across Multiple Tables: Advanced Excel Formula Technique
Annette Slager
Open on YouTube (opens in a new tab)18
Create SMART Drop Down Lists in Excel (with Data Validation)
Leila Gharani
Open on YouTube (opens in a new tab)19
20
Relative & Fixed Referencing using Structured References in Excel
Analytics Success
Open on YouTube (opens in a new tab)21
How to Create a Drop-Down List in Excel
Excel Tutorials by EasyClick Academy
Open on YouTube (opens in a new tab)22
23
Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel
Leila Gharani
Open on YouTube (opens in a new tab)24
25
26
27
Create data validation list from Excel Table... the RIGHT WAY!
Excel Off The Grid
Open on YouTube (opens in a new tab)28
How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)
Chandoo
Open on YouTube (opens in a new tab)29
30
31
How to Clean Data in Excel in 10 Minutes (Free File)
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)32
Use Structured References in Excel: Table, Column, and Item Specifiers
The Best Technical 360
Open on YouTube (opens in a new tab)33
34
35
Three EASY Ways to Find and Remove Duplicates in Excel
Leila Gharani
Open on YouTube (opens in a new tab)36
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
