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: 250.00 USD
โพ Online Private (1 to 1) Course: Click here to contact usย
โพ Offline course: 110.00 USD
โพ Hybrid course: 175.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โ |
