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