0
Skip to Content
Planners' Place
Home
Tutorials & Tips
All Tutorials
P6
MS Project
Excel
Topics
Resources
Planners' Place
Home
Tutorials & Tips
All Tutorials
P6
MS Project
Excel
Topics
Resources
Home
Folder: Tutorials & Tips
Topics
Resources
Back
All Tutorials
P6
MS Project
Excel
How to Show Progress Bar on Summary Tasks in Microsoft Project
Tutorials Jerome Odeh 07/12/2024 Tutorials Jerome Odeh 07/12/2024

How to Show Progress Bar on Summary Tasks in Microsoft Project

How to show a progress bar on Summary Tasks in Microsoft Project or fix the issue with progress bar not showing correctly.

Read More
Pasting Dates into Excel from Microsoft Project or Primavera P6 & the 2029 Rule in Excel
Tutorials Jerome Odeh 30/06/2024 Tutorials Jerome Odeh 30/06/2024

Pasting Dates into Excel from Microsoft Project or Primavera P6 & the 2029 Rule in Excel

Paste or enter a 2 digit year (yy) date later than 2029 into Excel and you might notice that Excel converts it into a 19yy date instead of 20yy.

Read More
Shade Working Periods in Microsoft Project (Primavera P6 Like Curtain)
Tutorials Jerome Odeh 07/04/2024 Tutorials Jerome Odeh 07/04/2024

Shade Working Periods in Microsoft Project (Primavera P6 Like Curtain)

How to highlight specific working periods (shaded background) on a Microsoft Project Gantt Chart and label them using textboxes.

Read More
Highlight Tasks that are behind schedule on a Gantt Chart in Microsoft Project
Tutorials Jerome Odeh 24/11/2023 Tutorials Jerome Odeh 24/11/2023

Highlight Tasks that are behind schedule on a Gantt Chart in Microsoft Project

One way of highlighting tasks that are behind schedule (Finish Variance greater than 0 days) on a Microsoft Project Gantt Chart.

Read More
Check for Non-ASAP Constraint Type in Microsoft Project
Tutorials Jerome Odeh 26/08/2023 Tutorials Jerome Odeh 26/08/2023

Check for Non-ASAP Constraint Type in Microsoft Project

Set-up a filter in Microsoft Project to show Tasks assigned a constraint type other than As Soon As Possible.

Read More
Change Multiple Tasks Text Colour at same time in Microsoft Project
Tutorials Jerome Odeh 22/08/2023 Tutorials Jerome Odeh 22/08/2023

Change Multiple Tasks Text Colour at same time in Microsoft Project

Semi-automatically change the colour of multiple tasks’ text in a Microsoft Project that meet a condition by running a simple macro (Microsoft Project conditional formatting).

Read More
How to Show Variance against Multiple Baselines in a Microsoft Project Schedule
Tutorials Jerome Odeh 29/05/2023 Tutorials Jerome Odeh 29/05/2023

How to Show Variance against Multiple Baselines in a Microsoft Project Schedule

Display variance against all other baselines (Baseline1 to Baseline10) in a Microsoft Project schedule not only the current baseline.

Read More
Microsoft Project Lookahead Schedule: Group Tasks by Dates
Tutorials Jerome Odeh 01/02/2023 Tutorials Jerome Odeh 01/02/2023

Microsoft Project Lookahead Schedule: Group Tasks by Dates

Present your Microsoft Project lookahead schedule with tasks grouped by dates in addition to the default View that groups tasks by WBS.

Read More
 How to add a milestone symbol on a task bar in Microsoft Project
Tutorials Jerome Odeh 27/11/2022 Tutorials Jerome Odeh 27/11/2022

How to add a milestone symbol on a task bar in Microsoft Project

Follow the steps outlined in this video if you want to show a milestone on a task bar in Microsoft Project.

Read More
2 methods of creating Level of Effort or Hammock Tasks in Microsoft Project
Tutorials Jerome Odeh 01/05/2022 Tutorials Jerome Odeh 01/05/2022

2 methods of creating Level of Effort or Hammock Tasks in Microsoft Project

Here are 2 ways to create P6 style Level of Effort or Hammock tasks in Microsoft Project; the recommended method from Microsoft Project and an alternative that is common in subsea construction.

Read More
How to create a rolling date Lookahead Filter in Microsoft Project
Tutorials Jerome Odeh 07/04/2022 Tutorials Jerome Odeh 07/04/2022

How to create a rolling date Lookahead Filter in Microsoft Project

Tired of using Date Range filter for your lookahead in Microsoft Project or do you crave setting up a rolling date lookahead filter just like you would in Primavera P6?

Read More
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
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
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
Older Posts

Home
About
Disclaimer
Privacy
Contact

Blog RSS