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.

BENEFITS OF THIS HANDS-ON AND INSIGHTFUL TRAINING (OUTCOMES):

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)

TARGET GROUPS:

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

Name *

Mobile Number *

Email *

Name of Organization

Designation

Reservation Details *

• Corporate
• Individual

Select the Program *

• Big Data Analytics using Advanced Ms. Excel– Basic | Intermediate | Advanced Excel
• Data Visualization & Interactive KPIs Dashboards Using Ms. Power BI
• New Manager Induction Program (Includes HR Skills For Non-HR Managers)
• Applied Human Capital Modelling and HR Analytics
• Selling Skills -The Art of Pitching (Pitch to Pay paradigm)
• Data Led Professional Bootcamp (Virtual | 10 weeks certified program)
• HR Budgeting
• Palladium XPP Balanced Scorecard Masterclass (Strategy Execution and Performance Management)
• Effective Business Communication and Presentation Skills
• Certified Data Led & Innovation Driven Manager (3-month certification Bootcamp)
• Workshop 3 days HR Skills for non – HR Managers
• Emotional Intelligence Masterclass
• Customer Experience Excellence Masterclass
• Financial Modelling Masterclass
• The Data & Innovation Driven Manager – An Evidence – Based Blackbelt Manager
• Sales Leadership Training and Coaching
• Choice 22

Register