Cleaning Data in Excel | Excel Tutorials for Beginners

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

[@JudithChinenye-v1v]

Thanks so much for the summary 👍👍

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

[@manumaravilla]

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

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

[@ryanj748]

Found my new favorite KZbin channel!

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

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

[@JudithChinenye-v1v]

I'm so excited i found this channel, have interest in data analysis but have no prior knowledge on that, hopefully will get a lot from here, thanks so much 😊

[@victorbegnini5754]

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

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

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

[@Deekshi-ej8wc]

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

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

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

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

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

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

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

[@sunsetwithmee]

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

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

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

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

[@defenstration-dvb]

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!

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

[@awedaoluwanifemi8024]

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

[@sj1795]

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

[@albedoguardian875]

I’m studying Data Analytics, hands down extremely helpful

[@equiwave80]

Hi Alex, This was the best video for cleaning in Excel that I have come across in KZbin. 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!!!

[@AlexTheAnalyst]

So awesome to hear that! Thanks for watching!

[@Mayaadyby.]

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

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

[@rayyanzaidi3323]

you are absolutely a gem and best teacher out there

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

[@Tina-gp4rg]

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

[@AkporHari]

Great video again, Alex. Next - Full project

[@joeltochukwu4199]

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

[@saoirb98]

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

[@nickarrigo5540]

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

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

[@StrumpanzerFuhrer]

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

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

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

[@Nico.Rabeee]

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

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

[@sasas2942]

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

[@meshOmondi]

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

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

[@danielblum5691]

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

[@nathanielbalmes6597]

Very thankful for your help with this Excel data cleaning.

[@tanuibrenda5511]

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

[@Adekolaau]

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

[@kirktheruler5572]

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

[@nkhofi]

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

[@EbertonReed]

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

[@HBplaces]

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

[@ItsGibb]

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

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

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

[@emmanuelorazulike2288]

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

[@brianbc19]

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

[@shashwatchaurasia8780]

Useful Video For Campus Placement | NIT Raipur

[@edwingultom9362]

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

[@TheTriangleOffense47]

This video came right on time, thank you Alex

[@shabanirashidi1263]

Sure

[@laneferm3539]

Hey Alex, Great video ! ! Much appreciated.

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

[@asmitatiwari819]

thankyou for this video! extremely insightful video

[@nabatanzijovia5328]

I have even subscribed to get more of your videos😊

[@isooloyede6919]

Thank you Alex. This has been very useful

[@WaayoArag.]

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

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

[@keshavkarki7775]

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

[@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! 😀😀

[@xiskagaming3374]

Thanks so much, little changes make it clean 👌

[@sundayamoo84]

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

[@SimonUjah]

Thanks 👍 alot Alex , you are great!

[@ayanaxhye]

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

[@uesleicristian]

Thanks Alex, you are the best.

[@missy163]

Thanks Alex.I really larnt a lot

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

[@sylvalineiroegbulem]

thanks alot. it really helped me

[@Chalo97Pizarro]

No one: Literally no one: Alex: "That happens aaaall the time"

[@SieanElpidama]

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

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

[@ElliottRopell]

I loved this! This helped a lot :)

[@ashhardamda]

I knew these but this video was still helpful.

[@danielhutchinson6158]

Thank you Alex.

[@castrolisole3773]

Great analytical skill⚡

[@amehagada2846]

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

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

[@alfonsocordovacruz5244]

Very nice presentation!!! 🎉

[@Oreoshake02]

Please make a part II of the same for intermediate or advanced users...🥲

[@stelios278]

Thanks for your effort keep up the great work

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

[@kumbertrandkum3008]

KUM BERTRAND KUM. This was really great. Amazing Videos. Becoming a Data Analyst

[@connargocken1437]

Great video!

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

[@MrBasu-iq6md]

Please create an Excel video on Power Pivot.

[@albedoguardian875]

Quick question? When writing time in 00:00 for 12:25AM format why does it get converted to 0:25. Any quick fix?

[@ajaycb590]

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