About Course

Financial Modelling Using Advanced Excel Training- Kenya

Category: Data Management and Analysis Training

Overview

The Expedition

The Financial Modelling Using Advanced Excel Training equips professionals with the skills to develop accurate, dynamic, and robust financial models for real-world decision-making. Through practical exercises and case-based learning, participants will master essential Excel tools to organize data, build models, conduct scenario analysis, and produce insightful reports. Whether you’re involved in budgeting, forecasting, valuation, or strategic planning, this course strengthens your ability to translate data into actionable insights using Excel.

This training is available both in person and online, providing flexibility to suit your schedule. Participants will receive a certificate of completion to validate their expertise in advanced Excel-based financial modeling.

Problem Objectives

By the end of this Financial Modelling Using Advanced Excel Training, participants will be able to:

Apply absolute, relative, and structured referencing effectively in financial modeling.
Organize and analyze data using structured Excel tables.
Use key Excel functions, including financial, logical, and lookup functions, for data-driven decisions.
Perform scenario and sensitivity analysis using Goal Seek, Solver, and Scenario Manager.
Import, validate, and consolidate data efficiently from various sources.
Create and manage links across worksheets and workbooks to streamline reporting.
Export and present data using appropriate formats and linked visuals.

Target Audience

This course is suitable for:

Finance professionals
Business and strategy analysts
Accountants and consultants
Entrepreneurs and start-up founders
Real estate professionals
Project managers
Students and graduates in finance-related fields

Training Period

Classroom: 5 Days
Online: 7 Days

Training Modules

1: Referencing in Excel

Absolute referencing.
Relative referencing.
Structured reference.

2: Working with Structured Tables.

Benefits of using tables in Excel
Elements of an Excel table
Managing and navigating data tables
Structured references with Excel tables

3: Formulas and Functions.

Overview of Excel functions
Math and Trigonometry functions
Financial and logical functions
Using AND, OR, and nested functions
Lookup functions (VLOOKUP, HLOOKUP)
Concatenation and advanced referencing (INDEX, OFFSET, MATCH)
Using Excel Help for functions

4: Goal Seek/Solver/Scenarios and Linking.

Using Goal Seek and Solver tools
Creating and managing scenarios
Generating Solver reports
Linking worksheets and workbook

5: Working with Data.

Data validation and consolidation
Importing data and CSV files
Using the Text Import Wizard
Exporting data to various formats
Exporting to Word and linking pasted content
Linking and copying graphs with data updates

Delivery Method

The training blends theoretical learning with hands-on exercises, group work, and real-life case studies. Participants receive training manuals and supplementary reference materials.