In this video, I will show you 10 simple ways to clean data in Excel.
Data forms the backbone of any analysis that you do in Excel. And when it comes to data, there are tons of things that can go wrong – be it the structure, placement, formatting, extra spaces, and so on.
Excel can be an amazing tool for data analysis. But we hardly get the data that can be used right away. And bad data leads to bad analysis.
Cleaning the raw data that you get in Excel will depend on what type and structure of data you get. There are a lot of things you can do before-hand to make sure your raw data get cleaned and ready for use.
Excel has a lot of formulas and functionalities that can help you clean your data. For example, you can use a formula such as TRIM to clean your data of leading, trailing, and double spaces. Or you can use the remove duplicate functionality to remove any occurrence of duplicate records.
The following data cleaning techniques are covered in this video:
0:00 Get Rid of Extra Spaces (leading, trailing, and extra spaces between words)
1:20 Select and remove All Blank Cells/rows
2:38 Convert Numbers Stored as Text into Numbers
5:00 Remove Duplicates cells/records
7:21 Highlight cells that contain Errors
9:24 Change Text to Lower/Upper/Proper Case to make it all consistent
10:54 Parse Data Using Text to Column
13:15 Spell Check (using a keyboard shortcut)
13:54 Delete all Formatting
14:33 Use Find and Replace to Clean Data in Excel
The data cleansing techniques covered in this video are some of the most common ones that you can use as soon as you get your raw data. Again, based on your dataset, you may need to add more to it.
Read the full tutorial here:
Also, I have made all of my Excel courses available for FREE. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
#Excel #ExcelTips #ExcelTutorial
Tag: clear format trong excel, Clean Data in Excel, Data Cleaning in Excel, Data Cleansing in Excel, cleaning up raw data in excel, how to clean data in excel, data cleaning, Excel Data Cleaning, trim function in excel, top data cleaning tricks in excel, how to do data cleansing in excel, data cleansing, cleaning data in excel, cleaning up excel spreadsheet, Excel, Excel Tips, Excel Data, how to clean raw data in excel, clean raw data in excel, excel tutorial, clean raw data, Data cleaning formulas
Xem thêm: https://icongnghe.org/category/review