Project management - an activity aimed at achieving the objectives, the implementation of specific plans, using available resources: time, capital and people. A key factor in the success of project management is to have a clear pre-determined plan to minimize the risks and deviations from the plan, effective change management.
The proposed template provides the possibility of a full project plan in Microsoft Excel (adapted for the 2007 and above).
The package included a template and a detailed 10-page description of how to use it.
Features template project plan
- Maintain a list of project tasks, adding and deleting tasks and subtasks of the project in one click with automatic numbering,
- Entry and payment dates of the start and end of tasks, their duration in working and calendar days,
- Installation of the milestones of the project and visual highlighting high priority,
- Track the status of tasks and their completion,
- Binding tasks with the responsible departments and end performers (human resources)
- Add notes to tasks of the project on a separate sheet indicating the display of a note in the project plan,
- Formation of Gantt charts in real time.
The Gantt chart is a popular type of bar charts (histograms), which is used to illustrate the plan, schedule of the project. The template allows you to create a Gantt chart of tasks imposed on the basis of the project in real time.
- The total duration of the work,
- Completion of the work,
- The current date.
Additional built-in functions
- Built-in calendar to enter the start and end dates of tasks
- Indication of setting a fixed date for the beginning of works (beginning not earlier)
- Calculation of the percentage of completion is based on the start date of the balance sheet date and,
- Table formatting (indents, in accordance with the hierarchy, the allocation of work groups)
- Calculate the end date, a specified number of days from the start date,
- Calculation of working days between two calendar dates,
- Jump to the balance sheet date on the Gantt chart,
- Choose any color and format table borders project.