Cleaning Data in Excel | Excel Tutorials for Beginners

Excel is one of the most used skills in the data world. In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel.

Excel Data Cleaning File:

Unlocked by Z by HP:

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[aonamphuong]

Thanks Alex. To sum up this video:
- Remove duplicate
- Edit name: use UPPER, Lower or Proper function
- Use filter to look for spelling errors
- Trim white space: TRIM function
- Issue with numerical data: currency, dates

[grantcirks]

Hey Alex, I know this isn't related to this video but it is your most recent one. I've watched a TON of your videos and have been teaching myself how to become a Data Analyst for the past year (with your help obviously). I just accepted an offer to be a Data Analyst at a company in my city and I just wanted to thank you for all of the information and advice you put out into the world. Your videos will have literally changed my life! Keep up the great work!

[saalemsadeque]

Hi Alex, this is perfect timing from my perspective. I teach marketing analytics and one thing I emphasise to students is that it is important to be aware of data quality issues. The students are required to submit an assessment where they do basic cleaning of a dataset in Excel before they create pivot tables/charts and a dashboard. So, this video is perfect and I am sharing this with my students.👍

[marisacarrion]

I don't usually add comments but I have watched a lot of Excel tutorials and this was by far the best one I feel like I actually learned something and can immediately apply it!

[tech_guruLG]

Your videos are a life changer! I never felt so confident in Excel until now! Keep making them!

[davidblackman]

This video is exactly the type of content I look for. It helps me tremendously to be able to walk through a task with someone experienced and see the steps they take themselves to get to where they are going. On to the project!

[polokomonama]

I cannot thank you enough for this boot-camp! Awesome video again Alex, simple but yet still informative!

[sj]

Alex, I love all your videos and content. However, this video was my favorite of your Excel Bootcamp videos. I know the dataset was small and simplified for us, but I felt like you did a wonderful job breaking down the data cleaning process. So, the skills we learned in this video can easily be applied/transferred over to much larger datasets. I so appreciate everything you do for us. As always, THANK YOU!!

[victorbegnini]

Alex, I cannot thank you enough for this type of video.
Thank you for sharing your knowledge and experience with us.

[searchbug]

Loved your tutorial on 'Cleaning Data in Excel' for beginners. You've got such a friendly and approachable way of explaining things. The step-by-step tutorial is super easy to understand. Thanks for the awesome tutorial – keep 'em coming.

[chikwenduaustin]

Hi Alex, I am so grateful with what you pulled out here. Your videos has really helped me in my career as a data analyst. The decisions towards the skills I need as a data analyst and also the project I have to pull too that got me my first job. Thanks a lot

[nickarrigo]

another solid contribution by alex the analyst. your channel is a big asset to the data community!

[mmlewis]

Thanks Alex. This has been incredibly useful. Ingesting terrible data sets probably stops a ton of newbie data analysts and ruins their confidence. It certainly made me pause and question my grasp of the data analytics process. Sometimes a casual walkthrough and helpful tips like this video does wonders as it has for me. Thanks again.

[vivianemeli]

This was really helpful. First time on your channel. I have this very dirty big dataset I needed to work on and was confuse on how to drop irrelevant columns, it was soothing when I heard you say, I could trim the columns and delete any column that isn't relevant to my analysis.

Thank you👌

[arcadevampire]

Great video. Agree with all points. For a new dataset (never seen before and not big data), knowing your shortcuts, you'd clean it much faster than r/python/sql etc. Excel although unsexy is very useful if the turnaround time is important.

[maitreyasharma]

Really great Alex!!
Just one suggestion
we could have cleaned up Prior column to identify secretaries, vice-presidents etc.
So now we would also be able to answer questions like how many secretaries or VP eventually became presidents etc.

[Mayaadyby.]

The way you teach and make even any complicated task so simple to understand and learn is impressive!

[equiwave]

Hi Alex, This was the best video for cleaning in Excel that I have come across in YouTube. I learnt a lot of concepts with respect to what we need to do when it comes to data cleaning in any new data set...

Thanks for all your efforts Alex!!!

[awedaoluwanifemi]

Great one Alex. I have certainly become a better Data analyst thanks to your videos

[MyteeBumbleBee]

Alex, I am so grateful to you. Thank you so much for sharing your knowledge. I learned new Excel functions and your delivery of this important information was exceptional. Thank you Alex. This was a very helpful presentation.