In this tutorial, we will learn Top Excel Data Cleaning Tricks.
Every Excel learner's Biggest Problem is How to Clean My Data?
I will show you 30 Simple tricks to clean the data in Excel.
Checkout Full Advanced Excel Course Library: bit.ly/30JD5is
We covered the following topics:
00:05 Introduction to Top 30 Data Cleaning Tricks
00:50 How to change the Case of the Text in Excel
02:30 How to Remove Extra Spaces in a Sentence in Excel
04:14 How to Find the Length of a Text in Excel
05:46 How to Convert Numbers stored as text back to a number in Excel
09:03 How can you add a chart inside a cell in Excel
10:31 How to add missing zeroes in Cheque numbers in Excel
14:45 How to Join Text from Different Cells in Excel
19:34 How to use a wildcard character asterisk with Find and Replace in Excel
22:29 How to use wildcard character questions mark with Find and Replace in Excel
24:45 How to delete wildcard character asterisk using Find and Replace in Excel
27:14 Why should you use MS Word's Find and Replace over MS Excel's
32:58 How to replace one cell color format with another in the entire worksheet
37:22 How to apply basics Text to Columns to Split the Text in Excel
40:08 How to keep the zeroes when applying Text to Columns on Data with preceding zeroes
43:59 How to Clean Number in Excel
46:19 How to Convert Number with Dr. and Cr. to positive and negative numbers in Excel
48:19 How to rectify incorrectly formatted date using Text to Column in Excel (Case-1)
51:35 How to rectify incorrectly formatted date using Text to Column in Excel (Case-2)
54:43 How to use LEFT and RIGHT Function in Excel
58:24 How can you increase the power of LEFT and RIGHT Formulas using the SEARCH Function in Excel
01:00:34 How is MID more powerful than LEFT and RIGHT Function in Excel
Top 30 Data Cleaning Tricks in Excel | Data Cleaning Course
#datacleaning #exceltricks #excelformula
Keep Yourself Updated. Follow Us Now!!!
Like us on / yodalearning
Tweet us at / yodalearning
Follow our boards at / yodalearning
5 мар 2021
