Introduction to Financial Modelling

Principles of Excel as a Modelling Tool

Chapter 2: Excel Foundations

8 Topics | 1 Quiz
Chapter 3: Sensitivity Analysis

10 Topics | 1 Quiz
Excel Operations, Structures and Short-Cuts

Chapter 4: Operations and Short-cuts (I)

6 Topics | 1 Quiz
Chapter 5: Common Structures within Financial Models (I) – Arithmetic Based

7 Topics | 2 Quizzes
Chapter 6: Operations and Short-cuts (II)

15 Topics | 1 Quiz
Introduction to Excel Functions

Chapter 10: Dynamic Arrays and Array Functions

4 Topics | 1 Quiz
Applications of Lookup and Reference Functions

Chapter 14: INDEX and XLOOKUPs

5 Topics | 1 Quiz
Planning and Building Models for Optimal Decision Making

Chapter 17: From Planning to Practice

16 Topics
(The colour-coding used here is one where items used only for intermediate calculations are shaded white, with inputs blue, and outputs in green. Some intermediate calculations may also be outputs – such as Sales Revenue – and these are coloured as outputs only.)

One could build a corresponding model in Excel, such as the following:

This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy

Scroll to Top
error: **Alert:** Content is protected !!

Login

Accessing this course requires a login. Please enter your credentials below!