Introduction to Financial Modelling

Principles of Excel as a Modelling Tool

Chapter 2: Excel Foundations

8 Topics | 1 Quiz
Chapter 3: Using Sensitivity Analysis

10 Topics | 1 Quiz
Chapter 4: Core Operations and Shortcuts

7 Topics | 1 Quiz
Common Modeling Structures (I)

Chapter 5: Common Structures in Financial Models (I)

7 Topics | 2 Quizzes
Further Operations and Shortcuts

Chapter 7: Formatting, Presentation and Graphs

7 Topics | 1 Quiz
Excel Functions (I): Information and Numerical Aggregation

Excel Functions (II): Conditionality, Aggregations and Arrays

Chapter 11: Logic and Conditionality

7 Topics
Chapter 12: Conditional Aggregation

4 Topics | 1 Quiz
Chapter 13: Array Functions and Dynamic Arrays

5 Topics | 1 Quiz
Common Modelling Structures (II)

Excel Functions (II): Lookups and Referencing

Chapter 15: MATCH and XMATCH

5 Topics
Chapter 16: CHOOSE and SWITCH

6 Topics
Chapter 17: INDEX and XLOOKUPs

6 Topics | 1 Quiz
Model Planning and Best Practices

Chapter 18: Model Planning

11 Topics
CUTZ or ... intrducton to rest of program....and clisoing remarks

(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 colored as if they are outputs only.)

The corresponding model in Excel could be:

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!