Baselines, Variance & Progress Tracking

Step-by-step Microsoft Project tutorials by 22-year MVP Dale Howard on saving Baselines, analyzing Start, Finish, Duration, Work, and Cost Variance, calculating Percent Variance formulas, setting the Status Date, and tracking project progress.

Filter Articles by Topic Hub:← Back to Main Project Blog
📚 All Microsoft Project (95) 📊 Baselines & Variance (13) 🔗 Tasks & Dependencies (29) 🎨 Views, Tables & Formatting (26) 👥 Resources & Costing (13) 📅 Calendars & Working Time (12) 📈 Reports, Timelines & Excel (10) 💻 Project Professional vs. Standard (85) 🖥️ Project Server (9) ☁️ Project Online (9) ✅ Microsoft Planner (10)
Schedule Control & Earned Value Series

Baselines, Variance & Progress Tracking in Microsoft Project

Tracking schedule, cost, and work slippage in Microsoft Project requires a structured four-step workflow: saving a baseline snapshot, setting the Status Date, entering actual progress, and analyzing variance fields or custom percentage formulas.

  • Step 1 — Save & Maintain Baselines: Capture your approved schedule in Baseline (plus up to 10 interim/additional baselines, Baseline 1–10) and roll updated tasks up to summary tasks.
  • Step 2 — Status Date & Progress Entry: Set the Project Status Date and record actual start/finish dates, percent complete, and remaining duration.
  • Step 3 — Variance Views & Percent Variance Formulas: Use the built-in Variance table and custom IIf() formulas to calculate Duration Variance %, Cost Variance %, and Work Variance % with red/yellow/green graphical indicators.

Start with Article 1: How to Save a Baseline →