Project Portfolio Dashboard Template

Home/Project/Project Management/Excel Templates/Project Portfolio Dashboard Template

Project Portfolio Excel Template developed to help teams to mange multiple projects, resource. You can easily add any number of projects, activities and assign to any individual in your team. This will be your Project Management System to perform and track verity of functions while working on any project.

Core Features of Project Portfolio Excel template:

  1. You can Handle Multiple Projects
  2. You can Handle Multiple Resource
  3. You can Pre-define Tasks List
  4. You can Define Holidays and Weekends
  5. You can Decide to consider Week-ends and holidays in project time-lines
  6. You can track Risks and Issues by task,Person and Critical Level
  7. You can monitor the Activity Heat-map by Project and Person
  8. You can monitor the Activity Heat-map by Weekly,Monthly and Yearly View]
  9. You can monitor the tasks and it’s status by project and Person
  10. You can monitor the Project Budget Actual vs Spent
  11. Users with Windows and Office 2010 and Higher users can drill-down by any combination of Projects, Resource, Status and Time.

Requirement: Excel 2007 and higher
Compatible: Windows and Mac
Created On: 17-Jan-2016
Last Updated:17-Jan-2016


Worksheets in the Project Portfolio Excel template Workbook:

  1. Home: Main Sheet with Navigation Links
  2. Lists & Settings: You can define your team, project and activities. You can also define Holidays and Weeks and decide to consider in planning
  3. Data:You will enter your activities here
  4. Risk or Issue log: You can enter and track the projects risks and issue here
  5. Activity HeatMap: To View the Activiry Heat By Project and Team Member (Responsible)
  6. Projects: To View the Status of the all activities of selected Project with Gantt Chart
  7. Resource: To View the Status of the all activities of selected Person with Gantt Chart
  8. Projects Executive Dashboard: This is only for Windows users with Excel 2010 and Higher
  9. Hidden Sheets: You can un-hide the hidden sheets to see the formulas and customize if required

How to use Project Portfolio Excel template

  • Go to Lists & Settings: worksheet and change the team, project and task details. Also set update the Holidays and Weekends which your team is availing (select the check boxes to consider the holidays or weeks ends)
  • Go to Data: sheet and clear the existing data from column J to S, do not delete calculated Columns (A:I). Now you enter your tasks and project plans in the data sheet (from column J to S)
  • Go to Risk or Issue log: sheet and clear the existing data in the table. And the risks and issues of the projects (if any)
  • All the sheets (Activity HeatMap,Projects and Projects) will be updated automatically based on your data. And click on the refresh button in the ‘Projects Executive Dashboard’ to see the update data
  • All the views (Activity HeatMap,Projects, Projects and Projects Executive Dashboard) worksheets are protected to avoid the accidental changes, you can un-protect the sheets by clicking on the un-protect command in the Review Ribbon menu tab

How to Filter Dashboard by Project, Person or Status (Applicable for Office 2010 and above):

  1. Click on the Toggle Menu Icons: You can view the Slicers to Filter the Data
  2. Select Items: Select the required Items to view the data for that particular Items
  3. You can Reset the Filters by clicking on the clear Filter icon on the top-right corner of each Slicer.

Project Portfolio Filters


Related pages


vba activate worksheetexcel 2007 vba macro programmingexcel vba select casevba code to save workbookstacked column graph excel 2010simple vba code examplescreating if statements in excelexcel test for blank cellconvert vbamacro for vlookupmis executive interview questions and answers pdfexcel clear blank cellsexcel how to insert rowshortcut keys of excelfilter macro excelhow to convert xls to xml formatvlookup tutorial 2013excel vba matrixsumif function excel 2013if statement excel 2010excel beginners tutorialhow to do data validation in excel 2010change a row to a column in excelprotect excel file from editingmatch function in vbah look upmicrosoft excel 2010 pivot table tutorialvbscript write to text filesql server pivot table examplehow to learn vbatranspose in vbacode vbaexcel 2007 delete blank rowspowerpoint macro examplesproject spreadsheet template exceldynamic graph in excelms excel lookup functionhow to put numbers in ascending order in excelchange width of column in excelexcel macro active sheetadd the developer tab to the ribbon wordrgb excel vbaworkbooks open vbaunprotect excel vba codehow to enable macro in excelswitch statement in vbavba excel sorthow to merge cells excel 2013record macro powerpoint 2007excel delete rowhow to lock a sheet in excelaccess query vbavba for beginnersvba insert columnhow to use iferror with vlookupforms.comboboxms excel macro programmingwhat is vlookup in excel definitionexcel vba debugcountif sampleexcel 2003 macrosadding filters to excelvlookup with isnaexcel charts tutorialvba adodb.commandhow to create macro button in excelddl commands in sql with syntaxunprotect worksheet excel 2013formula to remove special characters in excelhow to use vlookup function in excelexcel vba application.matchrollout schedule templatevb dialog boxformula of vlookupprofessional excel development ebook