what’s going on everybody today we are starting our excel tutorial series [Music] now there are so many things that you can do in excel so i don’t know how long the series is going to be it could be 15 or even 20 videos but what i do know is that i’m going to be covering just about every single thing that i’ve used since i became a data analyst and i want to show you how to do it so it won’t just be the more concrete things you know like pivot tables charts vlookups things like that it’ll also be some of the more nuanced things like how to deal with missing data or how to deal with dirty data and how to clean that up within excel and so those are things that you may not be able to do you know if somebody wasn’t showing you how to do it and so that’s what i’m going to try to help you because i know that that is something that you will need to do or learn how to do in excel now before we get into it i want to give a huge shout out to the sponsor of this excel series and that is udemy i took so many excel courses on udemy when i was first starting out as a data analyst and there was this one course that i kept going back to over and over again because as i