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
https://learnbi.online
🎓 MY DATA STUDIO ONLINE COURSE
https://geni.us/vbi-edu
🎥 USEFUL VIDEOS
7 Steps to Your 1st BI Analyst Job - https://youtu.be/0zN0MM1SJMw
Learn Basic SQL in 15 Minutes - https://youtu.be/kbKty5ZVKMY
BI For Beginners Playlist - https://www.youtube.com/playlist?list=PLR0triVyTrBXF6iIJrRRUj1-SNJvinLWE
⚙️ DATA HUBS:
Power My Analytics: https://geni.us/YLc9Re
Supermetrics: https://geni.us/5SNn
Data Slayer: https://geni.us/dataslayer
🧰 BI TOOLS
Power BI - https://powerbi.microsoft.com/
Tableau - https://www.tableau.com/
Data Studio - https://datastudio.google.com/
📊 DATA WEBSITES
Kaggle - https://www.kaggle.com/
Statista - https://www.statista.com/
Data World - https://data.world/
NYC Open Data - https://opendata.cityofnewyork.us/
UN Data - https://data.un.org/
🎓 ONLINE LEARNING
→ Skillshare
Get a 30-day free trial of Skillshare Premium!
https://geni.us/skillshare30day
→Udemy
https://geni.us/udemy_vb
→Coursera
https://geni.us/coursera_analytics
📕 FREE EBOOKS TO DOWNLOAD
7 Top Tips For Better Dashboard Design
https://geni.us/dashdes-ebook
The Skills You Need To Succeed In Business Intelligence
https://geni.us/biskills-ebook
🎥 MY YOUTUBE GEAR
My Camera - https://amzn.to/3J5lbeo
Most Used Lens - https://amzn.to/3hXoE2Q
B-Roll Lens - https://amzn.to/3pSUeDh
Main Tripod - https://amzn.to/3pSUeDh
Vlogging Tripod - https://amzn.to/3tOpJPZ
Main Key Light - https://amzn.to/366KaPI
Softbox - https://amzn.to/35HrR46
LED Panel Kit - https://amzn.to/35K3Lpf
Teleprompter - https://amzn.to/3hWGT8p
Main Microphone - https://amzn.to/3t1n1aK
Mic Boom Arm - https://amzn.to/3hUHzuX
Lavelier Microphone - https://amzn.to/3vVUi8V
C-Stands - https://amzn.to/3vZMoLN
Computer - https://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 https://learnbi.online/contact
Sign up for my mailing list to be the first to hear about new videos and special offers
https://geni.us/PSgRsF
#exceltutorial #dataprep #learnbi