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 Outline
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 Modules
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.
Related Courses
Course Administration Details
Methodology
These instructor-led training sessions are delivered using a blended learning approach and include presentations, guided practical exercises, web-based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience as professionals and trainers in these fields. All facilitation and course materials are offered in English. Participants should be reasonably proficient in the language.
Accreditation
Upon successful completion of this training, participants will be issued 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 to their travel expenses, visa application, insurance, and other personal expenses.
Accommodation and Airport Transfer
Accommodation and Airport Transfer are arranged upon request. For reservations contact the Training Officer.
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:
Payment
Payment should be transferred to the IRES account through a bank on or before the start of the course. Send proof of payment to [email protected]
Click here to register for this course.
Register NowCustomized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Customize AttendanceDo you need more information on our courses? Talk to us.
