Wishlisted Wishlist

Please confirm that you want to add Introduction to Financial Modelling Best Practice to your Wishlist.

Add to Wishlist

Introduction to Financial Modelling Best Practice

Gain inside knowledge of the key factors critical to financial modellers – from an expert financial modeller!
3.6 (52 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,676 students enrolled
Last updated 4/2016
English
Free
Includes:
  • 1 hour on-demand video
  • 20 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Description

If you're new to the modelling process, gain inside knowledge of the key factors critical to expert financial modellers.  Each short segment provides an overview of the key principles and best practice for Financial Modelling in Excel on a daily basis.

  • Assumptions Documentation

    Documentation of assumptions is a critical point of best practice. Garbage in and garbage out!

  • Linking Formulas vs "hard-coded" Values

    Every input should have a single source cell in our model, so that any changes that are made flow right throughout the model.

  • Bad Modelling Habits

    It’s pretty easy to pick up Bad Habits. We'll look at a few bad modelling habits that are pretty common among Excel users!

  • Formula Consistency

    Consistent formulas within a block of data will make building your model quicker and easier, not to mention more accurate

  • Clear Formatting and Labelling

    Having your model’s Formatting and Labelling clearly and correctly laid out makes your model easier to find your way around – both for you and someone else trying to interpret your model!

  • Tips and Tricks
    You'll pick up lot of tips, tricks and shortcuts along the way


In each lecture, I’ll take you through one of the key principles, give practical examples of how to apply best practice to your financial models.  You’ll learn lots of tips and tricks on using Excel for the purpose of financial modelling.  

As an added bonus, you’ll get an extra webinar recording on “Scenario Tools in Excel” which will teach you how to create scenarios in plain Excel without any add-ins or other software. Reduce uncertainty in decision making using built-in standard Excel tools to reduce volatility in outcomes by performing sensitivity and scenario analysis to mitigate risk.

Who is the target audience?
  • If you're new to the modelling process, gain inside knowledge of the key factors critical to expert financial modellers. Each 2-3 minute video provides an overview of the key principals and best practice for Financial Modelling in Excel on a daily basis.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Know the importance of assumptions in modelling. Documentation of assumptions is a critical point of best practice. Garbage in and garbage out!
Understand the difference between linking formulas vs "hard-coded" Values. Every input should have a single source cell in our model, so that any changes that are made flow right throughout the model.
Recognise bad modelling habits It’s pretty easy to pick up Bad Habits. We'll look at a few bad modelling habits that are pretty common among Excel users!
Apply formula consistency. Consistent formulas within a block of data will make building your model quicker and easier, not to mention more accurate
Develop clear formatting and labelling Having your model’s Formatting and Labelling clearly and correctly laid out makes your model easier to find your way around – both for you and someone else trying to interpret your model!
Learn tips and tricks You'll pick up lot of tips, tricks and shortcuts along the way
View Curriculum
Requirements
  • Student should have some financial awareness, either be working or studying in Finance and an interest in Excel and Financial Modelling of coure.
Curriculum For This Course
Expand All 9 Lectures Collapse All 9 Lectures 50:19
+
Documenting Assumptions
1 Lecture 03:25

Welcome to "Introduction to Financial Modelling Best Practice"

This is your first instalment of this series. In each section, we’ll spend a few minutes together covering some important principles and best practices in Financial Modelling.

Today we’ll be talking about one of the most important points in Financial Modelling – Documenting Assumptions.  Enjoy!

Documenting Assumptions
03:25
+
Linking Cells to Source Data
1 Lecture 03:00

It's important to understand the difference between linking formulas vs "hard-coded" Values. Every input should have a single source cell in our model, so that any changes that are made flow right throughout the model.

Linking Cells to Source Data
03:00
+
Only Enter Data Once
1 Lecture 01:52
Only Enter Data Once
01:52
+
Bad Habits
1 Lecture 03:40
Bad Habits
03:40
+
Consistent Formulas
1 Lecture 01:54
Consistent Formulas
01:54
+
Formatting & Labelling
1 Lecture 02:32
Formatting & Labelling
02:32
+
Summary
1 Lecture 02:53
Summary
02:53
+
Bonus Content - Scenario Tools in Excel
2 Lectures 31:03

This lecture how to create scenarios using plain Excel without any add-ins or other software. We cover a practical demonstration of the tools of drop-down boxes for manual scenario selection, data tables and scenario manager.  The files used in the video have been provided for your further learning.

Scenario Tools in Excel - Part 1
17:27

In this video we add probability to data tables, and use goal seek for what-if analysis.

Scenario Tools in Excel - Part 2
13:36
About the Instructor
3.6 Average rating
52 Reviews
3,676 Students
1 Course
Specialist Financial Modelling Training & Presenter

Hi, I'm Danielle Stein Fairhurst and I’ve been a financial modelling for my whole career. I live and breathe Excel – in fact, I even wrote a book about it!  The second edition of  "Using Excel for Business Analysis: a Guide to Financial Modelling Fundamentals" was published in April 2015.

Although I’m based in Sydney, I run regular training seminars around Australia and internationally (mostly Asia and the Middle East) for conference organisers or company in-house training.  I founded the LinkedIn Financial Modelling in Excel Group which now has around 40,000 members, as well as its global networking Modellers’ Meetup groups.

Wherever you are in the world, I want to help you to learn the fundamentals of financial modelling.  I hope to see you either face to face or on my online training soon!

Danielle Stein Fairhurst
MBA, BaIBR, CDAF ACCA

Report Abuse