Excel & spreadsheet mastery

Data Science, Digital M&E & AI · 5 Days

Course Overview

Excel and spreadsheet mastery remains one of the highest-value practical skills for NGO staff across finance, MEAL, and programme functions, enabling faster and more reliable data work. This hands-on course builds advanced practical Excel and spreadsheet skills through extensive practice. Participants work hands-on with Excel throughout the course, building skills from intermediate formulas through advanced data analysis techniques.

Who Should Attend

  • Finance and Budget Officers
  • MEAL and Data Officers
  • Programme Staff managing spreadsheet-based data
  • Administrative Staff seeking stronger Excel skills
  • Staff preparing for data-intensive roles

Learning Objectives

  • Apply intermediate and advanced Excel formulas confidently
  • Organize and clean data efficiently within spreadsheets
  • Build pivot tables and summary reports
  • Create clear charts and visualizations in Excel
  • Use lookup and reference functions effectively
  • Automate repetitive spreadsheet tasks
  • Sustain advanced Excel skills over time

Key Takeaways

Course Curriculum

1

Foundations of Excel Mastery

2

Applying Intermediate Formulas

3

Using Lookup and Reference Functions

4

Organizing and Cleaning Data

5

Building Pivot Tables

6

Creating Charts and Visualizations

7

Automating Spreadsheet Tasks

8

Sustaining Advanced Excel Practice

Requirements

Basic familiarity with spreadsheets is required.

Certification

Participants who successfully complete this course will receive a Certificate of Completion from EcoTrio Impact Growth and Development Centre (EIGDC), recognizing their attainment of the knowledge and skills covered in the programme.

Frequently Asked Questions

Do I need prior experience to attend this course?

Basic familiarity with spreadsheets is required.

Will I receive a certificate upon completion?

Participants who successfully complete this course will receive a Certificate of Completion from EcoTrio Impact Growth and Development Centre (EIGDC), recognizing their attainment of the knowledge and skills covered in the programme.

Can this training be delivered on-site for our organisation?

Yes. Ecotrio Impact Growth and Development Centre (EIGDC) offers a bespoke in-house delivery option for Excel & spreadsheet mastery, tailored to your organisation's context within Data Science, Digital M&E & AI. Contact our training team to discuss customisation, scheduling and group pricing.

Is this course available online for remote participants?

Yes. Selected cohorts of this course are available as live virtual sessions delivered over video conferencing by an experienced facilitator, with the same certificate issued on completion as the in-person format.

What practical skills will I gain from this course?

By the end of this course, you will be able to apply intermediate and advanced Excel formulas confidently, organize and clean data efficiently within spreadsheets, build pivot tables and summary reports, create clear charts and visualizations in Excel, use lookup and reference functions effectively, automate repetitive spreadsheet tasks, and sustain advanced Excel skills over time. The programme is designed to be immediately applicable to your day-to-day role.

Upcoming Sessions

LocationDatesMode
Johannesburg, South Africa 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Pretoria, South Africa 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Nairobi, Kenya 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Kampala, Uganda 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Mombasa, Kenya 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Live Virtual 16 Nov 2026 – 20 Nov 2026 Online Register →
Zanzibar, Tanzania 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Accra, Ghana 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Cape Town, South Africa 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Dubai, United Arab Emirates 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Dar es Salaam, Tanzania 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Kigali, Rwanda 23 Nov 2026 – 27 Nov 2026 Classroom Register →

Ready to Register for Excel & spreadsheet mastery?

See full pricing, exact upcoming dates across South Africa, Kenya, Uganda, and secure your seat online in minutes.

Book This Training →