Data Cleaning in Excel - 10 Tricks (Beginner to PRO)

Download information and video details for Data Cleaning in Excel - 10 Tricks (Beginner to PRO)
Uploader:
ChandooPublished at:
4/12/2022Views:
439.4KDescription:
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 😀
Similar videos: Data Cleaning in Excel
![19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]](https://videodownloadbot.com/images/video/d63/veudohxo32sri6xeq649yxd25s0r1pw0_medium.jpeg)
19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]

VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

Top 10 Excel Functions you should learn in 2024

Analyzing Data with Excel IBM Full Course

SQL from basic to Advanced | Types of Commands in SQL - Day - 2

