Top 30 Data Cleaning Tricks in Excel | Excel Data Cleaning Course

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: https://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 https://www.facebook.com/yodalearning​ Tweet us at https://www.twitter.com/yodalearning​ Follow our boards at https://in.pinterest.com/yodalearning