Clean Messy Data in Excel: 10 Super Simple Tricks You Need to Know
Learning how to clean data in excel is a vital skill, especially if you work with lists of data. You see, sometimes when you import data (read copy/ paste 🤣) into excel the results are a mess and knowing how to clean your data is vital.
This lesson covers how to remove blank rows, clear all formatting, check for duplicates, breaking data into smaller parts using text to columns, and fix inconsistent data using such functions like TRIM, PROPER, and UPPER.
⌚ Timestamps
0:00 Intro
1:07 Remove blank rows
1:39 Clearing formats
1:55 Checking for duplicates
2:14 Text to columns
3:35 Using Flash fill
4:12 Using TRIM function
4:40 Using the PROPER function
5:02 Using the UPPER function
5:24 Filling in blank cells
6:02 Using Copy/ Paste Special
💾 **DOWNLOAD PRACTICE FILE **
https://1drv.ms/x/s!AgnhzVKiTqWmgSL5r...
📄 * FREE RESOURCES*
Mega Cheat Sheet
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
☕ ** BUY ME A COFFEE? **
https://www.buymeacoffee.com/professo...
Смотрите видео Clean Messy Data in Excel: 10 Super Simple Tricks You Need to Know онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 19 Октябрь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 400 раз и оно понравилось 11 людям.