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

• Pivot-able 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

• Pivot-able 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

Automation

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