Course target Audience

​

• Project Manager

• Planning Engineers

• Project Controllers

• Risk Managers

• Functional Implementer

• Project Analysts

• Project Team Members

 COURSE OUTLINE 

Control Data

• Format Cells

• Data Validation and input control

• Conditional Formatting

• Some usable functions for controlling inputs

• Working with Texts in Excel

Create Project Structure

• Creating the Work Breakdown Structure (WBS)

• Create automotive weight factor structure for physical % Complete

• Create project S-Curve

• Project Status Tracker by tools and Functions

Data Transformation and lookup

• Importing and Exporting data from/to Primavera P6

• Importing and Exporting data from/to MS-Project

• V-look up and H-look up functions

• Creating the Lists and Combo Box

• Indirect , Offset , Index and other lookup functions

Schedule Analysis

• Creating Dynamic Gant chart in Excel

• Project Schedule and Budget structure

• Advanced Schedule Data Analysis

Data Analysis

• Pivot table and Data summarization

• Earned Value Management (EVM ) Calculation

• Search in Data by Functions

• Adding Formula and Calculating financial Factors

• Useful Functions in Management and Financial Analysis

• Intelligent Scoring Model for various analysis

• Advanced Grouping and Filters

Forecasting the Future

• Scenario Analysis in Project Management

• What-If Analysis and Goal Seek

• Data Table and Goal seek

• Using solver tool to optimize calculations and forecasts

• Forecasting the future by various tools

Project Dashboard

• Pivot table and Charts , Gauge Charts

• Data summarization and reporting

• Gauge Chart

• Sparkline and Data Analysis

• Dynamic Charts and Dynamic Lists

• Risk Register Structure in Excel

• Master Document Register (MDR ) in Excel