Excel Gantt Chartwith optional pricing for unlimited users The Gantt Chart is a powerful Project Plan template used by a Project Manager to plan and manage a project. The Gantt Chart template illustrates your project with an easy-to-understand graphic timeline bar chart. |
on order page |
 |
Like every other Systems2win template, the Gantt Chart Excel template comes with a sample project plan containing extensive online help and training - so that your Project Manager can devote her valuable time to actually planning and managing the project.
And like every other Systems2win template, you get pop-up help when you simply click any row or column heading on your Excel Gantt Chart Project Plan xls.
Gantt Chart
Training
& Demo Videos
-
Gantt Chart training videos
- Gantt Chart video (10 mins)
- What's new in Gantt v5&6 (4 min video)
- Additional training relevant to this template
The Sample and Help worksheets of every template also contain training relevant to THAT template-
Excel Editing
- Power user tips to delete, hide, insert, copy, and move data (9 min
video)
Tip: Do NOT use Insert > Rows - Introduction to Systems2win templates (5 min video)
- How to find Help & Training for any Systems2win template
- How to use the Training Matrix to validate learning
- Training & Demos home page
-
Excel Editing
- Power user tips to delete, hide, insert, copy, and move data (9 min
video)
Use Excel's powerful filtering features to analyze usage of time and money for any given resource or combination of project resources (using filters such as equal to, greater than, begins with, does not end with, contains, does not contain, AND, OR, etc.)
Notice that resource usage analysis in this project planning template is in some ways more powerful than most Project Management software, because you can analyze both Effort (in hours) and Duration (in days).
And the Systems2win Excel project plan now features Work Calendar Adjustment
factors -
to easily consider holidays and weekends in your project
plans.
New features in versions 5 & 6Drop-down data validation for People, Resources, Work Calendar Adjustment Factors, and Grid Lines. Header rows repeat at the top of each printed page. Chart axis labels at both top & bottom. And chart line shows Today's date. One-click button to Set Project Start Date and change grid lines. Many new ease of use features, including easier handling of long comments, easier numbering for Work Breakdown Structure numbers, more & better help... New Systems2win menu appears when you open Excel. Code separated from data. Most code has been
separated into add-ins (rather than embedded in
each workbook). Benefits: Easily
sync templates in each local PC with
master templates in your S2winPortal. Benefits: Even better compatibility with more versions
of Windows and Excel.
What's new in Excel Gantt v5&6 (4 min video) See even more in What's New |
|
Gantt chart software comparison
of
Systems2win Project Plan template to other Gantt Chart Software
| Comparison | Systems2win | Other |
|---|---|---|
| Written in | Excel | Unfamiliar language |
| Cost per seat |
first seat $399 with steep discounts for multiple users |
$499 per seat |
| Upgrades | As compared with traditional software, the Systems2win Excel Gantt Chart is remarkably cost effective when evaluated from the perspective of lifetime ownership | |
| Ability to share with non-licensed users | Printed paper or PDF | Printed paper or PDF |
| Auto-draws Gantt Chart | Yes | Yes |
| Line shows "Today" | Yes | Yes |
| Analyze filtered data |
Yes Superior to MS Project, because you can analyze both Effort (in hours) and Duration (in days) filtered by people, resources, costs, % complete... |
Yes Task Usage |
| Unlimited comments per line | Yes | Yes |
| Unlimited hyperlinks per line | Yes | Yes |
| Graphic hyperlinks - easy to see, to understand, and to use |
Yes using Link Icons |
Either No or not near as nice |
| Drop-down list of user-defined codes for unlimited people and resources | Yes | Yes |
| Color-coded phases, tasks, milestones, resources, etc. | Yes | Yes |
| Percent complete displayed in Gantt bar colors | Yes | Yes |
| Calculate start date, end date, or duration for any line item | Yes | Yes |
|
Define simple or complex predecessor
relationships (e.g. this task starts 5 days after another ends) |
Yes with all the power of Excel's formulas and even ability to link to outside data sources |
Yes with limited math |
| Multi-layered levels of details |
Yes Easily hide & unhide rows. All the calculation power of Excel to create Phase and Milestone summaries. |
Yes Collapsible outline auto-summarizes lower-level tasks |
| Easily hide excessive details |
Yes hide columns & rows |
Yes hide columns & collapsible outline |
| Calculate costs |
Yes Columns and math for quantity x cost per line item, plus all the power of Excel to define your own math functions |
Yes |
| Practically unlimited size |
Yes Excel supports 16,000 rows, and Gantt Chart can expand to any size |
Yes |
| Adjust schedule for your calendar of working days and holidays |
Yes Using Work Calendar Adjustment factors |
Yes |
| Most difficult learning curve |
1) You can't just Insert Rows. You need to copy a blank row - so that your new row has all the same formulas and formatting hidden beneath all the other (apparently) blank rows.
2) If you are using Excel 2007, Everything else is "just Excel". Everything your people know about Excel they can apply here; everything they learn here, they can apply to anything else they do with Excel |
New users must learn an entirely new application |
| Extensive online training | Yes (both text and video online training) | Yes |
|
Reasons you might want to
step up to more expensive Project Management
Software |
||
| Comparison | Systems2win | Other |
| Define grid lines |
Yes, but only using whole numbers.
E.g. 7 days = a week. 30 days is close to a month. |
Yes. Advanced time-based gridline capabilities |
| Header rows repeat at top of each printed page |
Yes but only for columns - not chart Chart has axis labels at top and bottom |
Yes |
| Auto-numbering of complex Work Breakdown Structure numbers |
No Just use Edit > Fill Series for (automatic) simple numbering, or manually enter complex numbers |
Yes Auto-number options include outline format (e.g. 1.1, then 1.1.1) |
| Select multiple colors for Gantt chart bars |
All Gantt chart bars will be the
same two colors for complete vs. incomplete. You can, however define those 2 colors. |
Yes |
| Display predecessor relationships on the chart | No | Yes |
| Critical path analysis | No | Yes |
| Calendar view | No | Yes |
| Earned Value Management | No | Yes |
| Manage resources across multiple projects |
No Theoretically, you could use Excel formulas to do this, but if you are managing more than a couple projects that need to share resources, you should probably step up to high-end Project Management software |
Yes |
Project Management template software that every team leader can use and every team member can share
Even if your company already owns a few expensive seats of a proprietary project management software application, (like Microsoft Project, or Primavera), wouldn't it be nice to have a Gantt chart that everyone else can use?
- That's simpler to use?
- That's inexpensive - so everyone on your team CAN use it?
- With instantly available and free online training?
- With no evenings away from home and family trying to
learn an unfamiliar tool
that you begin to suspect is far more complex than needed for "our little project"?
 |
This Excel Gantt Chart template comes bundled with all of the other Kaizen & Project Management tools and has optional
pricing for unlimited users |
|
|
on order page |
After viewing our
Gantt Chart training
videos, |
|
Gantt Chart Excel - now that's a good idea!