Search
Generic filters
Topics
Certifications
Industries
Using Excel in Project Management
overview

This 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. Every student will be provided with a computer running Excel. 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 details
COURSE DURATIONLANGUAGECERTIFICATE
2 DaysEnglishDISS Certificate
 *Please notify us if an interpretation is required 
course benefits/progression opportunities
Course objectives

At the end of this course, the candidates will be able to:

This course allows the delegate to experience the power of Excel 2016 in Project Management

course outline
Day 1Day 2

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 solver tool to optimize calculations and forecasts
  • Forecasting the future by 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
Course methodology

The format of the Two-day workshop is a series of brief lectures followed by discussion and hands-on exercises. Case studies and real-life examples are used to illustrate success and failure

COURSE TYPE: CLASSROOM
DATETIME
4 Oct 20208:00 – 14:00 (QATAR)
 9:00 – 15:00 (OMAN)

 

TESTIMONIAL

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

Person name

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

Person name

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

Person name
Meet THE INSTRUCTORS
instructor
Instructor Name
Profession

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

instructor2
Instructor Name
Profession

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Related Courses