Milestone Tracker & Pivot Dashboard

I need a clean, user-friendly spreadsheet that lets me log every project milestone and instantly see how far along we are. Each row of raw data should capture the milestone name, planned start date, planned finish date, the team member in charge, and an up-to-the-minute completion status. From that table I want a pivot-driven dashboard that answers three questions at a glance:

• What percentage of the overall work is complete?
• How many milestones are pending versus finished?
• How long is each milestone actually taking compared with plan?

I am comfortable in either Excel or Google Sheets, so use whichever tool helps you build solid pivot tables, slicers, and conditional formatting quickly. The file has to stay straightforward enough for non-technical colleagues to update: no VBA or add-ins—formulas and native pivot features only.

Deliverables
1. Data entry sheet with locked structure but open rows for new milestones.
2. Pivot table sheet(s) visualising percentage completion, pending/completed counts, and duration variance.
3. Light, intuitive colour-coding that highlights late or at-risk milestones.
4. A brief text guide that explains how to add new milestones and refresh the pivots.

Once the workbook meets those points and refreshes without errors, we’re done.