Data Analysis with Excel 📈📉📊✅ - Data cleaning in Excel - 10 tricks *PROs* use all the time

Good data is the cornerstone of great analysis. In this video, learn 10 powerful yet EASY ways for data cleaning in Excel that not many know. The tricks you will learn are, 0:00 - Introduction 00:18 - Extracting first name with Flash fill feature of Excel 1:47 - Converting numbers to percentages 3:18 - Remove blank cells or rows using Goto special 4:43 - Find common values between two lists 5:32 - Clean-up ugly formats with one click 6:15 - Bonus trick #1 - Remove extra spaces 7:30 - Unstack data easily with simple formulas 9:44 - Removing duplicate combinations in your data 10:37 - Deleting yellow or any colour cells 12:09 - Extract numbers from text values easily 13:35 - Get file names from full path with Find Replace in Excel 15:36 - Bonus trick #2 - Dealing with numbers formatted as text Example file for practice: ==================== Please download example file with dirty data to practice here. https://chandoo.org/wp/wp-content/uploads/2021/03/10-powerful-ways-to-clean-data-in-Excel-demo.xlsx More on Data Cleaning with Excel: ============================ 10 ways to clean data in Excel (2022 techniques) - https://youtu.be/q7EpoOwBcnM How to use Power Query to clean data - https://youtu.be/PiFAa_jjaEI Combine Excel Files Automatically - https://youtu.be/SGzegma9bdY #ExcelTricks #DataCleanup