Data cleaning in Excel - 10 tricks PROs use all the time

Опубликовано: 27 Декабрь 2024
на канале: Chandoo

502,035

19k

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