Data cleaning, data wrangling or data preprocessing is a skill that all data analysts require and is essential for making data as easy to aggregate and analyse as possible. In this video, I’m going to give you 10 quickfire tips for cleaning data in Excel.
00:00 Intro
00:30 Make a copy
00:56 Remove duplicates
01:40 Remove blank rows
02:29 Remove blank spaces
03:28 Capitalization
04:31 Separating names
05:18 Numbers to percentages
05:45 Dates to ISO
06:19 Make sure numbers are numbers
07:09 Remove currency symbols
08:02 Clean the clean!
08:32 Outro
⭐️ HEAD ON OVER TO OUR WEBSITE TO START YOUR BI JOURNEY
learnbi.online
🎓 MY DATA STUDIO ONLINE COURSE
geni.us/vbi-edu
🎥 USEFUL VIDEOS
7 Steps to Your 1st BI Analyst Job - youtu.be/0zN0MM1SJMw
Learn Basic SQL in 15 Minutes - youtu.be/kbKty5ZVKMY
BI For Beginners Playlist - youtube.com/playlist?list=PLR0triVyTrBXF6iIJrRRUj1-SNJvinLWE
⚙️ DATA HUBS:
Power My Analytics: geni.us/YLc9Re
Supermetrics: geni.us/5SNn
Data Slayer: geni.us/dataslayer
🧰 BI TOOLS
Power BI - powerbi.microsoft.com/
Tableau - tableau.com/
Data Studio - datastudio.google.com/
📊 DATA WEBSITES
Kaggle - kaggle.com/
Statista - statista.com/
Data World - data.world/
NYC Open Data - opendata.cityofnewyork.us/
UN Data - data.un.org/
🎓 ONLINE LEARNING
→ Skillshare
Get a 30-day free trial of Skillshare Premium!
geni.us/skillshare30day
→Udemy
geni.us/udemy_vb
→Coursera
geni.us/coursera_analytics
📕 FREE EBOOKS TO DOWNLOAD
7 Top Tips For Better Dashboard Design
geni.us/dashdes-ebook
The Skills You Need To Succeed In Business Intelligence
geni.us/biskills-ebook
🎥 MY YOUTUBE GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
B-Roll Lens - amzn.to/3pSUeDh
Main Tripod - amzn.to/3pSUeDh
Vlogging Tripod - amzn.to/3tOpJPZ
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Microphone - amzn.to/3t1n1aK
Mic Boom Arm - amzn.to/3hUHzuX
Lavelier Microphone - amzn.to/3vVUi8V
C-Stands - amzn.to/3vZMoLN
Computer - amzn.to/3KB3RhU
Disclaimer: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT:
For business inquiries visit learnbi.online/contact
Sign up for my mailing list to be the first to hear about new videos and special offers
geni.us/PSgRsF
#exceltutorial #dataprep #learnbi
- Cleaning Data in Excel - 10 Quick Tips | Excel Tutorial for Data Analysts ( Download)
- Cleaning Data in Excel | Excel Tutorials for Beginners ( Download)
- How to Clean Data in Excel in 10 Minutes (Free File) ( Download)
- Master Data Cleaning Essentials on Excel in Just 10 Minutes ( Download)
- Master Data Analysis on Excel in Just 10 Minutes ( Download)
- 10 Super Neat Ways to Clean Data in Excel ( Download)
- Data Cleaning in Excel - 10 Tricks (Beginner to PRO) ( Download)
- How to Clean, Analyze and Present Data with Excel (FREE Adv. Course) ( Download)
- Master Power BI with Netflix Data: Ace Your Data Analytics Interview! ( Download)
- Excel Formatting Cleanup: The Fast And Easy Way To Clean Your Data ( Download)
- Top 10 Essential Excel Formulas for Analysts in 2024 ( Download)
- 3 Quick tips to get better in Excel formulas ( Download)
- Advanced Excel Data Cleaning Tricks ONLY Experts Know ( Download)
- Data cleaning in Excel - 10 tricks *PROs* use all the time ( Download)
- Use Some Creativity In Excel Sheet 😎🔥🔥 || Subscribe for More Tips and Tricks 🔥🙌 ( Download)
