Create Progress Measurement Sheet (PMS)-Basics-English

This course is designed for project managers and team members who want to improve their ability to track the progress of their projects. The course will cover the basics of creating a PMS in Excel, including how to outline the phases or stages of a project, list out the tasks that need to be completed in each phase, and decide on the metrics to use for measuring progress.

In addition to the Excel component, the course will also cover how to update the PMS from P6,

By the end of the course, students will have a solid understanding of how to create a PMS in Excel and link it with P6 and will be able to use these tools to improve their ability to track progress and make data-driven decisions.

The course will cover the following topics:

• Convert the P6 data Inro Excel

• Coloring & Grouping the WBS in Excel

• Calculate the planned Units over time.

• Using P6-resources assignment to get the Planned units.

• Creating a Dynamic PMS in Excel

• Manual update for the PMS

• Link P6 update with the PMS

• update the P6 from the PMS

• Best practices for tracking progress and making data-driven decisions

This course is suitable for project managers, team members, and anyone who wants to improve their ability to track the progress of their projects. A basic understanding of Excel and Power BI is recommended, but not required.