Data Cleaning in Excel - 10 Tricks (Beginner to PRO)
Dirty data on your mind?
Just spray the amazing "data cleaner" on it.
In this video, learn how you can use 5 Excel features to clean data with 10 examples.
You will learn about:
1) Flash Fill
2) Text to Columns
3) Remove Duplicates
4) Formulas
5) Power Query
Video Topics ⏱👇
===============
0:00 - Data Clean-up - the challenge
1:17 - Extracting the first name (Flash Fill)
2:10 - Get the city from location (Flash Fill)
3:12 - Get the city from location (Text to Columns)
4:20 - Splitting cost centre & ID number (Text to Columns)
5:35 - Duplicate Valvalues (Remove Duplicates)
6:33 - But there is a problem!!!
7:16 - Remove extra spaces from name (Formulas)
8:01 - Full time or Part time (Formulas)
8:49 - Power Query!!!
10:04 - Splitting Cost Centre & ID with Power Query
10:57 - Fixing inconsistent dates with Power Query
11:40 - Adding a Full / Part column with Power Query
12:30 - Bonus Example - Fixing or Removing incomplete data
13:50 - Loading Cleaned up data to Excel & Data Updates (Refresh)
Download the sample file 🟩
=======================
Here is a blank data file. Use it to practice these data clean-up tasks:
https://chandoo.org/wp/wp-content/upl...
Watch next 💻👍
==============
🧹10 Quick and Smart Data Cleaning Tricks - • Data cleaning in Excel - 10 tricks *P...
👩💻 Detailed Video on Power Query - • Power Query Tutorial - What is it, ho...
🎶 Power Query Playlist - • Power Query Tutorial - What is it, ho...
🤷♂️ How to _____ in Excel - Playlist - • How to add a LINE to your charts in E...
~
#Excel #powerquery
May your data be clean and your days be serene 😀
Watch video Data Cleaning in Excel - 10 Tricks (Beginner to PRO) online without registration, duration hours minute second in high quality. This video was added by user Chandoo 12 April 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 390,444 once and liked it 7.3 thousand people.