📊 Tracking Project Progress in Microsoft Project (15-Minute Guide)
Based on the YouTube video: “Tracking Project Progress in Microsoft Project in 15 Minutes”
Source: Alvin the PM
🎯 Why Project Progress Tracking Matters
Creating a schedule is only the beginning of project management.
The real challenge is answering questions such as:
Are we ahead or behind schedule?
Which activities are delayed?
How much work has been completed?
What impact will delays have on the overall project?
Microsoft Project provides powerful tools to compare planned work against actual progress so project managers can make informed decisions and keep projects on track.
🔹 Step 1: Create a Project Baseline
What is a Baseline?
A Baseline is a snapshot of your original project schedule.
It records:
Start Dates
Finish Dates
Durations
Planned Schedule
This becomes the reference point for measuring project performance later.
How to Set a Baseline
1. Open the Project Tab
Project → Set Baseline → Set Baseline
2. Choose:
Baseline
Entire Project
3. Click OK
Microsoft Project saves the original schedule as your baseline.
Why Baselines Are Important
Without a baseline:
❌ You cannot measure delays.
❌ You cannot compare planned vs actual progress.
❌ Schedule performance becomes difficult to evaluate.
With a baseline:
✅ Planned Schedule
VS
✅ Actual Schedule
can be compared visually at any time.
🔹 Step 2: Set the Status Date
What is a Status Date?
The Status Date is the date up to which project progress is being reported.
Example:
Today = October 11
You update all work completed up to October 11.
This date should never be in the future because future work has not happened yet.
How to Set a Status Date
Go To:
Project → Status Date
Enter:
Current Reporting Date
Example:
October 11
Click OK.
Display Status Date on Gantt Chart
Right Click Gantt Chart
Gridlines
Choose:
Status Date
Set:
Color = Red
Line Type = Solid
Click OK.
A vertical red line will appear on the Gantt Chart representing the reporting date.
🔹 Step 3: Switch to Tracking View
Tracking View makes progress updates easier to manage.
Change Table
Right Click:
Entry Table
Select:
Tracking
Now Microsoft Project displays tracking-related information.
🔹 Step 4: Add Useful Tracking Columns
Add Indicators Column
Purpose:
Display Notes
Warnings
Schedule Issues
Insert Column
Indicators
Add Duration Column
Purpose:
Compare:
Planned Duration
VS
Actual Duration
This quickly highlights schedule variances.
🔹 Step 5: Update Actual Progress
Example 1: Task Delayed
Planned
Project Planning = 3 Days
Actual
Project Planning = 5 Days
Update Duration:
5 Days
Microsoft Project immediately shows:
Extended task bar
Delay against baseline
Schedule variance
The baseline remains unchanged while actual progress updates.
Record Delay Reasons
Best Practice:
Document why a task changed.
Double Click Task
Task Information
Open:
Notes Tab
Example Note:
Additional time required to confirm project scope.
After saving:
📝 Notes Icon appears in the Indicators column.
Future reviewers can easily understand the reason for the delay.
🔹 Step 6: Mark Completed Tasks
For completed activities:
% Complete = 100%
Result:
✅ Task bar turns blue
✅ Actual Start populated
✅ Actual Finish populated
✅ Progress updated automatically
🔹 Step 7: Update Faster with Quick Completion Buttons
Microsoft Project provides shortcut buttons.
Task Tab → Schedule Group
Available options:
0%
25%
50%
75%
100%
Select a task and click the desired completion percentage.
This is much faster than manually entering values.
🔹 Step 8: Use “Mark on Track”
When a task is progressing exactly as planned:
Select Task
Click:
Task → Mark on Track
Microsoft Project automatically updates the task according to the current Status Date.
🏗️ Construction Example
Site Preparation
Planned:
3 Days
Actual:
5 Days
Status:
🔴 Delayed
Reason:
Unexpected soil condition
Foundation Layout
Planned:
3 Days
Actual:
1 Day
Status:
🟢 Ahead of Schedule
Material Identification
Planned:
3 Days
Actual:
3 Days
Status:
🟢 On Track
Using Baseline and Tracking View allows the project manager to see all three situations immediately.
📋 SOP: Weekly Progress Update in Microsoft Project
Every Week
Step 1
Set Status Date
Project → Status Date
Step 2
Switch to Tracking Table
Tracking View
Step 3
Update Actual Durations
Step 4
Update % Complete
Step 5
Add Notes for Delays
Step 6
Review Baseline Variance
Step 7
Generate Progress Report
Repeat weekly until project completion.
🔥 Key Takeaway
Tracking progress in Microsoft Project follows three simple steps:
1️⃣ Set Baseline
Creates the original schedule snapshot.
2️⃣ Set Status Date
Defines the reporting cut-off date.
3️⃣ Update Progress
Record:
Actual Duration
% Complete
Notes
Schedule Variances
👉 Baseline = What was planned
👉 Actual Progress = What really happened
👉 Tracking = Comparing the two to control the project
This is one of the most important skills for construction project managers because it helps identify delays early, take corrective actions, and keep projects on schedule.