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
#ExcelTricks #DataCleanup
Видео Data cleaning in Excel - 10 tricks *PROs* use all the time канала Chandoo
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
#ExcelTricks #DataCleanup
Видео Data cleaning in Excel - 10 tricks *PROs* use all the time канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
10 awesome things you can do in Excel - WITHOUT any formulas or pivotsThe *ONLY* 10 Excel keyboard shortcuts you need to masterHow To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP DataDon't Use Excel Filters! Use This Incredible Excel Formula Instead ...TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included10 Advanced IF formulas every analyst should know10 Super Neat Ways to Clean Data in ExcelPower Query Tutorial - What is it, how to use it & 4 complete examples + Free download50 Ultimate Excel Tips and Tricks for 2020How to easily automate boring Excel tasks with Power Query!Bill Jelen - MrExcel's Best Excel Tips (including a secret tip from FBI 😮)Excel LAMBDA Function10 Excel formatting tricks *ONLY* experts knowHow to Compare Two Excel Sheets (and find the differences)How to build Interactive Excel DashboardsPower BI Beginner Tutorial10 Amazing (Less Known) Excel Tricks You Should KnowTop 15 Advanced Excel 2016 Tips and Tricks7 Clever Excel Custom Formatting Tricks (Advanced)Excel Dashboard - Plan vs Actual Variances - FREE Download