I developed an Excel-based project tracking and reporting workbook to bring project status, milestones, timelines, budgets and resource information into one place. I organised the underlying data, calculated project completion and budget variances, and used formulas, PivotTables and charts to create a clear reporting dashboard. The final output made it easier to monitor progress, identify projects requiring attention and provide a concise view of overall portfolio performance.