0
Skip to Content
Planners' Place
Home
All Tutorials
P6
MS Project
Excel
Topics
Find Help
Knowledge Base
Planners' Place
Home
All Tutorials
P6
MS Project
Excel
Topics
Find Help
Knowledge Base
Home
Folder: Tutorials & Tips
Back
All Tutorials
P6
MS Project
Excel
Topics
Find Help
Knowledge Base
Show Microsoft Project schedule dates in mmm-yy (month and year) format
Tutorials Jerome Odeh 20/12/2021 Tutorials Jerome Odeh 20/12/2021

Show Microsoft Project schedule dates in mmm-yy (month and year) format

Show only the month & year of dates in a Microsoft Project schedule for senior management use or bid submission. This tutorial also shows you how to hide the Gantt chart of a Microsoft Project schedule.

Read More
Display different date formats in different Views of a Microsoft Project schedule
Tutorials Jerome Odeh 17/12/2021 Tutorials Jerome Odeh 17/12/2021

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

Microsoft Project, unlike Primavera P6, allows users to have different date formats for different Views of the same schedule.

Read More
How to display Primavera P6 dates in mmm-yy format
Tutorials Jerome Odeh 05/12/2021 Tutorials Jerome Odeh 05/12/2021

How to display Primavera P6 dates in mmm-yy format

If you ever want to exclude the day portion of a date in a Primavera P6 schedule so that you are left with only the month & year portions of a date, then this tutorial is for you.

Read More
Assign Actual Dates in Microsoft Project using Task Details Form
Tutorials Jerome Odeh 14/10/2021 Tutorials Jerome Odeh 14/10/2021

Assign Actual Dates in Microsoft Project using Task Details Form

Here is a quick tip on my preferred method for assigning actual start & finish dates to tasks in Microsoft Project, i.e. through the Task Details Form

Read More
One way to use Expenses for lumpsum cost in Primavera P6 to generate data for S-curves
Tutorials Jerome Odeh 03/08/2021 Tutorials Jerome Odeh 03/08/2021

One way to use Expenses for lumpsum cost in Primavera P6 to generate data for S-curves

Learn how to use Expenses for lumpsum cost in Primavera P6 to generate data for use in Excel to plot progress s-curves when you cannot use resources to generate the data.

Read More
Add Alphanumeric Activity ID Column to a Microsoft Project Schedule (Updated)
Tutorials Jerome Odeh 25/07/2021 Tutorials Jerome Odeh 25/07/2021

Add Alphanumeric Activity ID Column to a Microsoft Project Schedule (Updated)

This tutorial is for Primavera P6 users who also need to manage a Microsoft Project schedule and would like to display an Activity ID column with unique alphanumeric ids in Microsoft Project.

Read More
How to show week number columns in a Microsoft Project schedule
Tutorials Jerome Odeh 13/06/2021 Tutorials Jerome Odeh 13/06/2021

How to show week number columns in a Microsoft Project schedule

Use custom fields to add start date and/or finish date week number columns, e.g. a column to show date in the format “2021 Week 10”, in a Microsoft project schedule

Read More
Display summary task percent complete when all subtasks are milestones in Microsoft Project
Tutorials Jerome Odeh 12/06/2021 Tutorials Jerome Odeh 12/06/2021

Display summary task percent complete when all subtasks are milestones in Microsoft Project

When all subtasks in Microsoft Project are milestones, the summary task percent complete is always 0% unless all the subtasks are 100%. The workaround in this tutorial will display a % complete based on number of milestones completed.

Read More
Baseline Execution Index (BEI) in Microsoft Project
Tutorials Jerome Odeh 28/04/2021 Tutorials Jerome Odeh 28/04/2021

Baseline Execution Index (BEI) in Microsoft Project

Baseline Execution Index (BEI) is one of the metrics in the DCMA 14-Point Assessment for project schedules and in this post, we are going to look at how to calculate and display BEI in a Microsoft Project schedule.

Read More
Add Decimal Places to Microsoft Project % Complete
Tutorials Jerome Odeh 14/04/2021 Tutorials Jerome Odeh 14/04/2021

Add Decimal Places to Microsoft Project % Complete

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
Microsoft Project Progress Status Traffic Light (RAG Status)
Tutorials Jerome Odeh 28/03/2021 Tutorials Jerome Odeh 28/03/2021

Microsoft Project Progress Status Traffic Light (RAG Status)

Learn how to use Custom Fields to display traffic light (RAG Status) for progress status of tasks in a Microsoft Project schedule.

Read More
Microsoft Project Baseline Percent (%) with Weighted Summary Roll-up
Tutorials Jerome Odeh 20/03/2021 Tutorials Jerome Odeh 20/03/2021

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

The workaround in this tutorial is for Primavera P6 Users looking for ways to display a baseline % complete column in Microsoft Project. This workaround also shows how to roll-up summary tasks % complete.

Read More
Microsoft Project for P6 User – Assign Activity Codes
Tutorials Jerome Odeh 04/03/2021 Tutorials Jerome Odeh 04/03/2021

Microsoft Project for P6 User – Assign Activity Codes

Learn how to use Custom Fields to replicate Primavera P6 Activity Codes to enable grouping and/or filtering of tasks in Microsoft Project.

Read More
How to remove gaps after data date for activities in progress in Primavera P6
Tutorials Jerome Odeh 24/08/2020 Tutorials Jerome Odeh 24/08/2020

How to remove gaps after data date for activities in progress in Primavera P6

Do you have gaps on activity bars after the data date for activities that are in progress in Primavera P6? Get rid of the gaps with this quick tip.

Read More
How to stop Microsoft Project progress bar extending beyond status date
Tutorials Jerome Odeh 24/08/2020 Tutorials Jerome Odeh 24/08/2020

How to stop Microsoft Project progress bar extending beyond status date

Here is a workaround that will ensure that your progress bars are always left of the status date line.

Read More
How to Prepare a Schedule Logic Report in Primavera P6
Tutorials Jerome Odeh 31/07/2020 Tutorials Jerome Odeh 31/07/2020

How to Prepare a Schedule Logic Report in Primavera P6

Is your project team struggling to follow the logic of your Primavera P6 schedule? Learn how to produce a schedule logic report that lists predecessors, their dates, relationship types, lags & driving status.

Read More
How to Export Microsoft Project Data to Excel for Analysis
Tutorials Jerome Odeh 04/07/2020 Tutorials Jerome Odeh 04/07/2020

How to Export Microsoft Project Data to Excel for Analysis

If you have ever used Primavera P6, you would be surprised that exporting from Microsoft Project to Excel does not provide you with a ready to use data.

Read More
How to Display P6 Durations in Both Hours & Days
Tutorials Jerome Odeh 08/12/2019 Tutorials Jerome Odeh 08/12/2019

How to Display P6 Durations in Both Hours & Days

This tutorial outlines the steps required to display two different units of durations in a Primavera P6 schedule.

Read More
Newer Posts
Older Posts

Home
About
Disclaimer
Privacy
Contact

Blog RSS