Minute 00:00 — 01:00 what’s going on everybody welcome back to the excel tutorial series today we will be looking at how to clean data in excel [Music] now knowing how to clean data in excel is actually extremely useful there are a ton of techniques to do this i’m going to be showing you the ones that i probably use the most i feel like are the most helpful to kind of do the bulk or the majority of the data cleaning that you’re going to do in excel like i said there’s so many different ways and very specific things that you can do but i’m going to highlight some of the bigger ones that i find the most useful and some of you may be thinking well i’ll just do my data cleaning in sql or python or when i get it ready to put it in tableau but honestly a lot of the data cleaning at least a lot of the big stuff i tend to do in excel if the data set is small enough to fit in excel and so i think it’s actually really really useful to know how to do this because you’ll most likely be doing it more than you think now before we jump into the tutorial i want to give a shout out to the sponsor of this video and is a brand new sponsor it is unlocked by z by hp unlocked is a