Loading Events

Financial Modelling Masterclass

Applied Financial Modelling with Advanced Ms.Excel & VBA


The Financial Modeling course is designed for Business and Finance professionals who need to set out a business case, study past performance, and predict future performance using discernible trends, valid assumptions, and management opinions.

In addition, the delegates will be trained on key advanced Excel skills applicable to Financial Modelling and Data Manipulation.

The course will revisit business finance concepts before getting into a deep dive into Advanced Excel formulas, functions, and tools.

Course Objectives:

1. Gain mastery in various Financial Modeling approaches for building business cases and simulation-
based scenarios.

2. Master key Advanced Excel and VBA skills & techniques applied in building interactive and integrated
financial models
3. Gain mastery in predicting business performance and impact on decision-making.


a.) Harnessing your Financial Modelling Skills
b.) Optimize time spent in Data Analysis & Reporting (Productivity)
c.) Improving your day-to-day utilization of Ms. Excel (Efficiency)
d.) Facilitating Informed Decision Making (Worth | Value)
e.) Learn technical skills in developing Simple to Complex Excel-based financial
models (Capacity)
f.) You could be the next “Sort For” Financial Model Guru (Consulting Resource)

g.) Visualize your scenarios using interactive visual intelligence tools for non-technical interpretations simplified for any stakeholder. (Lead influencer)


> Finance Teams
> Investment Analysis
> Accountants
> Business Analysts
> Business Development teams

> Marketing Intelligence Analysts

>Research Team

Summarised Topical Outline

  • Introduction to Financial Modelling
  • Overview of Integrated Financial Models (two models; accounting, securities)
  • Financial Data Analysis Functions (NPV, IRR, PMT)
  • Using Advanced Excel formulas & functions
  • Accounting Model Construction
  • Valuation Models (Dividend Growth Models, Discounted Cash Flows, etc)
  • Securities Portfolio Optimization Model
  • Building economic scenarios and Case Simulations
  • Model debugging, testing, and smoothing

Date: 23rd – 26th September 2024

Venue: Nakuru, Kenya

Investment: Kes. 60,000 (USD 600) (Excl VAT)

For more information call: +254 726 611 805 or Email: info@inquestconsult.com

We wish you a transformational learning experience.


Open chat
Can we help you?