Excel Functions & Tricks You Need for Data Cleaning

Clean Data in Excel with this PRO with these amazing "new" functions. Gone are the days of manual data cleaning. Nowadays, Excel offers amazing functions to automate the data cleaning process. In this masterclass, learn the super tricks and become a data cleaning PRO. ✅ Reshaping data with WRAPROWS and TAKE ✅ Stacking data with HSTACK and VSTACK ✅ Removing excess spaces with TRIM ✅ Replacing typing errors and synonyms with a mapping table and XLOOKUP ✅ Replacing missing values with IF function ✅ Extracting values from text using TEXTSPLIT, TEXTBEFORE and TEXTAFTER functions ✅ Date formatting with DATEVALUE ✅ Using IFERROR & SUBSTITUTE to deal with annoying date problems ✅ Using REGEXTRACT to get data that matches the pattern we want ✅ Non-REGEX formula with TEXTSPLIT ✅ Removing duplicate data values with UNIQUE function 📁 Sample Data File: Download the data file and practice all these functions yourself - https://chandoo.org/wp/wp-content/uploads/2025/05/data-cleaning-super-tricks.xlsx 🕐 Video Topics & timestamps: 0:00 - Excel Data Cleaning Supertricks 2:31 - Using WRAPROWS to reshape data 4:12 - Combining both datasets using VSTACK 7:00 - Cleaning the Person column with TRIM & CHOOSECOLS 8:14 - Replacing errors & synonyms in City column with XLOOKUP 10:38 - Using LET & IF functions to clean the price data 12:15 - Extracting "date" of the event from event detail column 14:58 - Converting date to correct format with DATEVALUE 16:38 - Fixing errors with Date Conversion 20:04 - Using REGEXTRACT to extract the event time details 25:10 - non-REGEX formula for getting the event time (using TEXTSPLIT and wildcard XLOOKUP) 28:36 - Removing duplicate records with UNIQUE function 🧹 More videos on Data Cleaning: Data Cleaning in Excel - 10 Amazing Tricks - https://youtu.be/q7EpoOwBcnM (400k views, must watch) Data Cleaning in Excel - 10 PRO tricks - https://youtu.be/SNVjndgWBlw (500k views, must watch) How to clean, analyse and visualize data - https://youtu.be/H6k28jhclwI (450k views, long-form) Power Query in 15 mins - https://youtu.be/UAFExySaSPY (450k views, must watch) Power Query in 30 mins - https://youtu.be/MMdcczmULrU (200k views, NEW) Power Query Masterclass - https://youtu.be/PiFAa_jjaEI (700k views, long-form) 🧑‍💻 Complete Adv. Excel Course: Want to learn formulas, Power Query, charting, pivot tables, Power Pivot, DAX, dashboards and advanced features - all in one place? Check out my Excel School program. You will love it. 💥Course: https://chandoo.org/wp/excel-school-program 💰Discount: use code 10101010 to get 10% discount ~ #excel #datacleaning #function