Advanced Excel for Project and Programme Managers in the Public Sector Course

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.

• Project team leaders in government projects

• project management staff

• Team leaders

• Project Sponsors

• Managers of Project Portfolios

Prior knowledge in Project Management is an added advantage but not mandatory. Participants should be proficient in English.

5 Days

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.

At the end of the course, participants will be able to:   

• 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 Content:

 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.

This instructor led training course is 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.

Upon successful completion of this training, participants will be issued with acertificate of participation.

The training is residential and will be held at the Livecode Technologies Training Center in Westlands, Nairobi, Kenya. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

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

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Mobile Number: +254 725 771 853

The course fee is KES 70,000.00 or USD 1,000.00 exclusive of VAT. The course fees covers the course tuition, training materials, two (2) break refreshments, lunch and study visits. Participants will cater for their travel and accommodation costs.

Organizations who send more than three participants automatically qualify for a 10% discount.

Payment should be transferred to Livecode Technologies account through bank on or before the course commences.

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it.

Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

This scheduled course can also be tailored for your organization. To find out how our tailor-made training can help your organization, contact our team on:

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Mobile Number: +254 725 771 853