Cleaning Data in Excel | Excel Tutorials for Beginners

[@grantcirks362]

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!

[@ugochibenitazita4209]

@Grant Cirks congratulations

[@sodabaniazi6108]

Congratulations!! I just wanted to ask if you did any online certification as well along watching his videos?

[@grantcirks362]

@@sodabaniazi6108 yes, I did the Google Data Analytics Professional Certificate

[@sodabaniazi6108]

@@grantcirks362 send you a connection request

[@dongyan8717]

Me too! The portfolio is huge! Thanks Alex and congrats

[@harshavardhan891]

"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!"

[@aonamphuong4139]

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

[@harshnaidu7656]

This summary is helpful too who can not watch the full video.! keep it up man 👍

[@mj-fm4bp]

To hop in on the helping train, timestamps: 3:45 Remove duplicate 5:20 Edit name: use UPPER, Lower or Proper function 8:02 Use filter to look for spelling errors 10:42 Trim white space: TRIM function 12:20 Issue with numerical data - currency 13:50 Issue with date type data 15:52 Apply the formula after calculation (get rid of reference to cells)

[@nehpets_enem]

THANKS MAN

[@saalemsadeque9516]

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

[@manumaravilla]

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

[@victorbegnini5754]

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

[@polokomonama6526]

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

[@tech_guruLG]

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

