From the course: The Top 10 Project Management Mistakes—and How to Avoid Them
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Gantt chart in Excel, part 6
From the course: The Top 10 Project Management Mistakes—and How to Avoid Them
Gantt chart in Excel, part 6
- Now, the next thing I want to show you on this is, what if there's say a shutdown or a holiday, what if the first week of August we don't do anything? Well it's really easy to do that, all you do is just insert a column. So the best way actually I find you can't find anything on these ribbon menus, is just to right click and go insert. And then maybe color that column in to show that you're not going to be working at that time. So go back to home and just select that. So that's my week on the beach there, summer holiday shutdown or whatever, and similarly for Christmas or whatever, you might well want to put a week or two of nothing happening on your project. Now the only other thing is, I just need to repair the dates 'cause you can see I've inserted a column and I've got no week here. So all I do is I just select those two and pull that across, and instead of finishing on the 19th of August, it's now going to be the 26th of August, and you can see, instead of 28 weeks it's now 29.…
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.