Minute 04:00 — 05:00

of someone who’s going to be using this dashboard do they know what m and s is do they know what m

and f is and if Find and Replace they don’t it’s better to just spell it out for the most part so let’s just do that so we’re going to click on the column b we’re going to hit control h that’s going to bring up our find and replace now there’s an m in both of these columns and there’s different things one is married and one means male so what we’re going to do is we’re going to search by columns and we’ll have match case i don’t think that’s going to change anything but that just means an exact match and we’re going to do m equals and we’re going to replace it with married and we’ll replace all awesome and then we’ll do s is single this one is super easy we’re going to do the exact same thing right here so column c hit ctrl h we’ll do still has by column so we’ll do m is male and we’ll replace all of those