Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Microsoft Project

Highlight Tasks that are behind schedule on a MS Project Gantt Chart

Do you want to highlight tasks that are late on your Microsoft Project Lookahead schedule Gantt chart? Then follow the steps outlined in this video on how to format Bar Styles to draw focus to tasks that are late when compared to their baseline finish dates.

Display Variance against Multiple Baselines in Microsoft Project

Do you want to carry out variance analysis against more than one baselines in Microsoft Project but cannot find a way to do so out of the box?

Custom Field is my go to feature whenever I need a workaround in Microsoft Project and again they have come to the rescue. In this YouTube video, I demonstrate how to calculate and display variances against multiple baselines (Baseline1 to Baseline10) and not just Baseline (Baseline0) field.

 

Add a milestone on a Task bar in Microsoft Project

This YouTube video demonstrates one way to add a milestone on a Microsoft Project Task bar (same row), e.g., Stage Gate, Go-Live date or a Decision Point.

Note that for this solution to work, the Task Mode must be set to Auto Scheduled.

2 Ways to Create Level of Effort or Hammock Tasks in Microsoft Project

While Microsoft Project does not have a straight of the vbox Level of Effort activity type like primavera P6, you can still add Hammock or Level of Effort tasks to your Microsoft Project schedule, using one of 2 workarounds. 

The first workaround is the recommended method from Microsoft while the second method is one that is very common in the subsea construction world.

 

Show mmm-yy date format in a Microsoft Project schedule

Sometimes during project budget proposal requests, bidders might only want to show indicative dates in their bid schedules to the client and an easy way to do this is by showing only the month and year of a task in a Microsoft Project schedule.

Display different date formats in different Views of same Microsoft Project schedule

While Primavera P6 users are restricted to same date format for all Layouts of a schedule, Microsoft Project users have the luxury of using different date formats in different Views of the same schedule.

How to create a Lookahead Filter in Microsoft Project

How would you like to create a rolling date lookahead filter in Microsoft Project instead of using the default Date Range filter? Users of Primavera P6 are used to defining the criteria for lookahead filters using Data Date or Current Date and we can also do same in Microsoft Project using Status Date or Current Date rather than pick hard dates all the time using the Date Range filter.

Microsoft Project Quick Tip: Assign Actual Start & Finish Dates to Tasks

While one can update Actual Start and/or Actual Finish dates in Microsoft Project by displaying these columns, my preferred method is using the Task Details Form which is very similar to the Activity Details Form in Primavera P6.

In this short video, I show how to enable and use the Task Details Form to update actual dates for project tasks.

How to show a column of week numbers in a Microsoft Project schedule

There are times when stakeholders use week numbers to discuss the dates in a project schedule and they would like to see columns of week numbers in the schedule. The tutorial outlines steps to follow in order to display week numbers such as "2021 Week 35" in a Microsoft Project schedule.

The tutorial uses 2 custom fields with formulas to show "Start Week No." and "Finish Week No." columns. The formulas for these 2 columns are:

Show summary % complete in Microsoft Project when all subtasks are milestones and some of these milestones are completed

In Microsoft Project, when all subtasks are milestones, the summary percent complete is 0% even when some of the milestones are completed. The summary percent complete only changes to 100% when all the milestones are 100% complete.

Market Place

Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher. Teach yourself using on-line or book based learning or run your own in-house or public courses.
Syndicate content