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.
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.
Display Number of Weeks from Project Start Date instead of Start & Finish Dates in P6
Steps to follow if you want to display number of weeks from the Project Start Date instead of Start & Finish dates in a Primavera P6 schedule layout.
One way to highlight activities that are behind schedule on Primavera P6 Gantt Chart
Learn how to set-up a layout for highlighting activities that are behind baseline finish dates on a Primavera P6 Gantt chart.
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.
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.
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).
How to Produce a Report in Primavera P6 with Baseline Details for Multiple Projects
How to produce a report in Primavera P6 that shows baseline details, such as Baseline Name, Baseline Data Date, Assigned Baselines etc., for multiple projects in a Portfolio.
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.
Filter for Primavera P6 Activities with Lags
Here is a quick tip showing how to create a filter for activities with lags in a Primavera P6 schedule
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.
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.
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.
How to remove suffixes from actual and constrained dates in Primavera P6
Display your P6 dates without the “A” or “*” suffixes that come with actual and constrained dates. Also, display both start & finish dates for milestones.
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?
An easy way to trace out of sequence activities in Primavera P6
Does the start date of an activity that has not started or finish date of an activity in-progress in Primavera P6 not look right? You might have an out of sequence activity in your schedule network, so follow this tip to easily identify the activity.
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.
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.