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

DATA ANALYSIS

• Pivotable and Data summarization
• Earned Value Management (EVM ) Calculation
• Search in Data by Functions
• Adding Formula and Calculating financial Factors (PV, FV, NPV, IRR, PMT, IMPT)
• Useful Functions in Management and Financial Analysis
• Intelligent Scoring Model for various analysis
• Advanced Grouping and Filters

SCHEDULE ANALYSIS

• Creating Dynamic Gant chart in Excel
• Project Schedule and Budget structure
• Advanced Schedule Data Analysis 

FORECASTING THE FUTURE

• Scenario Analysis in Project Management
• What-If Analysis and Goal Seek
• Data Table and Goal seek
• Using a solver tool to optimize calculations and forecasts
• Forecasting the future with various tools 

PROJECT DASHBOARD

• Pivotable and Charts, Gauga Charts
• Data summarization and reporting
• Gauge Chart
• Sparklines and Data Analysis
• Dynamic Charts and Dynamic Lists
• Risk Register Structure in Excel
• Master Document Register (MDR) in Excel

AUTOMATION

• Creating a Macro
• Smart Art and Graph
• Create Dynamic Auto-filled letters and Lists