[@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.

[@marisacarrion310]

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!

[@ryanj748]

Found my new favorite KZbin channel!

[@chikwenduaustin2141]

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

[@deraanagor1520]

@Chikwendu Austin please do you work as a data analyst in Nigeria. I decided to switch to data analysis and am happy I came across this awesome channel. Please can you tell me how long it took you to get a job in Nigeria (if you work for a Nigerian company) and where you found the job or how you applied. Thank you.

[@chikwenduaustin2141]

@@deraanagor1520 the company I work for actually were the ones that enrolled me in the training process to learn some basic skills…so I was retained as a data analyst.

[@Deekshi-ej8wc]

Thanks alex for being my bestie and also cleaning my confused mind into sorted . a big heart for you ❤️

[@awedaoluwanifemi8024]

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

[@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.

[@mmlewis1030]

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.

[@davidblackman7478]

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!

[@sunsetwithmee]

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

[@loslerner]

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!

[@shreya6115]

Hey, follow this guy. He has pivoted into data analyst and has really helpful videos kzbin.info/www/bejne/l6m3pZJrj9dnbK8

[@Tina-gp4rg]

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

[@vivian_emeli]

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👌

[@queilamarques4646]

Thanks, Alex! Resumindo este vídeo: - Remover células duplicadas; - Editar nome: use a função MAIÚSCULA, MINÚSCULA E E PRI.MAIÚSCULA; - Usar o filtro para procurar erros de ortografia - Aparar espaço em branco: função COMPACTAR - Emissão com dados numéricos: moeda, datas

[@berevaji5372]

Thanks, this was great! Very explanatory and to the point. As someone who is self-studying to become a Data Analyst, your content is a life saver.

[@AlexTheAnalyst]

So glad to hear it!

[@shreya6115]

Hey, follow this guy. He has pivoted into data analyst and has really helpful videos kzbin.info/www/bejne/l6m3pZJrj9dnbK8

[@nickarrigo5540]

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

[@EbertonReed]

Need this video! Very helpful and you have a new subscriber. Thanks again!

[@Mayaadyby.]

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

[@saoirb98]

Simple yet effective things you can do to clean data in Excel, very helpful thank you

[@fernandoherranz4095]

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!

[@fernandoherranz4095]

And as somebody mentioned below, I also almost immediately convert my data set into a colored table so I can more easily see blanks and such, as well as remove dupes and the like. Thanks!

[@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.

[@habibmaryam]

Thank you for this boot camp Alex. I enjoyed it such that I wasn't even aware of the time. I was wondering why the concluding message. Found it really interesting and gave me a glimpse of data cleaning. I now understand why a data analysts job involves more of cleaning than analysis. I am grateful I stumbled upon thi spage.

[@rayyanzaidi3323]

you are absolutely a gem and best teacher out there

[@nabatanzijovia5328]

Woow Alex thank you so much for this video, you have clearly taught me and for sure am gaining skills. thank you keep it up👋👍 you are such an excellent teacher👌

[@carvelialevi]

tomorrow i have an interview for market research at japan company, one of the question is about cleaning data in excel. thankyou for making this video!! you helped me a lot! thank you so much! break a leg for me !

[@AjStyles-ix6lq]

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

[@meshInfo-Power]

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

[@joeltochukwu4199]

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

[@tanuibrenda5511]

Thank you Alex. I'm learning a lot from your videos.

[@theabominabletrollman5763]

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

[@nkhofi]

What a great insight!!! Please keep more videos coming

[@AkporHari]

Great video again, Alex. Next - Full project

[@edwingultom9362]

Thanks Alex! It's on point and really helpful.

[@Nico.Rabeee]

i m starting in the game , thanks a lot for this beginner videos, they re straight to the point and really helpful¡¡¡¡¡

[@albedoguardian875]

I’m studying Data Analytics, hands down extremely helpful

[@nathanielbalmes6597]

Very thankful for your help with this Excel data cleaning.

[@ItsGibb]

Its a really helful tuitorial. I subcribed right away the minute it helped me with my problem. Thank you for your expert advice.

[@TheTriangleOffense47]

This video came right on time, thank you Alex

[@shabanirashidi1263]

Sure

[@sasas2942]

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

[@StrumpanzerFuhrer]

I wish i watched this before my job interview, it would have helped with everything!

[@kirktheruler5572]

Thank you alex, and bravo for explaining the why behind use cases

[@asmitatiwari819]

thankyou for this video! extremely insightful video

[@isooloyede6919]

Thank you Alex. This has been very useful

[@evilrobots]

Quick trivia - the 'random number' at 15:15? It's the number of days since December 31, 1899. This is how Excel handles dates and times. Each day has a value of 1. Jan 1, 1900 = 1. 11/22/63 = 23337. I watched this video on 45202. Times during the day are portions of one expressed as a decimal. 6:00 am is 0.25. Noon is 0.5. The 1899 start date was chosen so that excel could recognize and work with any date in the 20th century. Unfortunately, negative numbers are considered out of range and generate an error message, so Excel cannot work with dates before 1/1/1900. Cheers! Love the videos!

[@lgminsight4875]

Hi Alex, thank you for all the content you provide it has really been helpful. Could you by chance share a video on how to clean up massive amounts of data that actually needs to be organized prior to being properly tabulated, that has a lot of white space and black rows etc? Many of the videos online are just for beginners to advanced with data thats already somewhat clean and takes 4-5mins to get ready.

[@laneferm3539]

Hey Alex, Great video ! ! Much appreciated.

[@ayanaxhye]

Thank you for taking time out to teach us these skills 🥹really appreciate

[@danielblum5691]

Thank you for this video. I am taking the data analytics course through CareerFoundry and this was a helpful reference.

[@uesleicristian]

Thanks Alex, you are the best.

[@brianbc19]

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

[@woljin]

If your using Excel for your data manipulation I'd recommend turning all data sets into a table. Most of what you're explaining is auto corrected in the table conversation process. That and the file will be 90% smaller (without having to make it binary) if saved in a table with defined formates per column. Just my two cents man.

[@emmanuelorazulike2288]

thank you so much , your videos are educative . im glad to be your student

[@AljIsHere128]

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.

[@amehagada2846]

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

[@victorolowomeye4717]

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.

[@mr.mcloremcclure2522]

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.

[@techinicalocean8733]

Hope you are doing well in your life❤

[@missy163]

Thanks Alex.I really larnt a lot

[@danielhutchinson6158]

Thank you Alex.

[@gladysgabriel2379]

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%

[@sylvalineiroegbulem]

thanks alot. it really helped me

[@stelios278]

Thanks for your effort keep up the great work

[@WaayoArag.]

Waaaw, I really appreciate that good work. Thank you✌🏾

[@HBplaces]

Thank you for this video. I'm taking Google Analytics Certification with coursera.

[@johannpauldalingay7329]

Hello Alex. I am an aspiring data analyst and I find your videos very helpful. :) Please make a video about work flow. 😀😀 Thank you! 😀😀

[@shashwatchaurasia8780]

Useful Video For Campus Placement | NIT Raipur

[@pseudo-black6343]

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

[@mitulsp8873]

where did you find the data set?

[@pseudo-black6343]

Hey, you can get it from the description

[@Adekolaau]

this was really help, I'm really grateful for this. I'm starting o feel like an expert in excel. woohoo!!!!

[@xiskagaming3374]

Thanks so much, little changes make it clean 👌

[@marialeticiamartins8798]

The best content on internet! Thanks for that! Do you know where I can Find more dirty data to practice and do more cleaning data projects? Thanks!

[@adetomy6309]

kaggle

[@alfonsocordovacruz5244]

Very nice presentation!!! 🎉

[@ashhardamda]

I knew these but this video was still helpful.

[@joe_va]

Thank you so much Alex ❤

[@khaledmohamed123]

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 ?!

[@larissasantos9354]

Amazing video! Thank you so much!

[@peaceokoroji4869]

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

[@keshavkarki7775]

Hi Alex, this was very simple and beginner friendly data cleaning can you make one advanced level data cleaning video?

[@ajaycb590]

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

[@ShubhamChawla]

Great Video Alex!

[@iheomaokam958]

great video Alex. Thaank you

[@darkangelus1987]

great summary of data cleaning

[@1689JeffChavez]

On my journey through the boot camp...

[@1689JeffChavez]

I learned a lot in this one. Don't forget to back up your raw file!

[@sundayamoo84]

Thanks for this video Alex Pls how can we clean a null values in date column and blank values in date column

[@justbelit]

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

[@nabatanzijovia5328]

I have even subscribed to get more of your videos😊

[@connargocken1437]

Great video!

[@adwaamohamed2674]

VERY USEFUL THANK YOU

[@castrolisole3773]

Great analytical skill⚡

[@awedaoluwanifemi8024]

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

[@hstppt]

Yes, that would be helpful! I need to be able to demonstrate basic data cleaning, and I am wondering how best to document & display the steps I took

[@Idrizly]

THANK YOU FOR THE CONTENT.

[@shreya6115]

Hey, follow this guy. He has pivoted into data analyst and has really helpful videos kzbin.info/www/bejne/l6m3pZJrj9dnbK8

[@rmicbdng]

thanks alex!

[@muhammadajmal562]

Great efforts sir please make a video on data extraction

[@shreya6115]

Hey, follow this guy. He has pivoted into data analyst and has really helpful videos kzbin.info/www/bejne/l6m3pZJrj9dnbK8

[@MANSITODI]

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.