Excel-project-portfolio-tracker

A professional Excel workbook built to track and manage projects.

Features

• Project Tracker with dropdowns and conditional formatting
• Live Dashboard with KPI formulas
• Gantt Chart timeline
• Pivot Summary with 3 pivot tables

Skills Demonstrated

• Excel formulas (COUNTIF, AVERAGEIF, IFERROR)
• Data Validation
• Conditional Formatting
• PivotTables

Tools Used

• Microsoft Excel 365

How to Use

1. Download the .xlsx file
2. Open in Microsoft Excel
3. Enter your projects in the Tracker sheet
4. Dashboard and Pivot Summary update automatically

Author

Carla - LinkedIn Profile