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


task tracking spreadsheet templatecountif examplesexcel vba programming pdfactivesheet cellsvba msg boxexcel chart filterexcel template dashboardexcel 2010 slicer tutorialsort vbaadvanced filter in excel 2010dml in databaseword userformarea charts in excelvbscript programs examplesexcel interactive dashboard templatetcs interview questions and answers pdfcopyfile vbalist box vbaunprotect excel documentvba excel outlookadvanced excel vbashortcut key strikethrough excelvb direxcel macro sheetsvb coding examplesexcel vba samplewhat are the ddl commandsexcel vb arrayexcel macro delete columnsumifs excel 2007excel pivot tutorialmessage box vba yes noexcel vba countif functionexcel expert tutorialhide columns in excel 2007excel formula colour cellmicrosoft excel macros examplestos codesmicrosoft excel tables tutorialamazing excel macrosaccess vba delete recordconditionals in excelremove unused cells in excelvba excel copy rangeexcel duplicate finderexcel vb arrayvlookup demohow to use countif function in excel 2007how to highlight duplicate values in excelapplication filedialogactive range vbaddl queriescase in vbams access import excel vbaconstruction estimate excel templateconditional statement in excelhow to adjust cells in excelplot chart excelhow to run a macro in excel 2007new worksheet vbaascending and descending order in excelconvert excel csvfree excel formulas with examples in excel sheetexcel ribbon vbaintegrated master schedule templateexcel vba not equalhow to apply validation in excelfind duplicates in column excelvbscript to copy files from one folder to anotherhide cells excelvba savemost useful excel formulasvba code to close form