10 Super Neat Ways to Clean Data in Excel
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:
https://trumpexcel.com/clean-data-in-excel/
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) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
#Excel #ExcelTips #ExcelTutorial
Видео 10 Super Neat Ways to Clean Data in Excel канала TrumpExcel
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:
https://trumpexcel.com/clean-data-in-excel/
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) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
#Excel #ExcelTips #ExcelTutorial
Видео 10 Super Neat Ways to Clean Data in Excel канала TrumpExcel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
☑️ Top 30 Advanced Excel Tips and TricksHow to Compare Two Excel Sheets (and find the differences)Excel: Data Cleaning with Excel Part 17 Clever Excel Custom Formatting Tricks (Advanced)How to build Interactive Excel Dashboards25 AWESOME Excel Keyboard Shortcuts (You Should Know)!50 Ultimate Excel Tips and Tricks for 2020How to Clean Up Raw Data in ExcelHow to create barcodes in Excel that WORK!How to easily automate boring Excel tasks with Power Query!7 Ways to Use Vlookup in ExcelExcel LAMBDA - HOW & WHEN you Should use itExcel 2016 Advanced8 Ways To Find & Remove Duplicate Values In ExcelInteractive Excel Project Management Dashboard - FREE DownloadINDEX MATCH Explained (An Alternative to VLOOKUP)Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Cleaning Messy Data in an Excel Spreadsheet10 Excel formatting tricks *ONLY* experts know