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
There are 1048576 rows and 16384 columns. Therefore the cell addresses start with A1 in the top-left and finish with XFD1048576 in the bottom-right.

In fact, the number of rows is 2-to-the-power-of-20, whilst the number of columns is 2-to-the-power-of-14. The last column is XFD (no ZZZ, for example): The letters A-Z constitute 26 columns, AA to ZZ provide 676 (26 times 26) , and AAA to WZZ provide 15548 (23 times 26 times 26). The remaining 134 columns are provided by the letter combinations XAA to XFD. (Prior to Excel 2007, there were only 65536 rows and 256 columns, so the total grid area of modern Excel is over 1000 times larger than in those legacy versions).

However, it can be convenient to use multiple worksheets, especially when each contains data sets that need to be linked to other sources in order to update them.

To add a new worksheet, one can click on the + button, resulting in:

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!