Okebiz Video Search



Title:10 Super Neat Ways to Clean Data in Excel
Duration:18:47
Viewed:1,408,392
Published:24-08-2014
Source:Youtube

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-...

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-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course

#Excel #ExcelTips #ExcelTutorial

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
☑️ Top 30 Advanced Excel Tips and Tricks ☑️ Top 30 Advanced Excel Tips and Tricks
10:56 | 436,146
How to build Interactive Excel Dashboards How to build Interactive Excel Dashboards
52:26 | 701,710
Excel: Data Cleaning with Excel Part 1 Excel: Data Cleaning with Excel Part 1
12:05 | 44,618
25 AWESOME Excel Keyboard Shortcuts (You Should Know)! 25 AWESOME Excel Keyboard Shortcuts (You Should...
17:36 | 50,775
Excel 2016 Advanced Excel 2016 Advanced
38:45 | 455,731
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX How to Extract Data from a Spreadsheet using VL...
15:54 | 802,677
7 Ways to Use Vlookup in Excel 7 Ways to Use Vlookup in Excel
16:44 | 620,768
INDEX MATCH Explained (An Alternative to VLOOKUP) INDEX MATCH Explained (An Alternative to VLOOKUP)
19:28 | 461,152


coinpayu