Introduction
Global Project Control is an educational platform offering remote online learning services focused on Primavera P6 and Excel.
This Advanced Primavera P6 Course is designed to enhance your skills by integrating Primavera P6 with Excel functionalities. Throughout this course, we will explore how to utilize Excel within P6 to create and design dashboards for tracking project delays. By the end of this course, you will be able to:
- Import, modify, and update project information using Excel spreadsheets.
- Assign activities to the Work Breakdown Structure (WBS) via Excel.
- Import activity codes into the project and understand their functionalities.
- Import budget units into the project using Excel.
- Perform resource leveling within the project.
- Gain familiarity with Earned Value Management (EVM) in Primavera P6.
- Create S-Curves using templates.
- Track changes within the project.
- Create and update Pivot Dashboards in Primavera P6
Detail
◾ Course Duration: 9:00 Hours
◾ Troubleshooting Workshop Duration: 1:30 hour
General Condition
◾ 7 Lessons duration each one Duration is 1:30 hour
◾ Software = Primavera P6 19.12 | 23.12
◾ Session Recording
◾ Certificate of Completion
◾ Assignment for further Practice
◾ The online course will be held on Zoom.
◾ Software Installation: For free
Fee
◾ Online Group course: 250.00 USD
◾ Online Private (1 to 1) course: Click here to contact us
◾ Offline course: 110.00 USD
◾ Hybrid course: 175.00 USD
Importing Data and Project Services
- Import activities into the project
- Easily create the Work Breakdown Structure (WBS)
- Modify Primavera P6 activity IDs
- Import budget units
- Import relationships
Tracking, Updating, and Monitoring
- Import cost accounts
- Update project activity progress
- Update project resource progress
- Update relationships and manage out-of-sequence activities via spreadsheets
- Update and maintain baseline durations and relationships
- Modify resource limits
- Compare activity calendars with resource calendars
- Perform resource leveling
Analyze and Reporting
- Create and update interactive project pivot S-curves using activity codes
- Remove actuals from updated projects
- Track relationship changes
- Develop recovery schedule S-curves (catch-up plans)
- Perform Earned Value Management (EVM) calculations in Primavera P6
- Identify project lags through reporting
- Update project activity codes
- Create interactive dashboards using activity codes
- Track delays using P6 dashboards
Requirements:
- Good Primavera P6 Knowledge
- Good Excel Knowledge
- Familiar with MSP
Have questions? We’re just a ▶️ Click away
