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 is a rich set of operations that can be performed in Excel. Many of these are found on the toolbar menu. The operations are grouped into various toolbar tabs. Some of tabs are shown by default when opening Excel; the image below shows the main menu items for a fairly standard toolbar.

The menus within each tab are discussed in detail during the courses, at the relevant point. For the moment, it is simply worth noting some of the most fundamental points that are more relevant from the point of view of getting started with modelling in Excel.

The Home tab (shown in the image below) contains many of the most standard and frequently required operations, such as those required to copy formula or to format cells, or insert rows and columns between existing used cells:

The File tab contains a menu of frequently needed operations relevant to the whole workbook, such as to open, close or save the workbook file. The File menu also allows one to exposing other menu tabs that maybe hidden in the default view default. For example, the image above shows the Developer tab, which is needed when using VBA macros. Such additional tabs can be exposed using the menu sequence File->Options->CustomizeRibbons.

The Formulas tab allows one to create, inspect and work with formulas.

In the image below, the “Show Formulas” icon for the Formulas tab has been selected. This toggles with user’s view of the worksheet so that any formulas can be directly seen (rather than one seeing the numerical result of the formulas):

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!