Cleaning Data in Excel | Excel Tutorials for Beginners 

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!

"I really want to acknowledge you right now because I'm just a beginner in data analytics and currently in my second year of graduation. This is my first time exploring the field of data analytics, and I appreciate how well you explained it. As a beginner, I found it complex and difficult to understand, but you made it much easier. I'm truly grateful for that. Thank you, sir!"

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.👍

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

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

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.

I’m returning to a data analyst position after taking a few years off to do some other things. This was an excellent refresher. Thank you!

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

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!

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.

A couple of things I do when I'm working on files similar to this is first duplicate the worksheet so that my original is all the way to the left, and this stays untouched. I also check on what my client wants in terms of data formats like dates, which as you said are very fussy. Somebody recommended going with YYYY/MM/DD as a date standard, but I'd say go with what your client or boss tells you. Thanks for sharing!

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

I learned Ctrl-Y to go forward from this video which was cool. Two things I would have done differently is 1) standardize dates to yyyy-mm-dd 2) Kept decimals in salaries so it doesn’t get read as integers

Hey Alex , Thanks brother I have been watching your video from many past months, I got a good job today and honestly I was never aware that excel jobs are also high paying I think it’s just because of your resources and my hardwork ❤ Keep up the content good 😊 god bless u bro

I had forgotten I did this video a few months back. But I did enjoy understanding the step by step process needed of what to take care first to look at and work from there.

I’m studying Data Analytics, hands down extremely helpful

you are absolutely a gem and best teacher out there

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.

Thank you Alex, you have really helped me in my data learning journey.

I have an associates in Computer Science now and started studying everything I can on SQL and analytics. System Admin is stealing my soul. Wondering if it is worth the time at 43 years old to get my Bachelors in Data Science? Its expensive. But when I look at jobs they all seem to want a bachelors minimum for Data Analytics.

I was the 1K th like. :) So happy that this video exists! Thank you so much. You make Excel fun. :)

This video came right on time, thank you Alex

Thanks Alex. Let's learn other cleaning excel functions.

After downloading a dataset and importing into Excel, SQL, Power BI, etc. How can you tell that it needs cleaning if the first few rows appear correct. Also after cleaning the data, how do you know that you've completely cleaned it and the data quality is 100%

Very thankful for your help with this Excel data cleaning.

Hello Alex, I'm just curious here what actions you took or what keyboard commands you presses in updating those columns from 9:35 - 9:45 that made them look the same for the whig party.

Thank you Alex. This has been very useful

i thought i missed the democratic-domorcatic spelling issue in the video i have it in my data but not in the vid but regardless i spot it and cleaned it up, very easy to understand thanks for the amazing vid

Please create an Excel video on Power Pivot.

Hi Alex, can you make a video on how to show excel skills in one's portfolio? Thanks.

Hey Alex, Great video ! ! Much appreciated.

Thanks Alex, you are the best.

Thank you for this video. I’m having issues cleaning a column that has lots of symbols and special characters, I really don’t know how to go about it

Thanks Alex for the wonderful job your are doing. I learnt a lot from this video

may i suggest using a mouse highlighter so its easier to see where you click and follow along? as a pro you tend to move a bit fast at times and some ribbon /tab features are still unfamiliar

Amazing content Alex , it would be great if you could post few videos about ETL.

On my journey through the boot camp...

Thank you for your endless effort for making this amazing learning video.

I knew these but this video was still helpful.

Great Video Alex!

How do identify to clean in data or Excel? What we need to look? Formating and standardise. Spelling check, Additional space, Removing duplicate Data cleaning =Proper() =Upper () =Lower()

Amazing video! Thank you so much!

Thanks Mr Alex I really love your work you explain difficult things in a simple way, please do complete course on how to use GitHub. I find it difficult to use it

Good video, but may i ask why you didnt use powerpivot for cleaning?

great summary of data cleaning

hey the data set you clean was as simple was to teach playgroup kids ,,, please bring some complex data set cleaning regards

Hi Alex, you are doing excellent job, thank you for helping me in this beginning of the journey. Let me tell you that the file you provide in this video is the same file as the video "Formulas in Excel | Excel Tutorials for Beginners". Keep with the excelent content!!

Hey Alex Freiberg, please explain to me in detail which tools I can use to display my excel skill. Needed urgently

