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/upl...
More on Data Cleaning with Excel:
============================
10 ways to clean data in Excel (2022 techniques) - • Data Cleaning in Excel - 10 Tricks (B...
How to use Power Query to clean data - • Power Query Tutorial - What is it, ho...
Combine Excel Files Automatically - • Powerful trick to combine all Excel f...
#ExcelTricks #DataCleanup
Смотрите видео Data cleaning in Excel - 10 tricks *PROs* use all the time онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chandoo 10 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 502,035 раз и оно понравилось 19 тысяч людям.