Skip to content

KapitalBiz Consulting Course

Advanced Financial Modelling in Excel

Share
Financial modeling plays an integral part in business decision making. This Advanced Financial Modelling Course will strengthen your ability to create well-structured and efficiently built models. It’s a 3 day hands-on practical course designed for delegates wishing to enhance their capacity to build a variety of comprehensive and complex financial models as well as solve other common modelling problems.

The course consists of a solid principle-based grounding, followed by a wealth of practical examples, case studies and exercises. The exercises can either be done on Excel or manually, and will form a portfolio of examples to which delegates can refer back to.

The focus is on time-savers and other techniques which will improve the quality of your financial models.

Local Fee R 17,999

International Fee $ 1,300

What it’s all about

Why you should attend

▪ Cleaning of data
▪ Solver, Goal Seek
▪ Sensitivity Analysis (Two-Variable Data Tables)
▪ Scenario Planning
▪ Scroll Bars and Spin Buttons

▪ Gauge Charts and other charts
▪ Lookup functions (Index, Match, Offset)
▪ Information functions and Text functions
▪ Financial functions (IPMT, PPMT, XNPV, XIRR)
▪ Data validation and protection

▪ Gauge Charts and other charts
▪ Lookup functions (Index, Match, Offset)
▪ Information functions and Text functions
▪ Financial functions (IPMT, PPMT, XNPV, XIRR)
▪ Data validation and protection

Ideal Participants for This Program

Who should attend

This 3-day training course is specifically designed for:

  • CFOs, Finance Directors, Financial Controllers
  • Finance Managers, Financial Analysts
  • Business Analysts, Data Analysts, Business Intelligence Managers
  • Corporate Finance Professionals, Investment Professionals, Corporate Bankers
  • Any general users of Excel for financial applications & Executives handling large datasets

Book Your Spot

Advanced Financial Modelling in Excel

Recommended Courses

Project Portfolio Management

3 – 6 June

NH Hotel Sandton / Live Online

Predictive Maintenance & Reliability Course

12 – 14 June

Live Online Training

Finance for Engineers & Technical Managers

24 – 26 April

Live Online Training