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:
chandoo.org/wp/wp-content/uploads/2022/04/data-cleaning-in-excel.xlsx
Watch next 💻👍
==============
🧹10 Quick and Smart Data Cleaning Tricks - youtu.be/SNVjndgWBlw
👩💻 Detailed Video on Power Query - youtu.be/PiFAa_jjaEI
🎶 Power Query Playlist - youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
🤷♂️ How to _____ in Excel - Playlist - youtube.com/watch?v=S2RRGqR_MNw&list=PLmejDGrsgFyAYGXOFlJ-KsMr4e_XgKY-4
~
#Excel #powerquery
May your data be clean and your days be serene 😀
- Data Cleaning in Excel - 10 Tricks (Beginner to PRO) ( Download)
- Data cleaning in Excel - 10 tricks *PROs* use all the time ( Download)
- Master Data Cleaning Essentials on Excel in Just 10 Minutes ( Download)
- How to Clean Data in Excel in 10 Minutes (Free File) ( Download)
- Data Cleaning in Excel | 8 Tricks to Make You a Pro User ( Download)
- Cleaning Data in Excel | Excel Tutorials for Beginners ( Download)
- 10 Super Neat Ways to Clean Data in Excel ( Download)
- 20 Excel Shortcuts to Save You HOURS of Work ( Download)
- Cleaning Data in Excel - 10 Quick Tips | Excel Tutorial for Data Analysts ( Download)
- 5 Tricks to Become an Excel Wizard ( Download)
- Top 10 Ways to Clean Data in Excel Easily ! ( Download)
- Data Cleaning in Excel 🔥 #shorts ( Download)
- 3 Quick tips to get better in Excel formulas ( Download)
- Excel Pro Trick: Filter Data Dynamically with Excel FILTER Function - How to Tutorial ( Download)
- Master Data Cleaning with Power Query in Excel in 9 Minutes ( Download)
