Individual workbooks with task lists for each project participant can be generated and subsequent batch import function used to automate the update of the project progress and status. The project status report details overall project progress based on earned value analysis with trends displayed for cost and schedule performance indices. A project Gantt schedule with daily, weekly or monthly intervals is created automatically with embedded task information. Task dependencies and timing constraints are taken into account for the automatic calculation of task timing.
Project phases, task titles, holidays and other key project parameters can be predefined to accelerate work flow. The Excel Project Management template provides the ability to define the project budget as tasks are defined. Project dynamics can be altered and performance monitored with earned value analysis throughout the complete project life cycle.
The ability to build the project budget as tasks are identified assists with the requirements for business case project proposals, valuation analysis and securing required project funding. The Excel Project Management template for Mac is designed as a generic Excel based solution to plan and manage projects.
