 So now I've got room above it. So I could say these are the words. I'm just typing in words. Notice it's formulated in the formula bar. If I want to move to the right, I could click over here and I can also hit Tab. So I'm going to hit Tab and that moves it to the right. And then here I'm going to say, well let's say word count. Let's say word. I'm going to double click on here count and put count. And then over here I'm going to put words. All right. Now on these two, notice this cell is longer than what I have room for. And I was still able to override it on this cell. But I could try to make this cell longer. I could put my cursor in between A and B and extend the cell like that. My other methods that I might use here is I might say maybe I want to wrap the text. I can go to, let's select these two. Home tab. Let's go to the alignment group and then wrap the text. So what that does is it automatically wraps the text. We've got to be careful of that because it also makes this wide cell if there was anything to the right of it. But in this case I'm okay with that. I also want to center the text. Home tab, alignment, center in the text. That's not the one I wanted. Let's keep it there. Center is this one. Center the text. Now because this is a header you also might format the header with a different color or something like that. But in our case and you might make it bold to make it a header. Home tab, font group, bold. Now the next thing I would like to do with this data set is sort it by the most used to the least used. So this is basically alphabetical order. I want to sort it this way. So one way we can do that is I could select all this information and then go to the data tab and I can add a filter. Sort and filter, add in the filter and that puts us these little filters up top. So now I can sort the data. Now that works but it's not my favorite way of doing it because I feel like I might lose, I would rather have it in a table usually. So what I will do is I'll turn off the filters and instead I'm going to select the data. Now note when I make a table I could add the whole data set like this and then go to the insert tab and I'm just going to put a table around it. Or because there's no blank cells in this there's no blank cells that are all populated and the first two are boldened so Excel can note that that's probably a header then I can go to insert and table with just one cell highlighted, just one and say insert the table and it puts what they call the dancing ants. The Excel is fun guy makes dancing ants around it and they're more like marching ants. They can get a little groove on. If you put a microphone like if you looked in real close you can see they were actually dancing and not just marching. They got a lot more going on but we can't see it because we're out. But in any case then you can see that we have the table range which is don't worry about the dollar signs right now but A1 to B21 that's the range of the data, A1 the cell to this range of B21 is the range of the data so we're going to say that looks good. We can also just see it visually insert the table. So now we have our table. Now note on A I can make A a little skinnier again and it'll still wrap the text alright so now we've got these filters that dropped down so what I'd like to see is the filter by the word count so I'm going to filter it by the word count hitting this drop down. I want to go from A to Z. This is an alphabetical order but it's going to go from that'll take it the other way showing the smallest to the highest right and then if I flip that and go from Z to A now I've got the largest which is probably the most important on top so if I was going to sort this data this is the first thing we'd probably do right we'd say okay here's all the words which word is used most the Lord well that might tell us something about the thing maybe it's clearly going to be a play about you know Lord's. A lot of high brow people in it or something you would expect and so that gives us a little bit of a representation of the data. Now if I wanted to visualize this data we can do just the standard bar chart which is generally fairly easy to put in place I can select all of this and we can say insert and then if I go to the charts note the recommended chart sometimes is a useful thing to look at because it gives you some different representations that you might be not be as familiar with that gives you some good ideas of different ways to format the data so I'm visualizing the standard bar chart but of course you could flip the accesses on it and represent it represent it this way or you could see it this way and you know different kind of representations but there could be a problem with this bar chart so let's take a look at it if I insert a bar chart just like this notice there's an issue with it because you know obviously nothing's being represented here right now one of the we could try to adjust the bar chart from here but one of the things that will make it easier to automatically put the bar chart in is to switch the order here so I'd like the words on the left hand side and then and then the word count let's call it word not words count word count on the right hand side because that usually then Excel will pick up the X axis for the items that are on the left so let's try to move that over now there's a couple ways we can move it we could try to insert a column on the left and move it but the easiest way to do that is to actually select the entire column we want to move so I've got my cursor on B I've got that arrow drop down I select the entire thing and then the key is that you have to hold down the shift and then you put your cursor on the on the in-between spot so you get those four arrows hold down the left click we're going to click and drag now and drag it to the right and then let go so now we've got the words on the right the word count on the left and so now we should be able to insert our table also note that when you insert the table you could select simply the data down below if you pick up the headers Excel should really generally recognize that that is the header so I could pick up the entire thing with the headers like so and then we can go into the insert tab up top once again we go into our charts and we're looking for the standard bar chart here we have different variations these being basically the same kind of chart right so I can look at it this way this way we've got our more 3D kind of bar charts and so on and then we have the axis is turned the other way with our bar charts but let's just do the standard bar chart so there we have it I'm going to pull this I'm going to put my cursor on that left part of it pull it to the left and then notice it put it put up top word count now that might not be exactly the title we want so I could click on this and say this is going to be let's say I'm going to go into it and say this is Hamlet word count right so then we've got our title up top I can make it a little bit larger and it in essence it does everything that we basically wanted to do to make our chart by just basically implementing it there so which is nice so now we've got this pictorial representation now I just want to point out that this is not exactly a histogram but it's giving us a similar kind of thing so if I go to the insert notice that we have up top these items insert a column or bar chart versus this one which is to insert a statistic chart so if I hit the drop down we have a histogram here so the histograms will look at later which are which looks similar in terms of a representation and the differences that we have these buckets within the histograms because we're usually looking at an X axis that has numerical data within it but we can actually format the data to use a similar kind of bar chart so we'll look at histograms later but we want to keep those two things separate in our mind but the concept is similar here we're saying hey look this data on the left is giving us useful information in a lot of ways but it's not useful unless it's organized it's great here that we can organize it from top to bottom and I can see the words that are used the most but of course the pictorial representation is going to give us even more more data so if I just look at this pictorial representation it's probably going to more easily show us exactly what's going on and more clearly show it easier to display to other people and all that kind of stuff now if you