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.

Ready to book? Secure your place on this programme.

Register for this course

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

DatesVenueDaysFeeCalendarRegister
28 Sep to 2 Oct 2026Durban5R18,000Closed
5 to 9 Oct 2026Pretoria5R18,000Register
12 to 16 Oct 2026Nairobi5US$1,800Register
19 to 23 Oct 2026Dar es Salaam5US$1,800Register
26 to 30 Oct 2026Lusaka5US$1,800Register
2 to 6 Nov 2026Harare5US$1,800Register
9 to 13 Nov 2026Accra5US$1,800Register
16 to 20 Nov 2026Lagos5US$1,800Register
23 to 27 Nov 2026Dubai5US$1,800Register
30 Nov to 4 Dec 2026Johannesburg5R18,000Register
7 to 11 Dec 2026Cape Town5R18,000Register

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...

Next session
29 Sep to 1 Oct 2026
Venue
Harare
3 day programme
FromR13,000
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.

Next session
29 to 30 Sep 2026
Venue
Dubai
2 day programme
FromR10,000
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.

Next session
29 Sep to 1 Oct 2026
Venue
Mbabane
3 day programme
FromR13,000
See all Tax, Treasury and Banking courses