1 00:00:00,05 --> 00:00:01,07 - [Instructor] So this is a Gantt chart 2 00:00:01,07 --> 00:00:02,07 that I've built in Excel. 3 00:00:02,07 --> 00:00:06,00 Notice that we have a bar chart here 4 00:00:06,00 --> 00:00:08,02 that effectively shows us the duration 5 00:00:08,02 --> 00:00:09,09 of a project when it starts and ends, 6 00:00:09,09 --> 00:00:11,04 as well as a visualization at the bottom, 7 00:00:11,04 --> 00:00:13,05 which shows us the highest concentrations 8 00:00:13,05 --> 00:00:15,06 of projects at a single point. 9 00:00:15,06 --> 00:00:17,00 Now, this may look like a lot of work, 10 00:00:17,00 --> 00:00:19,07 but don't worry, I'm going to show you exactly how to do it. 11 00:00:19,07 --> 00:00:21,08 If you want to familiarize yourself with the data, 12 00:00:21,08 --> 00:00:24,01 you can go ahead and click Start and see the data over here. 13 00:00:24,01 --> 00:00:25,04 So now what I'm going to have you do 14 00:00:25,04 --> 00:00:27,05 is just create a new sheet. 15 00:00:27,05 --> 00:00:30,06 You can call this Gantt if you'd like 16 00:00:30,06 --> 00:00:34,08 and make sure that you spell Gantt correctly. 17 00:00:34,08 --> 00:00:36,00 So I'm going to zoom out here 18 00:00:36,00 --> 00:00:38,01 to give myself a little bit more space. 19 00:00:38,01 --> 00:00:41,05 In cell B2, I'm going to type in Start Year. 20 00:00:41,05 --> 00:00:45,02 In cell B3, I'm going to type in End Year. 21 00:00:45,02 --> 00:00:48,02 Okay, so in cell C2, we want to grab the Starting Year 22 00:00:48,02 --> 00:00:49,02 for all of our projects. 23 00:00:49,02 --> 00:00:53,09 So I'm going to type in Year and then I'm going to type in Min 24 00:00:53,09 --> 00:00:57,00 and I'm going to highlight from on this Start over here, 25 00:00:57,00 --> 00:00:58,05 on the Start worksheet tab, 26 00:00:58,05 --> 00:00:59,07 I'm going to highlight this entire thing. 27 00:00:59,07 --> 00:01:02,04 So ProjectData, Start Date, close parentheses, 28 00:01:02,04 --> 00:01:04,02 close parentheses, hit Enter. 29 00:01:04,02 --> 00:01:05,05 That's 2022. 30 00:01:05,05 --> 00:01:07,01 We're going to do the same over here. 31 00:01:07,01 --> 00:01:12,00 We'll do Year Max and then go back to Start. 32 00:01:12,00 --> 00:01:14,05 And then we're going to do the End Dates over here 33 00:01:14,05 --> 00:01:17,00 like this, close, close, Enter. 34 00:01:17,00 --> 00:01:20,02 Okay, so we got our Starting Year and our Ending Year. 35 00:01:20,02 --> 00:01:23,09 Now, in cell D5, 36 00:01:23,09 --> 00:01:27,04 I'm going to type in a 1 here and then I'll type in a 2. 37 00:01:27,04 --> 00:01:30,08 And this is just to kind of help me understand 38 00:01:30,08 --> 00:01:32,04 how far we want to take this thing. 39 00:01:32,04 --> 00:01:34,02 So I have 36 periods in all. 40 00:01:34,02 --> 00:01:36,06 So I'm just going to take a look at 12 right here. 41 00:01:36,06 --> 00:01:38,04 And I'm just going to use that as a guide. 42 00:01:38,04 --> 00:01:40,07 Above here, I am going to use merge and center. 43 00:01:40,07 --> 00:01:42,01 Please do not attack me. 44 00:01:42,01 --> 00:01:43,02 I don't think it's that bad. 45 00:01:43,02 --> 00:01:44,07 All right, so I did merge and center here. 46 00:01:44,07 --> 00:01:46,02 D4 through D0 47 00:01:46,02 --> 00:01:49,06 I'm going to do an = and I'm going to do 2022 here. 48 00:01:49,06 --> 00:01:51,08 And that's just going to give us our year header. 49 00:01:51,08 --> 00:01:53,02 I'm going to highlight all of these 50 00:01:53,02 --> 00:01:56,01 and let's just bring 'em in a little closer, 51 00:01:56,01 --> 00:01:59,02 just a little bit closer, like that. 52 00:01:59,02 --> 00:02:01,08 Okay, so we have our year header here. 53 00:02:01,08 --> 00:02:04,01 The way I like to do this, I keep it simple. 54 00:02:04,01 --> 00:02:07,04 I'll do a Control + C, I'll do Control + V right here, 55 00:02:07,04 --> 00:02:10,00 and then I'm going to do a Control + V on that one over there. 56 00:02:10,00 --> 00:02:11,01 And all we have to do here 57 00:02:11,01 --> 00:02:14,00 is actually in this box, I'm going to say =. 58 00:02:14,00 --> 00:02:17,06 And then I'll select the 2022 and do a plus one. 59 00:02:17,06 --> 00:02:20,01 And the reason I'm doing this is, if you want to add more, 60 00:02:20,01 --> 00:02:21,06 this is going to make your life a lot easier. 61 00:02:21,06 --> 00:02:23,03 We like to keep things very formulaic 62 00:02:23,03 --> 00:02:26,03 so that all we have to do is just make a few updates 63 00:02:26,03 --> 00:02:27,08 to get to where we want. 64 00:02:27,08 --> 00:02:29,06 Okay, so now I want to add the next year in. 65 00:02:29,06 --> 00:02:32,04 I'm going to click on this big box over here. 66 00:02:32,04 --> 00:02:34,03 Click 2023 and do a plus one. 67 00:02:34,03 --> 00:02:36,03 Of course, you could have just dragged it over. 68 00:02:36,03 --> 00:02:37,09 That would've been the smarter move. 69 00:02:37,09 --> 00:02:39,09 But you know, all of this is just to make your life 70 00:02:39,09 --> 00:02:41,04 a little bit easier. 71 00:02:41,04 --> 00:02:47,00 Okay, so I'm going to highlight this whole thing here. 72 00:02:47,00 --> 00:02:48,08 Let me do that again. 73 00:02:48,08 --> 00:02:52,05 I'll just try to make everything kind of the same size. 74 00:02:52,05 --> 00:02:55,09 Bring it in a little tighter so we can actually visualize. 75 00:02:55,09 --> 00:02:58,05 All right, so you could either take this 76 00:02:58,05 --> 00:03:02,07 and just drive it all the way through to get to 36 points. 77 00:03:02,07 --> 00:03:04,04 That's one way to do it. 78 00:03:04,04 --> 00:03:06,00 The way I have done it, 79 00:03:06,00 --> 00:03:09,02 because I would like 80 00:03:09,02 --> 00:03:11,04 to make things a little bit formulaic, 81 00:03:11,04 --> 00:03:12,09 is I use the SEQUENCE function. 82 00:03:12,09 --> 00:03:14,07 So I'm going to type in SEQUENCE here. 83 00:03:14,07 --> 00:03:16,08 We're going to SEQUENCE 1 row, 84 00:03:16,08 --> 00:03:20,04 and I'll do an open parentheses for the calculation here. 85 00:03:20,04 --> 00:03:22,01 So what we're going to do is we're going to take this one here, 86 00:03:22,01 --> 00:03:24,01 that's our End Year, 87 00:03:24,01 --> 00:03:29,04 less our Start Year plus one, 88 00:03:29,04 --> 00:03:32,02 and then multiplied by 12. 89 00:03:32,02 --> 00:03:34,06 So that automatically populates 36. 90 00:03:34,06 --> 00:03:36,00 Again, what I like about this, 91 00:03:36,00 --> 00:03:37,05 let's say we wanted to expand it, 92 00:03:37,05 --> 00:03:38,03 we could expand it. 93 00:03:38,03 --> 00:03:40,01 I mean, you would have to kind of do the same thing here, 94 00:03:40,01 --> 00:03:43,00 but I think you got that. 95 00:03:43,00 --> 00:03:44,02 Okay, so the next thing we want to do 96 00:03:44,02 --> 00:03:45,03 is bring in the months below this 97 00:03:45,03 --> 00:03:47,07 so we understand the months that we're looking at. 98 00:03:47,07 --> 00:03:50,03 So I'm going to do a Date function here. 99 00:03:50,03 --> 00:03:52,08 So I'll do Date, I'm going to select C2. 100 00:03:52,08 --> 00:03:54,09 We will hit F4 to lock it in. 101 00:03:54,09 --> 00:03:56,00 What month are we interested in? 102 00:03:56,00 --> 00:03:58,01 Well, we're going to be interested in the month 103 00:03:58,01 --> 00:04:01,09 that is given by this number right here. 104 00:04:01,09 --> 00:04:04,05 And then we'll just do the day here. 105 00:04:04,05 --> 00:04:06,05 Now, what's fun about this, right, 106 00:04:06,05 --> 00:04:08,04 is that it doesn't matter if we put in 107 00:04:08,04 --> 00:04:10,03 the 13th month here, it's still going to work. 108 00:04:10,03 --> 00:04:11,05 So I'll show that to you. 109 00:04:11,05 --> 00:04:14,01 I'm going to take this and drag it all the way over here. 110 00:04:14,01 --> 00:04:15,05 I'll make just this one bigger 111 00:04:15,05 --> 00:04:17,07 just so we can see that it looks good. 112 00:04:17,07 --> 00:04:19,01 Okay, that looks good. 113 00:04:19,01 --> 00:04:21,05 Let me just show you this on the 13. 114 00:04:21,05 --> 00:04:23,03 You can see that it actually just grows by a year, 115 00:04:23,03 --> 00:04:24,02 which is really cool. 116 00:04:24,02 --> 00:04:25,08 It makes our life really easy. 117 00:04:25,08 --> 00:04:29,00 So I'm not going to like these hash marks here. 118 00:04:29,00 --> 00:04:31,08 What I want to do is I'm going to do this pop-out here, 119 00:04:31,08 --> 00:04:33,01 and then I'm going to go to Custom. 120 00:04:33,01 --> 00:04:34,03 I only want it to show the month, 121 00:04:34,03 --> 00:04:35,07 even though I'm treating it as a date. 122 00:04:35,07 --> 00:04:37,05 So I'll just do MMM, 123 00:04:37,05 --> 00:04:41,06 that's going to give me the three-digit month. 124 00:04:41,06 --> 00:04:45,05 And then, I'll just make it kind of smaller like that. 125 00:04:45,05 --> 00:04:46,04 Don't worry. 126 00:04:46,04 --> 00:04:48,03 We're going to work on formatting everything 127 00:04:48,03 --> 00:04:49,01 at the end of this. 128 00:04:49,01 --> 00:04:54,00 So here, I'll do a Project Name, 129 00:04:54,00 --> 00:04:55,06 Do Control + B here, 130 00:04:55,06 --> 00:04:59,04 make it bold and let's do our projects. 131 00:04:59,04 --> 00:05:03,03 So in this case, I am going to go to the start over here 132 00:05:03,03 --> 00:05:05,04 and I think I just pull in the whole thing, right? 133 00:05:05,04 --> 00:05:06,09 You just pull this whole thing in like that. 134 00:05:06,09 --> 00:05:08,02 Boom, all right? 135 00:05:08,02 --> 00:05:10,09 That comes in. 136 00:05:10,09 --> 00:05:13,05 I'll just double click that, make that a little bit bigger. 137 00:05:13,05 --> 00:05:16,00 All right, so before I populate my Gantt chart, 138 00:05:16,00 --> 00:05:17,05 what I want to do is I want to bring in the Start Date 139 00:05:17,05 --> 00:05:20,04 and End Date over here, not just for the user, 140 00:05:20,04 --> 00:05:22,06 but it's going to make my life easier. 141 00:05:22,06 --> 00:05:25,07 So we'll do Start Date, End Date, like that, 142 00:05:25,07 --> 00:05:29,06 Control + B, make it bold. 143 00:05:29,06 --> 00:05:32,06 And what I'm going to do is I'm going to actually look up 144 00:05:32,06 --> 00:05:35,05 the Start Date and the End Dates from this project name. 145 00:05:35,05 --> 00:05:37,03 So I'll do XLOOKUP. 146 00:05:37,03 --> 00:05:39,08 We're going to search for this value right here, 147 00:05:39,08 --> 00:05:41,02 comma, what's our lookup array? 148 00:05:41,02 --> 00:05:43,01 It's going to be back on our table 149 00:05:43,01 --> 00:05:45,01 over here under project name. 150 00:05:45,01 --> 00:05:47,07 I just selected the top, Control + Shift + Down. 151 00:05:47,07 --> 00:05:49,00 Note how beautiful that is. 152 00:05:49,00 --> 00:05:51,00 It just brings in both of them. 153 00:05:51,00 --> 00:05:53,02 And then what we want to do is return 154 00:05:53,02 --> 00:05:54,04 the Start Date and the End Date. 155 00:05:54,04 --> 00:05:55,05 So you can just take this whole thing 156 00:05:55,05 --> 00:05:57,05 and highlight it here like that, 157 00:05:57,05 --> 00:06:00,04 close the parentheses, and I'm going to take this 158 00:06:00,04 --> 00:06:06,02 and drag it all the way down. 159 00:06:06,02 --> 00:06:09,00 And if you get that N/A, it's 'cause you dragged it too far. 160 00:06:09,00 --> 00:06:11,06 Okay, so with these set up, 161 00:06:11,06 --> 00:06:14,09 let's change the dates to do a short date. 162 00:06:14,09 --> 00:06:18,05 Make our life a little bit easier. 163 00:06:18,05 --> 00:06:19,09 Okay, so next things 164 00:06:19,09 --> 00:06:25,00 we want to do here are actually populate this entire thing. 165 00:06:25,00 --> 00:06:26,08 So you may be wondering how does it work? 166 00:06:26,08 --> 00:06:29,02 Well, we're going to actually just use conditional formatting. 167 00:06:29,02 --> 00:06:31,02 So if it's a one, 168 00:06:31,02 --> 00:06:34,05 we want it to actually show a color in that cell. 169 00:06:34,05 --> 00:06:37,00 If it's a zero, we don't want it to do that. 170 00:06:37,00 --> 00:06:38,08 So I'm going to use a really interesting formula 171 00:06:38,08 --> 00:06:41,01 called the IFS formula to do that. 172 00:06:41,01 --> 00:06:42,00 And that's going to keep us 173 00:06:42,00 --> 00:06:44,03 from having to use nested IFs all the time 174 00:06:44,03 --> 00:06:46,00 and I find it a lot easier to use. 175 00:06:46,00 --> 00:06:47,07 So I'm going to type in IFS here. 176 00:06:47,07 --> 00:06:49,01 That's the IFS formula. 177 00:06:49,01 --> 00:06:51,09 And the way it works is it tests if something is true 178 00:06:51,09 --> 00:06:53,03 and if it is true, it does that thing. 179 00:06:53,03 --> 00:06:56,03 If not, it just tests for another thing being true. 180 00:06:56,03 --> 00:06:57,05 And if it that's true, 181 00:06:57,05 --> 00:06:59,08 it does that thing and it just continues to go 182 00:06:59,08 --> 00:07:02,07 until it runs out of things to test. 183 00:07:02,07 --> 00:07:04,08 So let's go ahead and do this. 184 00:07:04,08 --> 00:07:06,05 So I'm going to type in IFS, 185 00:07:06,05 --> 00:07:08,06 and then, on your keyboard, you can hit Alt + Enter. 186 00:07:08,06 --> 00:07:12,09 Go to the next line, one, two, three, four to indent. 187 00:07:12,09 --> 00:07:17,04 Now, what we want to do is test is this date right here 188 00:07:17,04 --> 00:07:19,05 in between Start Date and End Date, 189 00:07:19,05 --> 00:07:21,01 'cause that's going to tell us 190 00:07:21,01 --> 00:07:22,08 that we actually want to put a one there. 191 00:07:22,08 --> 00:07:25,06 So I'm going to type in AND here. 192 00:07:25,06 --> 00:07:26,07 And what we're going to test is 193 00:07:26,07 --> 00:07:30,08 if this cell right here 194 00:07:30,08 --> 00:07:35,03 is greater than this cell and less than this cell. 195 00:07:35,03 --> 00:07:38,04 So since we're going to be dragging this across, 196 00:07:38,04 --> 00:07:41,05 but we want it to stay in its current row, 197 00:07:41,05 --> 00:07:45,00 we will lock in the six, but we're going to leave that D free, 198 00:07:45,00 --> 00:07:47,09 and then we're going to do >= 199 00:07:47,09 --> 00:07:51,00 and I'm going to select cell A07 here. 200 00:07:51,00 --> 00:07:55,01 And then in this case, since we want it to go down, 201 00:07:55,01 --> 00:07:56,06 but we want to lock in the column, 202 00:07:56,06 --> 00:08:01,03 we're going to keep that A0 locked and that seven free. 203 00:08:01,03 --> 00:08:02,09 We're going to do the same thing here. 204 00:08:02,09 --> 00:08:06,03 Is this less than or equal to this one here? 205 00:08:06,03 --> 00:08:10,05 And we'll structure it the same way. 206 00:08:10,05 --> 00:08:15,03 So if it is, we want it to return a one, Alt + Enter. 207 00:08:15,03 --> 00:08:17,05 If not, we want it to return a zero. 208 00:08:17,05 --> 00:08:19,09 Now, again, you could put this in all one IF formula, 209 00:08:19,09 --> 00:08:23,01 but what I like to do is to separate 210 00:08:23,01 --> 00:08:25,05 these out so I can think about it correctly. 211 00:08:25,05 --> 00:08:26,08 So if you needed, 212 00:08:26,08 --> 00:08:28,04 you could actually put more conditions in here, 213 00:08:28,04 --> 00:08:30,06 but in this case, we don't need to. 214 00:08:30,06 --> 00:08:32,01 But what I like to do is, 215 00:08:32,01 --> 00:08:33,08 since we want it to return a zero 216 00:08:33,08 --> 00:08:35,07 if it doesn't satisfy this first condition, 217 00:08:35,07 --> 00:08:38,04 but we need to have this logical test return it TRUE 218 00:08:38,04 --> 00:08:40,02 I'm just going to type in a TRUE here, 219 00:08:40,02 --> 00:08:41,09 and this may be a little confusing, 220 00:08:41,09 --> 00:08:44,04 but if you think about it, this will always work 221 00:08:44,04 --> 00:08:47,01 that if this doesn't hit this condition 222 00:08:47,01 --> 00:08:49,01 and you put a TRUE here, we'll always hit that condition. 223 00:08:49,01 --> 00:08:51,05 So what you can do is you can stack all these IFs up 224 00:08:51,05 --> 00:08:54,08 and then for your last else, if nothing else is true, 225 00:08:54,08 --> 00:08:57,00 you just put a TRUE in there and it's going to do that thing. 226 00:08:57,00 --> 00:08:59,03 And I like doing that 'cause I think it just makes it 227 00:08:59,03 --> 00:09:01,03 a lot easier to read and understand. 228 00:09:01,03 --> 00:09:02,09 So I'm going to hit Enter here. 229 00:09:02,09 --> 00:09:03,08 You can see that's a zero. 230 00:09:03,08 --> 00:09:05,05 So let's take this all the way out here, 231 00:09:05,05 --> 00:09:06,05 see if it works. 232 00:09:06,05 --> 00:09:08,01 Okay, I like how it's looking. 233 00:09:08,01 --> 00:09:09,09 So double click that the way down. 234 00:09:09,09 --> 00:09:11,08 Okay, so we're getting somewhere. 235 00:09:11,08 --> 00:09:12,07 So next thing I want to do 236 00:09:12,07 --> 00:09:15,02 is I'm going to go to Conditional Formatting here 237 00:09:15,02 --> 00:09:19,03 and I'm going to apply a new rule. 238 00:09:19,03 --> 00:09:23,03 So I'm going to click on Format only cells that contain, 239 00:09:23,03 --> 00:09:27,00 and the cell value should be equal to a one. 240 00:09:27,00 --> 00:09:31,02 That, we'll go to format and we'll do a border. 241 00:09:31,02 --> 00:09:32,05 I like to do a solid border. 242 00:09:32,05 --> 00:09:35,01 I'll do this blue fill like that. 243 00:09:35,01 --> 00:09:38,04 Hit OK, hit OK. 244 00:09:38,04 --> 00:09:40,06 All right, so now we're getting somewhere. 245 00:09:40,06 --> 00:09:42,05 Now, the thing is, maybe we don't want to see 246 00:09:42,05 --> 00:09:43,08 all these ones and zeros. 247 00:09:43,08 --> 00:09:45,07 So with all of this highlighted, 248 00:09:45,07 --> 00:09:47,00 you're going to go on the Home tab, 249 00:09:47,00 --> 00:09:49,03 pop out that number, hit Custom, 250 00:09:49,03 --> 00:09:51,06 and then you can get rid of the numbers here 251 00:09:51,06 --> 00:09:55,03 just by typing one semicolon like that. 252 00:09:55,03 --> 00:09:58,07 All right, I like where we're going, I like how this looks. 253 00:09:58,07 --> 00:09:59,08 All right, so how do we build 254 00:09:59,08 --> 00:10:02,03 that last part on the bottom here? 255 00:10:02,03 --> 00:10:04,04 What I'm going to do is I'm going to do an = 256 00:10:04,04 --> 00:10:06,00 and I'll do SUM. 257 00:10:06,00 --> 00:10:07,08 So note that even though these are zeros 258 00:10:07,08 --> 00:10:09,04 and ones that have been hidden, 259 00:10:09,04 --> 00:10:12,02 there's still zeros and ones behind the scenes. 260 00:10:12,02 --> 00:10:14,07 So we're going to make that a SUM. 261 00:10:14,07 --> 00:10:17,02 And you can see that here it's showing the Custom format. 262 00:10:17,02 --> 00:10:19,02 So I'm going to switch that back to General 263 00:10:19,02 --> 00:10:20,09 just so I can see it, 264 00:10:20,09 --> 00:10:25,07 but we're going to turn that back to Custom in a second. 265 00:10:25,07 --> 00:10:26,07 So now, that we've added that, 266 00:10:26,07 --> 00:10:28,06 we'll apply a new conditional formatting. 267 00:10:28,06 --> 00:10:30,04 I'm going to click New rule here. 268 00:10:30,04 --> 00:10:33,00 And I like this Format all cells based on their value. 269 00:10:33,00 --> 00:10:34,09 So it gives us this two-color scale. 270 00:10:34,09 --> 00:10:36,05 The problem is the lowest value gives us 271 00:10:36,05 --> 00:10:38,05 the most intense color and the highest value 272 00:10:38,05 --> 00:10:39,08 gives us the least intense color. 273 00:10:39,08 --> 00:10:41,07 So we want to switch that up. 274 00:10:41,07 --> 00:10:44,07 I'm going to make this the least intense color, 275 00:10:44,07 --> 00:10:46,08 and then I'm going to use that same column for reference 276 00:10:46,08 --> 00:10:48,04 and make this the most intense color. 277 00:10:48,04 --> 00:10:50,03 So I'll go ahead and hit Enter on that. 278 00:10:50,03 --> 00:10:52,09 And then in this case, you can pop this back out, 279 00:10:52,09 --> 00:10:56,02 go to Custom, drop in that semicolon, 280 00:10:56,02 --> 00:10:59,08 and you can see that it has now disappeared, 281 00:10:59,08 --> 00:11:01,06 or at least the numbers have now disappeared. 282 00:11:01,06 --> 00:11:02,08 All right, so let's talk about 283 00:11:02,08 --> 00:11:04,08 how to make this a little bit better 284 00:11:04,08 --> 00:11:07,02 for presentation purposes. 285 00:11:07,02 --> 00:11:11,02 I am going to make these all black like that, 286 00:11:11,02 --> 00:11:14,00 and I'm going to highlight this entire thing like this 287 00:11:14,00 --> 00:11:18,04 and just do a outside border. 288 00:11:18,04 --> 00:11:22,01 And I like to just separate these as well. 289 00:11:22,01 --> 00:11:23,05 So let's see. 290 00:11:23,05 --> 00:11:30,08 I'll make that a border just to carve off our years. 291 00:11:30,08 --> 00:11:32,09 And this one actually shouldn't have anything in it, 292 00:11:32,09 --> 00:11:36,02 so I'm going to hit Delete on that. 293 00:11:36,02 --> 00:11:37,02 I'm going to right click. 294 00:11:37,02 --> 00:11:38,06 Just a quick way to delete it, okay. 295 00:11:38,06 --> 00:11:40,05 And then I do want to make sure 296 00:11:40,05 --> 00:11:43,08 that that has a nice right border. 297 00:11:43,08 --> 00:11:47,01 And then I'm going to go to View and turn off grid lines. 298 00:11:47,01 --> 00:11:49,00 All right, so one last thing you might consider 299 00:11:49,00 --> 00:11:53,01 doing here is going to Start and let's sort it, right? 300 00:11:53,01 --> 00:11:54,08 Maybe we should sort it by the Start Date. 301 00:11:54,08 --> 00:11:57,04 So let's do oldest and newest, like that, 302 00:11:57,04 --> 00:11:59,05 and that way, it looks sorted on here. 303 00:11:59,05 --> 00:12:02,04 All right, so that was quite a bit of work, 304 00:12:02,04 --> 00:12:05,02 but now that you know how to create a Gantt chart in Excel, 305 00:12:05,02 --> 00:12:08,01 you can actually build one rather quickly. 306 00:12:08,01 --> 00:12:09,09 And the way that we've built it formulaically 307 00:12:09,09 --> 00:12:12,00 will allow you to add on things to it 308 00:12:12,00 --> 00:12:14,01 so that you can keep growing to reflect 309 00:12:14,01 --> 00:12:17,00 the changing nature of your projects.