Description

Microsoft Excel in Project Management

Microsoft Excel in Project Management course is for project managers, Project Planners and project engineers who need the power of Excel for project Data analysis and reporting features not available in other project management software tools.

This project management training course is a fast-paced, hands-on workshop. Guided by an expert instructor, you’ll leave this project management training course with the real-world experience you need to fully harness the powerful tools Excel has to offer back in your workplace.

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