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...
Watch video Clean Messy Data in Excel: 10 Super Simple Tricks You Need to Know online without registration, duration hours minute second in high quality. This video was added by user Professor Cubs 19 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 400 once and liked it 11 people.