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 blue lines (s) joins the precedent cell (indicated with a blue dot) and the cells which are immediately dependent on it (indicated with an arrow); in this case, there is only one dependent i.e. cell C5, and hence only one line.

Similarly, one could trace the precedents of cell C5 by first selecting the cell and then clicking on the Trace Precedents icon, which would give the following:

Note that since there are two precedents, there are two blue lines which overlap. The blue dots indicate the immediate precedents.

These techniques are very important to follow and check the logic of models and the calculations.

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!