Stephen is a project manager who is launching a big project in three months. Task bars are color-coded by status and shaded based on completion percentage, with icons to indicate who is in charge of each task. You can adjust task duration, start dates, and end dates by dragging and resizing task bars. The Gantt timeline chart on the right side puts all of this information into an easy-to-read chart. Initiative - Complex projects may need to be broken down into a set of Initiatives that will each consist of a specific set of tasks. Owner - The main person or people responsible for this task. By planning out task deadlines, you're much more likely to get your project completed by your target dates.ĭuration - Knowing how long you've allotted for each task will give you a benchmark for how far along each task should take.Ĭompletion % - Track progress toward completion of each task. Start Date/ End Date - Part of project management is making sure things get done on time. The RYG column uses a 3-color stoplight system to let you know at a glance which tasks are good to go, which are slowly progressing, and which have critical issues you may need to address.

RYG - You may have noticed there are many possible options for a project's status. Status - Whether the task is still in the planning phase, in progress, delayed, on hold, pending review, completed, fully approved, etc. Task - The name of the specific task we're talking about For each task, columns represent the following: The Project Plan spreadsheet lays out all of the tasks required in order for your project to be a success. How does this Project Plan template work?

Excel monthly task planner templates