Advanced Excel for Project and Programme Managers

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

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.