7 beginner friendly steps to clean data in Excel

Simple and effective steps to clean any messy data in Excel!

Want to follow along? Use this data set: https://www.kaggle.com/datasets/aungp...

Have questions? Post then in the comments!


Table of content:

0:00 Intro
1:02 Get your data set in Excel (Supermarket Sales Data)
2:20 Step 1: Make a working file and keep your initial (raw) data unchanged
3:30 Step 2: Remove duplicates
4:54 Step 3: Check for spelling mistakes
8:05 Step 4: Remove whitespaces/blanks with TRIM function in Excel
9:50 Step 5: Make sure your data formatted the same way across all data case (Upper, Lower, Proper functions in Excel)
12:00 Step 6: Check Number and Date formatting
15:45 Step 7: Give your file descriptive name
16:55 Outro