Cleaning Data in Excel - 10 Quick Tips | Excel Tutorial for Data Analysts

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

🎓 MY DATA STUDIO ONLINE COURSE

🎥 USEFUL VIDEOS

⚙️ DATA HUBS:

🧰 BI TOOLS

📊 DATA WEBSITES

🎓 ONLINE LEARNING
→ Skillshare
Get a 30-day free trial of Skillshare Premium!
→Udemy
→Coursera

📕 FREE EBOOKS TO DOWNLOAD
7 Top Tips For Better Dashboard Design
The Skills You Need To Succeed In Business Intelligence

🎥 MY YOUTUBE GEAR

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:

Sign up for my mailing list to be the first to hear about new videos and special offers

#exceltutorial #dataprep #learnbi