Techno PM - Project Management Templates Download

Excel Task Tracker with Dashboard


Excel Task Management Dashboard, excel task tracker template
  • Description
  • Features
  • This excel task management dashboard and tracker can be used to manage set of tasks. The dashboard graphs shows 3 key areas of tracking - Task Information, Status and Resource Load.

    • Track status based on % complete. 
    • Highlights overdue and complete tasks for better visualization of problem tasks.
    • Can handle a list of 20 pre-defined holidays.
    • Calculates % Complete Forecast based on start and finish dates.
    • Progress is reported using traffic light indicators.
    • Provides a high level graphical view of information, status and resource load.
    • Task Information Graphs, Task status and Resource load sections.