From the course: The Top 10 Project Management Mistakes—and How to Avoid Them
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Gantt chart in Excel, part 3
From the course: The Top 10 Project Management Mistakes—and How to Avoid Them
Gantt chart in Excel, part 3
- So what I'm going to do is I'm just going to put a one in each box just to make it color it in so identifying the suitable countries is four weeks so I'm just going to put a one in the first four boxes like that then finding a site is also four weeks so I'm just following along the critical path. I'm ignoring all the other tasks for the moment. Buying a site is 10 weeks so that's 10 there, I'm up to 18 which is right. Next is modify the buildings, that's another eight. This does form an opportunity to double check your estimates as well so when you're filling these in you sometime think, actually does that look right? But I'm assuming they're right for the sake of this. Then we install the forms and fittings which is two more weeks and then we open. Now opening is an event. It has no duration so on a Gantt chart you just put a vertical line and the best way to do that is to select the whole column and just use the borders, just do a left border like that so that's the end there so…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Why do these mistakes happen?5m 41s
-
(Locked)
Congratulations1m 14s
-
(Locked)
Gantt chart in Excel, part 153s
-
(Locked)
Gantt chart in Excel, part 25m 5s
-
(Locked)
Gantt chart in Excel, part 35m 6s
-
(Locked)
Gantt chart in Excel, part 43m 13s
-
(Locked)
Gantt chart in Excel, part 55m 42s
-
(Locked)
Gantt chart in Excel, part 65m 17s
-
(Locked)