Video: Excel Gantt Chart

Excel Gantt Chart

Topics in this Video

• Purpose of a Gantt Chart — 0:00
• Old version — 1:00

  This video was recorded in 2006,
  so all examples use Excel 2003,
  but the tips and training are still valuable.

  Download free trial of latest version.

• Do NOT Insert Rows — 1:30

  Instead, use Shift Down and Copy
  to copy a similar blank row

• Duration (Lead Time) — 2:00
• Effort — 2:20
• Subtotals using Filter — 3:15
• Date formats for Start and End Date — 4:30
• Calculating Start Date, End Date, or Duration — 4:50

  Microsoft removed the ability to highlight cells containing formulas, so instead, you now look for a small green arrow in the upper left corner of a cell that has a formula.

• Default is to calculate the End Date — 5:30
• Formulas for predecessor relationships — 5:50
• Calculate Start Date or Duration — 6:30
• Work Calendar Adjustment Factors — 7:20

  See instructions on the DV sheet of your template
  for how to account for holidays, weekends,
  and other Work Calendar Adjustment factors .

• Milestone date (absolutely fixed) — 8:00
• Bursts, textboxes, and images — 8:30
• Hide and unhide rows and columns — 8:20
• Resize the chart — 8:50
• Print — 9:00
• With or without chart labels — 9:20

  Radio buttons have been replaced with dropdown list .

• Advantages of your Systems2win Gantt Chart — 9:30

Related Topics

• Excel Gantt Chart template
• Project Management templates

Foundational Learning

• Quick Start Initial Training   to use ANY Systems2win template
• Training & Support  home page
• Video Tips