Beginners tutorial on how to clean data in Excel.
In this video, we answer “Why is Data Cleaning important?” and explore 10 incredibly useful Data Cleaning tips and tricks in Microsoft Excel to easily:
✅ Import a CSV using Text To Columns / Text Import Wizard
✅ Escape Commas in a CSV using Double Quotes
✅ Resize Columns using AutoFit
✅ Delete Blank Rows using Go To Special, Blanks
✅ Remove Duplicates
✅ Remove Excess Spaces in Text using the TRIM function
✅ Replace Values using Find and Replace
✅ Replace Formulas with Values using Paste Special, Values
✅ Standardise Text using UPPER, PROPER, and LOWER functions, and
✅ Standardise Dates
Link to the sample file – stonks.csv:
https://bit.ly/2UADOCz
After watching this video, download the sample file and try data cleaning by yourself to solidify your understanding in preparation for your next Excel job interview!
Subscribe:
https://www.youtube.com/edgecate?sub_confirmation=1
#ExcelDataCleaning, #DataCleaningInExcel, #HowToCleanDataInExcel
source