Stop Cleaning Data Manually! Excel Data Cleansing for Beginners

Clean Data = Accurate Analysis! 📈 In this video, I’m showing you how to take a messy raw dataset and make it professional using only basic Excel functions. You don't need Power Query to be a great Data Analyst—you just need to master these 11 essential procedures. In this tutorial, we cover: Formatting: Bold headers, borders, and background styling for readability. Text Manipulation: Splitting names and cleaning department columns. Data Accuracy: Replacing values, filling blanks with "0", and fixing date formats. Financial Formatting: Setting up United States Currency correctly. Formulas for Beginners: Calculating Averages, Totals, and finding MAX/MIN salaries. Chapters: 00:00 - Introduction & Getting Started 01:01 - Lesson 1: Procedures to Clean the Dataset 04:22 - Lesson 2: Splitting Names into Separate Columns 06:52 - Lesson 3: Cleaning the Department Column 10:56 - Lesson 4: Replacing State with "Nigeria" 12:36 - Lesson 5: Filling Blank Columns with "0" 14:43 - Lesson 6: Formatting Monthly Allowance (US Currency) 15:30 - Lesson 7: Adding Serial Numbers (S/N) 17:49 - Lesson 8: Clearing Formatted Cells under Remarks 18:28 - Lesson 9: Changing Date Column to Short Date 19:19 - Lesson 10: Calculating Average Salary & Total Allowance 20:44 - Lesson 11: Finding the MAX and MIN Salary Do not forget to subscribe to my channel and stay tuned for more.