Last week, we had a giveaway for Excel Dashboards and Reports, by Mike Alexander and John Walkenbach, and here are the winners:
- Jake, with comment 33
- Jason M, with comment 13
Congratulations, and Katie Mohr, from Wiley, will email you later today, to arrange sending your copy of the file.
Excel Gantt Chart Template
This week, Jon Wittwer, from Vertex42, has donated 4 copies his Gantt Chart Template Pro, for project tracking. The file is available in xls and xlsx versions, and uses formulas and conditional formatting to create the charts.
To use the template:
- Enter your task information, and view the results by day, week or month.
- Show weekends, or hide them
- Scroll through the project date range, to focus on a specific time period
- In the xlsx version you can even change the bar colours, by typing a code in a worksheet cell
It impressive what can be done in Excel, without any programming! You’ll see some useful techniques in this file that you can apply in your other workbooks too.
The Gantt Chart Template package includes 7 bonus files, with sample projects. These will give you inspiration for setting up your own project, instead of starting from scratch. Here is a screen shot from one of the samples – Custom Software Schedule.
Gantt Chart Instructions
The Gantt chart template is easy to use, and there is a Help sheet in the workbook, to show you how to get started. That sheet has:
- a link to the video tutorials, where you can see all the steps for setting up your file. I watched the videos, and they clearly explain what to do.
- written instructions for entering your task information, linking the tasks, and entering different types of input.
- answers to frequently asked questions about the template
Gantt Chart Licence
The Gantt Chart Template Pro has a generous licence, that lets you privately share your edited template within your company or organization. So, instead of software that requires a separate licence for each user, you and your co-workers can collaborate on the same template. There is a link to the licence in the workbook, where you can read the details.
Enter the Giveaway
Jon Wittwer, from Vertex42, has donated 4 copies of the Gantt chart file for this giveaway. If you’d like a chance to win a copy, please read the rules, and then make a comment below.
- In your comment, tell us
- why you would like to track your projects in Excel, instead of a different program
- and/or what type of projects you would track with this Gantt chart template
- Include your email address, so I can contact you if you win. Your contact information won’t be publicly visible, and it won’t be used for any other mailings.
- The deadline is Wednesday, September 4th, 2013, at 12 noon Eastern Daylight Time.
- One entry per person.
- The 2 winners will be announced on Thursday, September 5th, 2013.
- Each winner will have 24 hours to claim the prize, and if not claimed, another name will be selected.