Minute 02:00 — 03:00 this is not a full project so you know we’re actually going to be using this to create any visualizations or anything like that so you know all this is just for demonstration purposes but we will be doing a full project in about two or three videos in this excel series where we’re going to be doing from start to finish with a real data set so you know if that’s something that you’re you’re wanting then we’ll absolutely be doing that now something Formatting Standardization that you may be wondering is how do you actually identify what you need to clean in the data what do you know to look for well some of the obvious things are things like formatting and standardization so things like you know this james monroe is in all caps that happens all the time within real data and so you know you want to standardize that or this all lowercase you want to standardize that you want that all to be the same there’s also things like right here where we have this wig and this wig with a bunch of random stuff after it Additional Spaces this happens all the time where it’s not completely standardized and you may even notice you know there are some