Skip to content

Advanced Excel and Financial Modelling for Treasury Professionals

Treasury and tax teams frequently build cash flow, valuation and scenario models under time pressure using fragile spreadsheets that break the moment assumptions change. This hands on course builds structured financial models for treasury and tax decision making, covering formula discipline, scenario switches, sensitivity tables and error checking so models hold up under scrutiny.

What you will be able to do

  • Structure a financial model with clear separation of inputs, calculations and outputs.
  • Build scenario and sensitivity switches that let users stress test key assumptions.
  • Apply lookup, array and financial functions correctly in treasury and tax models.
  • Build error checks and audit trails that catch mistakes before they reach management.
  • Design dashboards that summarise model outputs for non technical stakeholders.
  • Apply version control and documentation discipline to shared financial models.

Course outline

  1. 01Model structure and design principles
  2. 02Formula discipline and best practice
  3. 03Scenario and sensitivity switches
  4. 04Lookup and array functions for finance
  5. 05Building error checks and audit trails
  6. 06Dashboards for non technical stakeholders
  7. 07Version control for shared models
  8. 08Common modelling mistakes to avoid

Who should attend

Treasury analysts, tax analysts, financial modellers and finance professionals who build or rely on Excel based financial models.

Dates, venues and fees

DatesVenueDaysFeeCalendar
17 to 21 Aug 2026Mozambique5US$1,800
24 to 28 Aug 2026Cairo5US$1,800
31 Aug to 4 Sep 2026Accra5US$1,800
7 to 11 Sep 2026Lusaka5US$1,800
14 to 18 Sep 2026Kigali5US$1,800
21 to 25 Sep 2026Nairobi5US$1,800
28 Sep to 2 Oct 2026Durban5R18,000
5 to 9 Oct 2026Johannesburg5R18,000
19 to 23 Oct 2026Mauritius5US$1,800
26 to 30 Oct 2026Dubai5US$1,800
2 to 6 Nov 2026Lagos5US$1,800
9 to 13 Nov 2026Harare5US$1,800
16 to 20 Nov 2026Kampala5US$1,800
23 to 27 Nov 2026Dar es Salaam5US$1,800
30 Nov to 4 Dec 2026Pretoria5R18,000
7 to 11 Dec 2026Cape Town5R18,000
21 to 25 Dec 2026Online5US$900

Fees are per delegate. South African venues are priced in rand; other locations and online in US dollars. Fees exclude 15% VAT where applicable. Group bookings of three or more delegates from the same organisation qualify for a reduced rate; contact us for a quotation.

Related courses in Tax, Treasury and Banking

Tax, Treasury and Banking

Value Added Tax Compliance and Control

Most assessments arise from ordinary administration: input tax claimed without a valid tax invoice, output tax missed on a disposal, or an...

Next session
31 Aug to 2 Sep 2026
Venue
Dubai
3 day programme
FromUS$900
Tax, Treasury and Banking

Payroll Taxes and Employees Tax Administration

Payroll sits where employment law, benefits and tax collection meet, and errors repeat every month until someone finds them. Employees tax...

Next session
31 Aug to 1 Sep 2026
Venue
Johannesburg
2 day programme
FromUS$900
Tax, Treasury and Banking

Corporate Income Tax Fundamentals

Accounting profit and taxable income are rarely the same number, and the difference has to be explained line by line. Delegates follow the...

Next session
31 Aug to 2 Sep 2026
Venue
Kigali
3 day programme
FromUS$900
See all Tax, Treasury and Banking courses