Advanced Excel Formulas and Functions Training

Finance, Grants, Compliance & Risk · 5 Days

Course Overview

Most Excel users rely on a small set of functions. Modern formulas can replace hours of manual work. This course covers lookups, logic, dynamic arrays, text and date functions, financial functions, LAMBDA and error handling. Participants solve realistic business problems with formulas.

Who Should Attend

  • Accountants
  • Finance Analysts
  • Administrators
  • HR Officers
  • Procurement Officers
  • Data Officers

Learning Objectives

  • Write advanced logic formulas
  • Use XLOOKUP and INDEX-MATCH
  • Apply dynamic arrays
  • Handle text and dates
  • Summarise with conditional functions
  • Use financial functions
  • Create LAMBDA functions
  • Audit formulas

Key Takeaways

Course Curriculum

1

Formula Foundations

2

Logic Functions

3

Lookup Functions

4

Conditional Summaries

5

Dynamic Arrays

6

Text and Dates

7

Financial Functions

8

LAMBDA and Formula Auditing

Requirements

Participants should have basic Excel skills.

Certification

Participants who complete the Advanced Excel Formulas and Functions Training receive an Ecotrio Certificate of Completion, awarded by Ecotrio Impact Growth and Development Centre (EIGDC) and recognized by employers across the region as evidence of applied, job-ready competence.

Upcoming Sessions

LocationDatesMode
Kigali, Rwanda 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Cairo, Egypt 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Dar es Salaam, Tanzania 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Dubai, United Arab Emirates 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Cape Town, South Africa 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Accra, Ghana 16 Nov 2026 – 20 Nov 2026 Classroom Register →
Live Virtual 23 Nov 2026 – 27 Nov 2026 Online Register →
Zanzibar, Tanzania 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Pretoria, South Africa 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Mombasa, Kenya 23 Nov 2026 – 27 Nov 2026 Classroom Register →
Mombasa, Kenya 07 Dec 2026 – 11 Dec 2026 Classroom Register →
Pretoria, South Africa 07 Dec 2026 – 11 Dec 2026 Classroom Register →

Ready to Register for Advanced Excel Formulas and Functions Training?

See full pricing, exact upcoming dates across Rwanda, Egypt, Tanzania, and secure your seat online in minutes.

Book This Training →