• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Office / Use a Baseline to Measure Project Progress

Use a Baseline to Measure Project Progress

Set a baseline for your project so that you can track its progress against the original project plan. A baseline is a reference point for the project schedule. It can be used to measure the project progress in certain categories.

The baseline saves nearly 20 reference points in 5 different categories for all the tasks in your project. These are the Start Dates, Finish Dates, Durations, Work and Cost. For an effective baseline you should ensure that these estimates are accurate in your project before you set the baseline.

Set a Baseline for the Project

  1. Click the Tools menu, select Tracking and click Set Baseline
  2. Ensure Set Baseline is selected for the first option
  3. In the For section choose the set a baseline for the Entire project, or for Selected tasks
Setting a baseline in MS Project

You can set up to 11 baselines so that you can measure project progress against interim points in your project.

Analyse Baseline Data

Once a project’s baseline data has been saved, it can be used to analyse project performance.

Microsoft Project provides many ways for you to analyse and measure progress. Here are two;

View Baseline Information in Project Statistics

The Project Statistics window enables you to compare the actual and baseline data of vital statistics for your project.

  1. Click the Project menu and select Project Information
  2. Click the Statistics button

The image below shows the Project Statistics window and the variance between the actual and baseline duration of the project.

Baseline data in the Project Statistics window

Measure the Actual Data Against the Baseline Schedule using the Tracking Gantt

The Tracking Gantt allows you to easily compare the project schedule against the initial plan. The variance between the task bars is easy to track.

The image below shows the variance between the baseline bar (above) and the actual data (below). It shows that the tasks are a little behind schedule.

Viewing actual data against the baseline on a Gantt Chart

Setting a baseline provides reference points that you can use to measure your project progress against. Microsoft Project provides many ways of analysing its progress and make use of this baseline data.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·