SPECIALISTS IN FINANCIAL MODELLING
0 item(s) $0.00 AUD + GST

Introduction to Financial Modelling in Excel (Online)

This course is part of the Financial Modelling Online Series:

Buy all three courses at once and save, PLUS you'll get a hard copy of Using Excel for Business Analysis included!  Or, get this course included if you sign up for the Financial Modelling Workshop bundle.

Learning Objectives

This course introduces the fundamentals and introductory concepts of building a financial model using Excel. During this practical course in which you will develop the skills to build your own financial model which can be taken away for future reference. You will learn first principles of modelling techniques, best practice and how to design and create a user-friendly model.

Prerequisites

Who should complete this course? Those who:

  • Are new to Financial Modelling and its concepts, and;
  • Have a basic knowledge of Excel

It is assumed that you have either undertaken a basic Excel Introduction course, or else are able to:

  • Navigate in Excel
  • Use absolute cell references (this is covered in the course in case you are a bit rusty!)
  • Create and use simple formulas

It is also assumed that you have had some exposure to financial concepts, but limited experience in Financial Modelling.

More detail about how the online courses work

What does the course content look like?

If you'd like to see a full 15 min preview of one of the videos, together with dowloadable Excel files and transcript, take a  look at the Excel Versions section.

For a shorter overview, watch here for a 60 second preview:

Modules in this Course

1.1 Financial Modelling Introduction
  • What is Financial Modelling?
  • Model Design
  • Excel Versions 2013
  • What's New in Excel 2016 *New*
  • Overview of Scenario Analysis Methods
  • Common Excel Error Values
1.2 Fundamental Excel Tools
  • Linking for Best Practice
  • Absolute, Relative and Mixed Cell Referencing
  • Calculating Project Costs
  • Logical Nested Functions
  • Assumptions Documentation Methods
1.3 Building a Financial Model
  • Model Build - Inputs & Assumptions
  • Model Build - Revenue
  • Model Build - Expenses
  • Model Build – Profit & Loss
  • Model Build - Cashflow
1.4 Model Analysis Tools
  • Bullet-Proofing your Model
  • Data Validations & Drop-downs
  • Conditional Formatting
  • Model Build - Charting Cash vs Profit
  • Model Build - Modelling Scenarios

Price: $220.00 ex GST

Buy Now Please check the box to confirm you agree before proceeding.