Excel Task Tracker with Dashboard
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.