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

Gantt chart in Excel, part 6

From the course: The Top 10 Project Management Mistakes—and How to Avoid Them

Start my 1-month free trial

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.…

Contents