Free ebook
Free ebook: Data Cleaning in Excel
Fix messy imported data fast — remove duplicates, strip extra spaces, split columns, repair dates, and turn raw exports into analysis-ready tables.
Get the ebook5 subtopics in this path
Duplicate removal, blanks, whitespace, data validation, text splitting, Flash Fill, normalization, and repeatable cleanup workflows.
Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.
Clean repeated records, empty rows, and accidental blank cells without damaging the dataset.
Simon Sez IT
Open on YouTube (opens in a new tab)
Kenji Explains
Open on YouTube (opens in a new tab)Remove hidden spaces, non-printing characters, inconsistent casing, and messy imported text.
Use Text to Columns, Flash Fill, and formulas to reshape names, codes, and addresses.
TrumpExcel
Open on YouTube (opens in a new tab)Create dropdowns, rule-based entry checks, and helpful input messages.
Build repeatable cleaning steps for files that arrive in the same messy format every week.
Real Excel screenshots showing what this topic looks like in practice.
Chandoo
Concise Power Query cleaning walkthrough with realistic cleanup tasks and refreshable transformations.
Open on YouTube (opens in a new tab)Chandoo
Broader playlist that places Excel cleaning inside an end-to-end data analyst learning path.
Open on YouTube (opens in a new tab)Chandoo
Longer Power Query lesson for learners who want more depth than a quick intro.
Open on YouTube (opens in a new tab)TrumpExcel
Targeted video for cleaning imported text and CSV-style data with Power Query.
Open on YouTube (opens in a new tab)Simon Sez IT
Extracted from saved YouTube search results - titled "Cleaning Data in Crash", filed under Data Cleaning.
Open on YouTube (opens in a new tab)Kenji Explains
Extracted from saved YouTube search results - titled "Master Data Cleaning Essentials on in Just 10 Minutes", filed under Data Cleaning.
Open on YouTube (opens in a new tab)
Leila Gharani
Extracted from saved YouTube search results - titled "Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in", filed under Data Cleaning.
Open on YouTube (opens in a new tab)
Kevin Stratvert
Extracted from saved YouTube search results - titled "How to Remove Duplicates in", filed under Data Cleaning for its removing duplicates coverage.
Open on YouTube (opens in a new tab)
Chandoo
Extracted from saved YouTube search results - titled "How to Clean, Analyze and Present Data with ( Adv. )", filed under Data Cleaning.
Open on YouTube (opens in a new tab)
MyOnlineTrainingHub
Extracted from saved YouTube search results - titled "How to Clean Data in in 10 Minutes ( File)", filed under Data Cleaning.
Open on YouTube (opens in a new tab)
Kevin Stratvert
Extracted from saved YouTube search results - titled "How to Remove Duplicates in", filed under Data Cleaning for its removing duplicates coverage.
Open on YouTube (opens in a new tab)
Leila Gharani
Extracted from saved YouTube search results - titled "Three EASY Ways to Find and Remove Duplicates in", filed under Data Cleaning for its removing duplicates coverage.
Open on YouTube (opens in a new tab)26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (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)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
