Skip to main content
Ideal Workplace Solutions
NITA AccreditedAdvancedPhysical + Virtual5 daysTOAE417

Training on Advanced Excel for Project and Programme Managers in the Public Sector

Learn advanced Excel techniques for data analysis, visualization, and automation in project management.

Next intake

20 Jul 2026 · Nakuru

View all dates

Duration

5 days

Live instruction

Delivery

Physical + Virtual

Cohort based

Level

Advanced

Working professionals

Certification

NITA reimbursable

For Kenyan cohorts

Language

English

All materials

Overview

About this programme

This course equips project and programme managers with advanced Excel skills to effectively plan, monitor, and report on public sector projects. Participants will learn how to use Excel as a dynamic tool for data management, project tracking, financial analysis, and performance monitoring. The course emphasizes automation, visualization, and data-driven decision-making aligned with public accountability and transparency standards.

Duration

5 Days

Who Should Attend

  • Project and Programme Managers in the public sector

  • M&E and Planning Officers

  • Data Analysts and Financial Officers

  • Government officials involved in project tracking and reporting

Learning outcomes

What you'll walk away with

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

  • Use advanced Excel tools for project planning, scheduling, and resource allocation.

  • Analyze and visualize performance indicators using pivot tables and dashboards.

  • Apply financial and risk management formulas for public projects.

  • Automate repetitive tasks using Excel macros and conditional logic.

  • Create professional project reports that meet public sector standards.

Course modules

What we cover, module by module

Module 1: Advanced Data Management for Project Tracking

  • Structuring and cleaning project data for analysis.

  • Using data validation, lookup functions, and conditional formatting.

  • Integrating multiple project datasets into one analytical file.

  • Case Study: Streamlining project reporting through structured data systems.

Module 2: Advanced Formulas and Functions for Project Analysis

  • Applying nested formulas and logical functions (IF, AND, OR).

  • Using financial and statistical functions for performance monitoring.

  • Automating calculations for budgets, timelines, and KPIs.

  • Case Study: Automating budget variance analysis for a public development program.

Module 3: Data Visualization and Dashboard Development

  • Creating dynamic dashboards with PivotTables, charts, and slicers.

  • Designing visual reports for project performance and funding utilization.

  • Best practices for data storytelling and executive presentations.

  • Case Study: Building interactive dashboards for project progress tracking.

Module 4: Automation and Advanced Tools for Efficiency

  • Introduction to Macros and Visual Basic for Applications (VBA).

  • Automating routine reporting and data consolidation.

  • Scenario and sensitivity analysis for project forecasting.

  • Case Study: Automating monthly reporting templates for a donor-funded initiative.

Module 5: Reporting and Decision Support in the Public Sector

  • Creating standardized project monitoring and evaluation reports.

  • Linking Excel data with Power BI and external databases.

  • Ensuring data integrity, security, and compliance.

  • Case Study: Leveraging Excel for decision support in a multi-agency infrastructure project.

Impact

Where the change lands

Organizational Impact

  • Enhances efficiency and transparency in project reporting.

  • Promotes evidence-based decision-making and accountability.

  • Improves project financial and performance monitoring processes.

Individual Impact

  • Builds advanced Excel skills for data analysis and project management.

  • Increases confidence in using automation tools for reporting.

  • Enhances accuracy, efficiency, and professionalism in project documentation.

Dates and locations

Upcoming intakes

Every intake is limited to a small cohort. Booking closes when a date fills or three weeks before the start, whichever comes first.

Full calendar
FAQs

Common questions.

Still not sure? Send us a note and a facilitator will get back to you within a business day.

Project and programme managers, planners, and analysts working in the public sector.

Related programmes

You may also like.

Programmes in the same discipline that participants often pair with this course.

Browse the full catalogue
Hybrid5 days
Training Courses
Training on Advanced Project Management Techniques

Master advanced project management techniques. Learn to apply advanced project management methodologies, tools, and techniques to optimize project performance and achieve exceptional results.

Multiple citiesOpen enrolment
FromOn request
View course
Hybrid5 days
Training Courses
Training on Advanced Project Risk Management

Master Change Management for Project Managers. Learn to effectively manage change, minimize disruption, and ensure successful project implementation. Understand change management methodologies, communication strategies, and stakeholder engagement techniques.

Multiple citiesOpen enrolment
FromOn request
View course
Hybrid5 days
Training Courses
Training on Advanced Trello Techniques for Project Managers

Enhance your project management strategy with advanced Trello techniques—automate workflows, track performance, and drive team productivity.

Multiple citiesOpen enrolment
FromOn request
View course

Course finder

Find the right course for you

Prefer to talk it through? Send us an enquiry and a facilitator will scope a fit within a business day.

For corporate teams

Training 10+ professionals?

We deliver Training on Advanced Excel for Project and Programme Managers in the Public Sector in-house at your offices, at a venue we arrange, or fully virtual. Customise the curriculum against your KPIs, and get a bespoke price for the cohort size you need.

Request a corporate quoteDownload brochure