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

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

2 years 41 weeks ago

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."

Read more...
 

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

2 years 41 weeks ago

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.

This behaviour is as expected as Microsoft Project calculates percent complete using actual duration but since

Read more...
 

Empowering Your Teams

2 years 42 weeks ago

The virtues of high-performing teams are well documented.  They are 50% more productive.  They are more creative, and members are 76% more likely to be engaged.  

Read more...
 

How to show Baseline Execution Index (BEI) in Microsoft Project

2 years 46 weeks ago

The Defense Contract Management Agency (DCMA) 14-Point Assessment is a set of metrics used to evaluate the quality of a project schedule to ensure that the schedule is fit for purpose. And one of the 14 metrics is the Baseline Execution Index (BEI) which is an indication of how a schedule is performing against a set baseline and the video below explains how to set-up a

Read more...
 

Optics: The Good, the Bad, & the Ugly

2 years 47 weeks ago

The traditional definition of optics is the scientific study of sight or light.  An alternative description relates to politics and refers to the perception of a situation.  The political origin dates back to the Carter Administration when a 

Read more...
 

Add Decimal Places to Microsoft Project % Complete

2 years 49 weeks ago

By default, Microsoft Project does not display task % complete numbers with decimal places. In this tutorial, you will learn how to add decimal places to % complete using custom fields.

 

Read more...
 

Better Zoom Meetings

2 years 51 weeks ago

In one of my training classes, there is an exercise to conduct a daily stand-up meeting.  The meeting should be no longer than 15-minutes and be well structured.  In class, we challenge the leader with common distracting and unproductive behaviors.  Watch the clip, the results are often hilarious.  

Read more...
 

How to Use Traffic Light to Show Microsoft Project Progress Status

3 years 4 hours ago
Sometimes in a Microsoft Project schedule, you might want a quick visual indicator of when a task is behind schedule or in progress and a good way to achieve this is through the use of a traffic light system. This tutorial will show you how to configure your Microsoft Project schedule using a custom field with graphical indicator to highlight progress of tasks as at current or status date.
Read more...
 

Microsoft Project Baseline Percent (%) with Weighted Summary Roll-up

3 years 1 week ago

By default, Microsoft Project does not have a baseline percent (%) complete field or column like you would find in other scheduling software like Primavera P6.

This video outlines steps to follow if you want to display a baseline percent (%) complete column in a Microsoft Project schedule. It also shows how to roll-up percent (%) complete to summary tasks based on weighted percent (%)

Read more...
 

Show Calendar Days instead of Dates in MS Project Schedule columns

3 years 2 weeks ago

Sometimes during tender or bid submission for a project, the client might not provide a Project start date and bidders would be required to show ordinal dates in the Gantt chart timeline and calendar days in the start and finish dates columns, so that, for each activity, the schedule will show start and finish days, e.g. for a 10-day activity, the schedule will show day 1 in the start column

Read more...
 

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.