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.
Coupons are issued by instructors to promote their courses, gain traction and reach momentum. The instructor can choose to emit discounted (ex: $11.99 coupon) or 100% off coupon (you pay nothing). Each coupon becomes expired when emitted quota is over (1000 enrollments) OR expiration date has been reach (5 days).
For a coupon, number of activation are now capped to 1000 max. This means that it can be activated only a 1000 times, and then it expires; or reach its expiration date; whatever happens first.
We have no contact with instructors, and only instructors can emit coupons. You can try to directly contact the instructor finding his/her Twitter/Facebook, and ask him/her for a coupon, but at our level, we cannot help, sorry.
We have an affiliate contract with Udemy and we may receive a commission when you purchase through some of the affiliate links on this website. But this website is not a part of the Udemy Inc. Additionally, this website is NOT endorsed by Udemy in any way. Udemy is a trademark of Udemy, Inc. `