 So one of the things I have at my disposal with Excel is if we take a look at all of this information You know, it's not information yet. It's it's actually just data. I've got a 100 different just oh under a hundred different sales records going on with who sold what's for how much where and when but I don't see any kind of information coming out of this like who was the best salesperson and Where's the best kind of region to go from and so what I can do is I can all of a sudden say well Let me take this information And let me do some kind of special stuff inside of Excel with it The first thing I can do is I can highlight all of this information I can do that by simply clicking holding and dragging But as you can see there's a lot of stuff and what happens if as you can see I had to go for a while I don't want to do that So what can I do Well instead I can actually let's just see this for a second if I hit the end button Nothing happens However, if I hit control end You notice it jumped down to row 100 if I hit control home comes back to a 1 If I hit say for example shift, I'm holding the shift key and I move down You see all of a sudden I'm highlighting things. Well, let's actually merge those two things together if I Hold control hold shift and then press end Now it's not 100% perfect. You see I have a few blank spaces But keeping shift held down release control and press up one two three times All of a sudden I have all my data highlighted and I didn't have to click and drag anything Now what I'm able to do with this is I'm able to utilize this data tab right here This data tab as you can guess has a lot of options in there for example sorting and filtering say for example I want to sort Well, if I click on that button, I get a nice little drop down or dialogue box menu in this case asking me What to sort by? Oh to start off. I'll just sort by say my sales representatives And I can click on that drop down menu and you see I get sales representatives and I hit okay Now you see I get Rachel Anderson and Peter Bucknell then David Cushman But the problem is I get the same kind of process You see none of Rachel's stuff is sort of being highlighted right now. So maybe I want to sort this again Well, what I can do as you can see it was very nice to kind of already pick that up is I can select add level and just like it reads sort by first the sales representative by this way Then by in this case, I want to do sales, but I want to do sales from top to bottom. So the best sales going down again, I can select sale and Since Excel smart enough to realize sort of we're talking about numbers instead of words It will tell me from smallest to largest. I can change this obviously and go from largest to smallest When I hit okay, all of a sudden I see that I get Rachel Anderson and Peter But Rachel's first. There's Peters. There's David's I Can do the same kind of concept here all of a sudden I'm gonna add in the filter button Notice the only difference that really happened was every single one of my headers over here Got a nice little drop-down menu and so say for example, I only want to see the sales of Say for example, I don't know business times I can select select all that removes everything and if I say come over here to business times And I hit okay Now all of a sudden I only see the sales from all the different sales representatives still sorted When they did business times I can go back if I want to change that or do multiple ones IT Weekly for example, I can see them both or I can kind of bring them all back The other little thing is I typically like to see this kind of thing where I can now narrow it down to just a particular person