KapitalBiz Consulting Course
Advanced Financial Modelling in Excel
- Date 17 – 19 April
- Format Live Online Training
- 14 Lessons
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.
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

Predictive Maintenance & Reliability Course
12 – 14 June
Live Online Training
Share

Finance for Engineers & Technical Managers
24 – 26 April
Live Online Training
Share