I have even subscribed to get more of your videos😊

Question here - This is more about the content creation then it is the content, but how did you come up with your intro music 🎵? Did you purchase that or work with someone to make your own? Asking hoping that you see this despite the huge crowd trying to get your attn lol

Great analytical skill⚡

Hey Alex, I would like to thank you for this amazing tuto, and I have a quick question, what's the shortcut you are using to copy paste the function on the rest of the list?? I am using MacOS , Thanks.

We can either clean like how alex cleans or we can use powerquery to clean right?

Please help I’m not able to download the file through the link you sent

Alex, thank you! Do you use hotkeys to do your work faster? Do you create customizing hotkeys? Which one do you recommend?

hey , I cannot download the sample files from the description link to Github in any of your videos in the series ...not sure why is this happening.

THANK YOU FOR THE CONTENT.

Hey Alex, under the Remove Duplicates, why doesn't it flag Woodrow Wilson as being a Duplicate too? I downloaded your worksheet and it is at line 29 & 30

Thanks Alex!

Sweet and shot 😍

Great job!

Hi Alex, thank you for all your information, helps a lot! wich excel course will you recommend on coursera ? thanks again

Hi Alex, I really love your videos. Thank you for providing such great information. I have an issue that I can't seem to find a solution. I have an excel csv file that I need to clean. I have an Order Date column that has two different datatypes one is a Date that is in this style mm/dd/yyyy. The other I believe is a string in this format DD/MM/YY. I have tried just about every solution suggested to fix this issue but none have worked so far. How would you handle this?

Great video Thanks a Ton

Thank you very much, that was very helpful. Can you tag me in the second step of data analysis please.

very helpful, thanks alot

Hi Alex, I tried the date formatting and it didn’t work on my data set.

Hi Alex, great videos! Is there a more effective way to do find and replace. If you have a dataset similar to this one but larger and you have maybe 10 presidents' name that you have to constantly change, is there a quicker way to update their names besides find and replace? Thanks. Keep up the good work

Thank you ! !

thanks alex

Thank you for the quality content Alex! I've learnt so much from watching your videos! Also, where can we submit our resumes for resume review series Part 3? :p

thanks ...

Where can I download sample data sets to practice?

thx soo much

I am in need of some help… I’m faced with a an excel spreadsheet with over 100 tabs. Each tab represents a unit 1-100+. Each tab tracks the same test just different unit. I’m wanting to consolidate all tabs into a master list to track results and test dates test that are constantly being added daily. Any recommendations on how to approach this? I just recently accepted a job here and data is all over… any advice is appreciated

Would you ever do this in power query? Why or 2hy not?

To fix data issues: Type over them. good job mate. zero applications

Done

It is me but the data is no longer under the video.

9:40 not a mistake. John Tyler was elected a Whig but was kicked out of the party after 5 months in office. So replacing this datum as you did is not a good idea.

🌼

Instead of cleaning data in PRIOR column you just deleted it?

Thanks Alex!!

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

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.

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.

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

Found my new favorite RU-vid channel!

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

Good afternoon Alex, so I want to ask how do I earn in dollars sir, but right now my challenge is getting a laptop

Wrong link on the excel file by the way in description

"Paste as a Value" is just the functionality of excel that i need... thanks sir

Thank you, and I appreciate your effort and the provided files for practice.

Why not use PowerQuery for loads of those tasks especially as it gives you the possibility to repeat it all over on same data imports …

Thanks for the video Alex. Kindly do a video on using Power Query to clean data.

Hey Alex. Great content, but the excel link over GitHub, which you've shared, ain't working. Not able to download the file.

While your video is great, I feel you could have cleaned the "column D - prior" as well. That could have been a good example of "Find and Replace" function. If one would notice, the column D had this special characters – which made it dirty. I would select the whole Column D, and use "Find and Replace (ctrl+h)" to find – and replace it with hyphen(-). That would make the data cleaner for the whole column.

Hi Alex, I even removed ' . ' in the name column using proper(substitute(text,".","")) formula. Tnx for these excel tutorials... i learnt a lot.

Great video again, Alex. Next - Full project

Hi Alex 👋🏻 great effort man! I have a query. Regarding the original data file we never touch it right, instead we make a copy of it and we do all the work in it ?!