Introduction

Excel for Projects Managers training seminar will help project managers and analysts save a substantial amount of time in their project management activities, learn better solutions to their existing problems and help them plan more effectively. This course aims to equip Project and Program Managers with the necessary skills to execute projects effectively and successfully.

Duration:

10 days

Who should take this course:

• Project team leaders in government projects

• project management staff

• Team leaders

• Project Sponsors

• Managers of Project Portfolios

COURSE LEVEL: Advanced

Course Objectives

Excel for project managers course is divided in three main modules, Planning & Budgeting, Tracking, and Reporting. It will systematically teach you how to tackle the different problems involved in project management with the help of real-life case studies.

WHY EXCEL FOR PROJECT MANAGERS :

• Highly required for Project Managers across the world involved in Planning, Estimation, Budgeting, Tracking and Reporting
• Learn systematically to forecast time and cost to complete a project
• Start from the basics of finance and learn different measures that help project managers understand when a project would become profitable
• Learn how to create effective Dashboards which will eventually help you track your project on real time
• Learn how to implement scenario analysis
• Will understand and create models based on Earned Value Management
• You will learn how to effectively implement planning, tracking and reporting
• Learn Advanced concepts like Monte Carlo Simulation

Course Outline

Module 1: Introduction to Advanced Excel

• Understand various shortcuts in Advanced Excel

• Understanding data presentation using charts

• Understanding data analysis using Pivot tables and charts

• Sorting and filtering data and understanding references in Advanced excel

• Working with dates in Excel

Module 2: Formulas in Excel

• Understanding various advanced logical formulas in excel

• Working with text and lookup formulas in excel

• Working with various Macros and VBA for programming

Module 3: Schedule and Cost-planning skills using excel

• Understanding the skills of projects and programme estimation based on scope

• Understanding how to use Excel for deriving Time-limited Schedules and Cost-limited plans

• Using Excel to measure project Schedule and the cost performance in various models

• Using Excel to analyse schedules, the cost variances and their impacts

• Understand how to come up with reactive methods to manage schedules and cost impacts

• Learn how to track, analyze and report issues in a project using Excel

Module 4: Risk Management using Excel

• How to identify and manage risks

• Qualitative Assessment and analysis of project risks using probability and impact scales, Assumption testing and cognitive bias

• Quantitative assessment and analysis of project risks using Monte Carlo simulation, decision trees, PERT Analysis and EMV

• Learn how to come up with risk response strategies

• Use Excel to monitor and control project risks

Module 5: Creation of Dashboards and reports in Advanced Excel

• Understanding how to write SMART objectives, Business care and knowing the best practices to apply in both project and programme management.

• Learn how to create Gnatt charts, milestones and events.

• Understand how to create various durations based on given timelines

• Understand how to create the dynamic excel Gnatt charts Dashboard for reports.

• Learn how to Baseline bars, Actual progress bar and know how to track project progress

• Learn how to use KPI’s, Issue and Risks for communication.

Course Administration Details:

REQUIREMENTS

Participants should be reasonably proficient in English. Applicants must live up to Indepth Research Institute (IRES) admission criteria.

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).

TRAINING VENUE

The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION AND AIRPORT PICKUP

Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.

Email: [email protected] / [email protected]

Mob: +250789621067 or +254 715 077 817

TAILOR-MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +250 789 621 067, +254 715 077 817 or mail [email protected] / [email protected]

PAYMENT

Payment should be transferred to IRES account through bank before the course start date

Send proof of payment to [email protected] / [email protected]

DOWNLOADABLE DOCUMENTS: