All right. I'm going to just show you an example here of how we might use a lot of what you have learned about already in this course for a real-world example. So what I'm going to be creating here is known as a Gantt chart. This is available in a file called Gantt chart.xlsx. What a Gantt chart basically is, is a timeline, a graphical depiction of a timeline of different tasks. This is just for a hypothetical timeline for building a house. The first thing I'm going to do, you notice here that some of these labels, so these are the different tasks that are going to occur over the next couple months. Two of these in fact are spilling over to the right. So I'm just going to go up here, wrap text. All right. So we can do that quite nicely. I'm now going to add in the months. We can just type in the first month. A lot of times in Excel, at least in the more recent versions of Excel, is a smart autofill. You can refer to a previous screencast about autofill on this. But if we type in January, January is pretty popular for use in Excel. So I'm going to go ahead and on the lower right you get this solid black plus sign. I'm going to go ahead and click, and I'm going to drag. You see that it's recognizing that we have a series. So I'm just going to drag maybe over to September. We're going to build our house, January through September. Maybe I wanted to center all of those in their cells, and maybe we want to underline. So let's just go ahead and underline, and let's center. Now a Gantt chart, you basically highlight the various months with different colors. So I'm just going to put a green in there. That means that in the month of January, we're going to make our architectural drawings. I'm just going to pause this and I'm going to add in a bunch of green highlighting for our hypothetical house building. All right. So I've highlighted the various timeline aspects of our Gantt chart. Maybe I wanted to put borders around this, so I can select this entire region. I'm just going to go ahead and add in all borders. Actually, I don't really like the underlining, so I'm going to go ahead and just de-select that underlying. These months I'm going to enclose with borders as well. So there's our Gantt chart. Since the electrical and plumbing are last, I'm going to actually move those rows. In fact, I'm going to take my framing, roofing, windows, and siding, and I'm just going to go ahead and select those. I'm going to cut and then I'm going to Insert. It always inserts above the row that we select. So I want to insert that before electrical. Electrical and plumbing usually come less. So I'm going to insert the cut cells. You see that we've removed the framing through siding and squeeze that in. Now I like that a lot better than it was. In fact, I think I want to move electrical one row up, so I can always cut, and then I'm going to put that above siding. So I'm going to do insert cut cells. So that's how you can move around different rows of the worksheet. Maybe you decide that you have another category, maybe the flooring. Maybe we want to put in the flooring here, you can always insert an entire row. What that does though, unfortunately, is it carries down the formatting. So I'm just going to go up here, I'm going to de-select. So we have no fill. I'm going to add flooring. Let's just say we have it in August. So that's where I could put that in. By the way, I'm not a contractor, so this could be completely off. Now, I really don't like this because some of these things don't take the entire month. Maybe submitting the building permit, that might take a couple days. So what I'm going to do is, I'm going to insert some more columns here. So I'm going to insert columns, and a quick way to do this is you can right-click on the top here, the Column Heading, right-click, and I'm going to insert a column. Now, for each month, I'm going to basically have four columns representing the approximate four weeks of that month. So I would really have to insert a column three times, so I have a total of four. So that's one way we can do it. Then we want to merge and center January over those approximate four weeks. So I'm going to go up here and merge and center. All right. So that's one way. I also don't like how these columns are so big. We can highlight those, and I can always drag by going on a border between two columns or at the final one, and we can change the width to maybe something like four. That changes all four of them because all four are highlighted. So that's one way we can do that. Let me show you just a shortcut for adding columns. If you want to insert three columns, wherever you want to insert a column to the left of, we're going to highlight three columns. I'm just going to right-click and do Insert. Because I had highlighted three columns, it recognizes that I want to insert three columns. So that's a shortcut there. We can do the same thing over here. So I'm going to insert three columns, and I'll do that for the remaining months real quick. All right. So I just added three columns to each of the months. I do need to just format this by going up here and adding borders. Now, I need to merge and center. So I'm going to select those four cells like I did before, merge and center. Now, after you've done a suddened move I guess in Excel, Excel will remember. So if I highlight those four cells and do Control Y, that means redo. It's just a shortcut that's going to save you some time. It's really not that hard to select merge and center. But since we've already done that, I can do "Control Y, highlight those, Control Y, and I'll do that to the remaining months. Now, I've got this set up, but I wanted to make these a lot smaller, these columns. So I'm going to go ahead and just highlight all of these. Another shortcut for editing the width of cells would be to go up here to Cells and then Format. So I can click on that and I'm just going to change the column width to a nice four. So I click Four, and it does all that. All right. Now if I wanted to, I could adjust the green. So if you wanted to do that, you could. Maybe the surveys alone can take you two weeks, approximately. Some months have more than four weeks, obviously, but this is just a estimate. Prepare building permit that might take you all four, but maybe submitting the building permit is only a week. So we could if you wanted to adjust this so it's more accurate instead of month by month, it's week by week. The last thing I'm going to show you is, we can't really see our entire Gantt chart here, especially if we scroll over. So if I scroll over, I'm not seeing which tasks there are. So if you want, you can always go up here to the View tab, and you can do split. Splitting separates the worksheet into four different quadrants. Sometimes I don't like to do this for the entire four. For this application since we're not spilling down below the bottom of the worksheet, I'm just going to bring this all the way up, and that basically removes it. But the vertical one I can drag over here. Now contrary to before, I can now see way over here in September, I can see what's on the left-hand side because I've split my view up. If you don't like that, you can always drag this back over to the left. So that's just an example of how we can do a lot of the things that you've already learned about in the course and incorporate it into a real-world application.
