Introduction
.
𝐆𝐥𝐨𝐛𝐚𝐥 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐂𝐨𝐧𝐭𝐫𝐨𝐥 is an educational source that provides you remote online learning services subjected to 𝐏𝐫𝐢𝐦𝐚𝐯𝐞𝐫𝐚 𝐏𝟔 𝐚𝐧𝐝 𝐄𝐱𝐜𝐞𝐥.
This is 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐏𝐫𝐢𝐦𝐚𝐯𝐞𝐫𝐚 𝐏𝟔 𝐂𝐨𝐮𝐫𝐬𝐞 which provides you that 𝐏𝐫𝐢𝐦𝐚𝐯𝐞𝐫𝐚 𝐏𝟔 𝐬𝐩𝐫𝐞𝐚𝐝𝐬𝐡𝐞𝐞𝐭 𝐟𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐚𝐥𝐢𝐭𝐲, in this course, we will discuss Excel functionality on P6 and mixed them up together, you can create & design your 𝐃𝐀𝐒𝐇𝐁𝐎𝐀𝐑𝐃 and use it to 𝐓𝐫𝐚𝐜𝐤 𝐩𝐫𝐨𝐣𝐞𝐜𝐭 𝐝𝐞𝐥𝐚𝐲, by this you can:
◾ Import, modify, and update project information from Excel Spreadsheet.
◾ How to assign activity to WBS by Excel Spreadsheet.
◾ How to import activity code into the project and its functionality.
◾ Import Budget Unit to Project by Excel Spreadsheet.
◾ Leveling Project resource
◾ Familiar with EVM on Primavera P6
◾ How to create S-Curve by Templating
◾ Track Changes in the Project
◾ How to create, and update PIVOT Dashboard by Primavera P6
.
Detail
◾ Course Duration: 9:00 Hours
◾ Trouble-Shooting Workshop Duration: 1:30 Hour
.
General Condition
◾ 7 Lessons duration each one Duration is 1:30 Hour
◾ Software = Primavera P6 19.12
◾ Session Recording
◾ Certificate of Completion
◾ Assignment for further Practice
◾ This is an online course and it will be held over Zoom
◾ Software Installation: For free
.
Fee
◾ Online Group course : 200.00 USD
◾ Online Private (1 to 1) Course: 400 USD
◾ Offline course : 110.00 USD
◾ Hybrid course : 150.00 USD
Space
|
Import Data and Project Services |
||
| Description | Duration | Lesson |
|---|---|---|
| ◻ Import activities in the project
◻ Easy WBS Creation ◻ Change Primavera (P6) activity ID ◻ Import Budget Unit ◻ Import Relationships |
90
Min |
L-1 |
Space
|
Tracking, Updating, and Monitoring |
||
| Description | Duration | Lesson |
|---|---|---|
| ◻ Import Cost Account
◻ Update Project Progress in the Activity sheet ◻ Update Project Progress in the Resource sheet ◻ Update Relationships |
90
Min |
L-2 |
| ◻ Update/Maintain Baseline Duration and relationship
◻ Resource Limit Change ◻ How to compare Activity Calendar VS Resource Calendar ◻ Level Resource |
90
Min |
L-3 |
Space
|
Analyze and Reporting |
||
| Description | Duration | Lesson |
|---|---|---|
| ◻ Create/Update Interactive Project PIVOT S-Curve by Activity Codes
◻ Remove Actual from Updated project ◻ Track Relationship Changes |
90
Min |
L-4 |
| ◻ How to create Recovery Schedule S-Curve by Report Module
◻ EVM P6 Calculation ◻ How to Find Project LAG by Report |
90
Min |
L-5 |
| ◻ How to Update Project Activity Code
◻ Interactive Dashboard Creation in Project by Activity Codes ◻ Track Delay by P6 Dashboard |
90
Min |
L-6 |
|
Excel Requirements |
|
Description |
|---|
| ✅ Excel Text Dividers
✅ How Excel’s IF Function works ✅ Everything about VLOOKUP and HLOOKUP in EXCEL ✅ How Excel’s SUBTOTAL Function works ✅ How Excel’s SUMIF Function works ✅ How to use “Text to column” |
