Excel Project Management Template ^new^ -

| Metric | Value | |--------|-------| | Total Tasks | =COUNTA(Tasks!A:A)-1 | | Completed Tasks | =COUNTIF(Tasks!G:G,"Done") | | Overdue Tasks | =COUNTIF(Tasks!F:F,"<"&TODAY()) | | Open High Priority Tasks | =COUNTIFS(Tasks!D:D,"High",Tasks!G:G,"<>Done") |

| List Name | Values | |-----------|--------| | StatusList | Not Started, In Progress, Done, Blocked | | PriorityList | High, Medium, Low | | ImpactList | High, Medium, Low | | ProbabilityList | High, Medium, Low | excel project management template

=IF(Impact="High",3,IF(Impact="Medium",2,1)) * IF(Probability="High",3,IF(Probability="Medium",2,1)) Sheet 6: Milestones | A | B | C | D | |---|----|----|----| | Milestone Name | Due Date | Actual Date | Status | | Kickoff | 05-Apr-2026 | 05-Apr-2026 | Met | | Beta Launch | 30-Jun-2026 | – | Pending | Bonus: Dropdown Lists (Data Validation) Create these in a separate sheet called Lists : | Metric | Value | |--------|-------| | Total