Recent Blog Posts

July 26, 2015

Project Timeline Template Excel Download

Project Timeline

Very often, a project manager needs to quickly create a view. This exercise happens before the project manager starts the actual project plan, far more detailed. 

Single Project Timeline Template Excel 

Download This Template Now!
single project timeline template excel
Single Project 
  • The Template can be used to list tasks for a single project. 
  • Each task has a name, start end, and effort.
  • The start date uses the end date of the previous task. If you want a different start date, then just type the date into the cell. 
  • The end date is calculated using the start and effort. Only weekdays are counted.
  • You can change the start date on the timeline and scale on the timeline in the config sheet.
  • Depending on the duration of your project, set the scale of the timeline. If your project is few weeks, then set the scale to 1 day. If it is log, then set it to 7 days or more.
  • Note that the bigger the scale lesser the accuracy of the start and end dates.

Multi Projects Timeline Template

Project Timeline Template Excel, multiple project timeline template excel
Multi Project
  • This template should be used for high-level planning for multiple projects.
  • Has all the features of one timeline, including the scale.
  • Displays up to five projects with—different colors.
  • Each Project can have a max of five tasks, so always list only the high-level tasks.

Manual Project Timeline Template 

Manual Timeline Excel, manual timeline template excel
  • A simple way to display project overview.
  • Manually created by formatting cells and using simple sum formula.
  • It is very flexible and easy to create as you can add as many rows to depict different phases or tasks.
Download This Template Now!

3 comments

  1. Hi Swapnil,
    This is exactly what I was looking for! Thank you. I'm wondering if I can configure the dates to read at one month intervals. Obviously choosing 30 days doesn't quite cut it and I'm hoping you can help!
    Thank you, Shayla

    ReplyDelete
  2. Hi Shayla - Apologies for the late response. Unfortunately the timeline cannot be extended to monthly basis at this stage. I will include that enhancement in the next version. Thanks.

    ReplyDelete
  3. Hi Swapnil,

    This is awesome and is helping me very much, thank you!

    Is there a way to add in the days of the week between the month/date rows?

    Thanks!

    Lisa

    ReplyDelete