MENU
Donate
=ARTICLES

Data Cleaning

3 tutorials written here on data cleaning, plus 60 public data cleaning videos from other channels, filed by level and subtopic.

All articles

Original tutorials

3
beginnerJul 28, 2026

How to clean a customer list in Excel

Clean names, emails, phone numbers, duplicates, blanks, and inconsistent categories before using a customer list.

TRIM()
beginnerJul 28, 2026

Clean data before building a pivot table

Check headers, blanks, duplicates, dates, and totals before creating pivot tables from spreadsheet data.

beginnerJan 18, 2026

3 ways to remove duplicates in Excel

Remove duplicate rows using the built-in button, UNIQUE, or Power Query — and how to pick the right one.

UNIQUE()

Video resources

Every data cleaning video we have filed, published by other channels. All 60 are listed — nothing hidden behind a cap.

60
Power Query - Beginner to PRO Masterclass in 30 minutes: Excel learning resourceMixedChandooJul 28, 2026FREE Data Analyst Course: Excel learning resourceMixedChandooJul 28, 2026Power Query masterclass: Excel learning resourceIntermediateChandooJul 28, 2026Import Data from TEXT Files in Excel using Power Query: Excel learning resourceIntermediateTrumpExcelJul 28, 2026Cleaning Data in Excel: Microsoft Excel Crash Course: Excel learning resourceIntermediateSimon Sez ITJul 27, 2026Master Data Cleaning Essentials on Excel in Just 10 Minutes: Excel learning resourceIntermediateKenji ExplainsJul 27, 2026Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel: Excel learning resourceIntermediateLeila GharaniJul 26, 2026How to Remove Duplicates in Excel: Excel learning resourceIntermediateKevin StratvertJul 26, 2026How to Clean, Analyze and Present Data with Excel (FREE Adv. Course): Excel learning resourceIntermediateChandooJul 26, 2026How to Clean Data in Excel in 10 Minutes (Free File): Excel learning resourceIntermediateMyOnlineTrainingHubJul 26, 2026How to Remove Duplicates in Excel: Excel learning resourceIntermediateKevin StratvertJul 26, 2026Three EASY Ways to Find and Remove Duplicates in Excel: Excel learning resourceIntermediateLeila GharaniJul 26, 2026Cleaning Data in Excel: Excel learning resourceIntermediateAlex The AnalystJul 26, 2026Quickly Remove Blanks and Duplicates in Microsoft Excel: Excel learning resourceIntermediateTeacher's TechJul 25, 2026How to Remove Blank Rows and Duplicates in Excel: Excel learning resourceIntermediateSimon Sez ITJul 25, 2026The Ultimate Guide to Text to Columns in Microsoft Excel: Excel learning resourceIntermediateMyExcelOnline.comJul 25, 2026Text to Columns in Microsoft Excel: Excel learning resourceIntermediateExcel Campus - JonJul 25, 2026Clean Messy Excel Data: Excel learning resourceIntermediateOffice File SolutionsJul 25, 2026[FREE EXCEL COURSE] Lesson 7 - Auto-fill, Custom Lists, and Flash Fill: Excel learning resourceIntermediateTrumpExcelJul 25, 2026Excel Crash Course - Data Cleaning in Excel - Microsoft Excel Tutorial: Excel learning resourceIntermediateSimon Sez ITJul 25, 2026Removing Blank Rows, Cells, and Duplicates in Microsoft Excel: Excel learning resourceIntermediateSimon Sez ITJul 24, 2026Excel: Trim - Clean - Substitute - Len Functions to fix your data by Chris Menard: Excel learning resourceIntermediateChris MenardJul 24, 2026MS Excel - Text to Columns: Excel learning resourceIntermediateTutorialsPointJul 24, 2026Split & Combine Text Using Flash Fill in Excel: Excel learning resourceIntermediateTeachExcelJul 24, 2026Combining two columns of data with Flash Fill in Excel: Excel learning resourceIntermediateTrainingArtJul 24, 2026Removing Duplicates In Excel Is Easy With This Tutorial!: Excel learning resourceIntermediateExcel Campus - JonJul 24, 2026Remove Duplicates in Excel: Excel learning resourceIntermediateCheatSheetsJul 24, 2026Delete Duplicates in 1 Minute or Less with EXCEL: Excel learning resourceIntermediateAccounts FixJul 24, 2026Remove Duplicates in Excel (3 Methods): Excel learning resourceIntermediateKenji ExplainsJul 24, 2026Highlight & Remove Duplicates in excel: Excel learning resourceIntermediateExcel Learning AcademyJul 24, 2026Remove Duplicates in Excel (The Only 2 Methods You Need): Excel learning resourceIntermediateSpreadsheetoJul 23, 2026Excel Tutorial - Cleaning Up Data with TRIM, PROPER, and Text to Columns: Excel learning resourceIntermediateMergers & Inquisitions / Breaking Into Wall StreetJul 23, 2026How to Split Text in Excel in Seconds (Flash Fill): Excel learning resourceIntermediateMyOnlineTrainingHubJul 23, 2026EVERY Way to Remove Duplicates in Excel. Do You Know Them ALL?: Excel learning resourceIntermediateMyOnlineTrainingHubJul 23, 2026Excel Useful Features: Flash Fill & Text to Columns: Excel learning resourceIntermediateJPL IT Training LimitedJul 22, 2026Data Cleaning in Excel: Excel learning resourceIntermediateKenji ExplainsJul 22, 2026How to Clean Data in Excel Like a Pro!: Excel learning resourceIntermediateExcel SimplifiedJul 22, 2026Remove Duplicates in Excel Like a PRO (5 Working Methods): Excel learning resourceIntermediateOffice Tech SkillJul 22, 2026Clean Excel Data in Seconds with these 4 Magic Functions - UPPER, LOWER, PROPER and TRIM: Excel learning resourceIntermediateAnalytics SuccessJul 22, 2026How to Remove Blank Rows in Excel: Excel learning resourceIntermediateJopa ExcelJul 21, 2026How to use AutoFill & Flash Fill in Excel - Tips for Beginners: Excel learning resourceIntermediateTeacher's TechJul 21, 2026How to Split Text in Cells with Flash Fill in Excel: Excel learning resourceIntermediateExcel Campus - JonJul 21, 2026Data Cleaning using Excel (Roll-Over): Excel learning resourceIntermediateEsther Chinenye AnaguJul 20, 2026How to quickly remove blank rows & duplicates in Excel:: Excel learning resourceIntermediateBlack Shield Corporation_ABDSJul 19, 2026Data Cleaning in Excel Remove Duplicates, Fix Errors, Handle Missing Rows & Data (Beginners Guide): Excel learning resourceIntermediateData With IjeomaJul 19, 2026How to Remove Duplicates in Excel (Fast & Easy): Excel learning resourceIntermediateEXCEL DATA SOLUTIONSJul 19, 2026Clean Up Your Data with TRIM in Excel Quick & Easy!: Excel learning resourceIntermediateAlex's SkillsJul 19, 2026TRIM and CLEAN Function in Excel: Excel learning resourceIntermediateExcel UniverseJul 19, 2026Clean Up Your Excel Data Learn CLEAN,TRIM, and TEXT: Excel learning resourceIntermediateStructural Design OnlyJul 19, 202615 Excel Data Cleaning Hacks: Excel learning resourceIntermediateComputer Tech AcademyJul 19, 2026How to Combine Columns in Excel Using & and Flash Fill: Excel learning resourceIntermediateJopa ExcelJul 19, 2026How to Split Text to Columns in Excel with Multiple Delimiters using TEXTSPLIT in Excel Formula: Excel learning resourceIntermediateRahim Zulfiqar AliJul 19, 2026Auto fill, Flash fill and Text to Columns in Excel: Excel learning resourceIntermediateWsCube Tech! ENGLISHJul 19, 2026Combining Excel Data by using TEXTJOIN or Flash Fill: Excel learning resourceIntermediateTechnology for Teachers and StudentsJul 19, 2026How to Use Text to Columns in Excel: Excel learning resourceIntermediateSimon Sez ITJul 19, 2026Flash Fill in Excel: Excel learning resourceIntermediateAjay AnandJul 19, 2026Excel Hacks: Deleting Blank Rows Made Easy!#excel: Excel learning resourceIntermediateMANOJ KUMAR EXCELJul 18, 2026Clean and Trim in Excel: Excel learning resourceIntermediateExcel InsiderJul 18, 2026Clean Up Your Data in Excel with the TRIM Formula!: Excel learning resourceIntermediateChainJul 18, 2026How to Clean, Analyze and Present Data with Excel (FREE Adv. Course): Excel learning resourceIntermediateChandooJul 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