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
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
10 LinkedIn Profiles Project Planners and Schedulers Should Follow
Topics Jerome Odeh 14/04/2022 Topics Jerome Odeh 14/04/2022

10 LinkedIn Profiles Project Planners and Schedulers Should Follow

Are you a Project Planner or Scheduler looking for how to enrich your LinkedIn feed? Then, allow me to recommend these 10 LinkedIn profiles of SMEs and MVPs.

Read More
Excel Pimps Up Conditional Formatting
Topics Jerome Odeh 06/03/2021 Topics Jerome Odeh 06/03/2021

Excel Pimps Up Conditional Formatting

Good news for Planners and Scheduler who depend on Excel for reporting as the Conditional Formatting gets a makeover with resizable dialog box and ability to duplicate rules.

Read More
10 Excel Functions Junior Planners and Schedulers should be using
Topics Jerome Odeh 30/01/2021 Topics Jerome Odeh 30/01/2021

10 Excel Functions Junior Planners and Schedulers should be using

Microsoft Excel is a powerful analytical and reporting tool and here are 10 Excel functions I think budding Project Planners & Schedulers should be using.

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
10 People to follow on LinkedIn & Planning Planet in 2020
Topics Jerome Odeh 17/02/2020 Topics Jerome Odeh 17/02/2020

10 People to follow on LinkedIn & Planning Planet in 2020

LinkedIn and Planning Planet are two of my favourite websites and here is a list of 10 people I follow on LinkedIn or look out for their posts on Planning Planet. Reading from these people always makes my day.

Read More
My Settings #05: Schedule Roll-up in Microsoft Excel
Tutorials Jerome Odeh 12/06/2016 Tutorials Jerome Odeh 12/06/2016

My Settings #05: Schedule Roll-up in Microsoft Excel

This post is about an easy and cost effective way to prepare a simple but very effective one-page summary schedule that will always grab a manager's attention as it can fit into a presentation slide.

Read More
Good Practice: Schedule Trend Charts
Topics Jerome Odeh 17/02/2016 Topics Jerome Odeh 17/02/2016

Good Practice: Schedule Trend Charts

Trend analysis produces good graphical reports, which track actual schedule performance and provide an indication of likely future performance.

Read More
Highlight Rows in Excel that Meet a Criteria
Tutorials Jerome Odeh 20/01/2016 Tutorials Jerome Odeh 20/01/2016

Highlight Rows in Excel that Meet a Criteria

Microsoft Excel is one of the most widely used reporting tools by Planners and Schedulers and this quick tip, will show how to highlight rows in an Excel worksheet that meet a criteria.

Read More
Show Calendar Days instead of dates in Primavera P6 Schedule columns
Tutorials Jerome Odeh 01/01/2016 Tutorials Jerome Odeh 01/01/2016

Show Calendar Days instead of dates in Primavera P6 Schedule columns

Do you want to show ordinal dates in a Gantt chart timeline or calendar days in the dates columns of a P6 schedule? Then this tutorial is for you.

Read More

Home
About
Disclaimer
Privacy
Contact

Blog RSS