.
Introduction
.
𝐆𝐥𝐨𝐛𝐚𝐥 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐂𝐨𝐧𝐭𝐫𝐨𝐥 is an educational source that provides you remote online learning services subjected to 𝐏𝐫𝐢𝐦𝐚𝐯𝐞𝐫𝐚 𝐏𝟔 and 𝐄𝐱𝐜𝐞𝐥.
Excel Planning Course included essential information for planners to do effective data analysis in Primavera P6. This course makes you familiar with all important and common Excel formulas for planners and schedulers. After this course, you can:
◾ Shift data from 1 sheet to another one
◾ Split and merge data to create conditions
◾ Create a Gantt chart in Excel
◾ Use to some mostly use a formula like Vlookup, If, Match and its functionality in P6
◾ Familiar with PIVOT Dashboard in Excel
.
Course Detail
◾ Course Duration: 12:00 Hours
◾ Workshop Duration: Included
.
General Condition
◾ 8 Lessons duration include workshop each one Duration is 1:30 Hour
◾ Software: Excel 2016
◾ Extra Workshop hours upon on your requirement
◾ Session Recording
◾ Certificate of Completion
◾ Assignment for further Practice
.
Fee
◾ Online Private (1 to 1) Course: 350 USD
◾ Online Group Course: 175.00 USD
◾ Offline Course: 85.00 USD
.
.
.
| No | Description | Duration (min) |
|---|---|---|
| Lesson1 | Formula Name:
Excel Text Dividers (Left, Right, Mid, Concatenate, Len, &) References (Column, Row, Sheet, Year, Month, Day, Hour) |
90 |
| Lesson2 | Formula Name:
Services (Isserror, Min, Max, Round Down/Up, Round, Int, Proper, Upper) |
90 |
| Lesson3 | Formula Name:
Sum, Sumif, Count, CountA, Countif, SumProduct, Product, Substitute |
90 |
| Lesson4 | Formula Name:
Subtotal, Replace, If, And, Or |
90 |
| Lesson5 | Formula Name:
IFError, IFNA, VLookup, HLookup |
90 |
| Lesson6 | Formula Name:
Remove Duplicate, List Creation, Conditional Formatting |
90 |
| Lesson7 | Formula Name:
Match, Index, Lookup+Match |
90 |
| Lesson8 | Formula Name:
Pivot, Text to Column |
90 |
