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:
[ Ссылка ]
Watch next 💻👍
==============
🧹10 Quick and Smart Data Cleaning Tricks - [ Ссылка ]
👩💻 Detailed Video on Power Query - [ Ссылка ]
🎶 Power Query Playlist - [ Ссылка ]
🤷♂️ How to _____ in Excel - Playlist - [ Ссылка ]
~
#Excel #powerquery
May your data be clean and your days be serene 😀
Data Cleaning in Excel - 10 Tricks (Beginner to PRO)
Теги
chandoochandoo.orgExcelspreadsheetsdata cleaningdata cleansingdata cleaning in data analyticsdata cleaning in power bidata cleaning techniquesdata cleaning in power queryetl in excelpower query examplestext to column exampleflash fill examplehow to clean data in excelquick tips on data cleanuptop data cleaning tricks in exceldata cleansing in excelhow to clean up raw data in excelcleaning up raw data in exceldata cleaning formulas