• Whatsapp
  • Instagram
  • Facebook
  • Twitter
  • LinkedIn
  • YouTube

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.

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

Microsoft Excel in Project Management Course

Program fees

USD 872

To register, please click on the tab below, or for further assistance get in touch with us on info@iti.ae , or give us a call at 8004852

© 2022 by INTERNATIONAL TRAINING INSTITUTE. DUBAI, KNOWLEDGE PARK