Introduction to Financial Modelling Best Practice

Gain inside knowledge of the key factors critical to financial modellers – from an expert financial modeller!
4.0 (42 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,346 students enrolled
Free
Start Learning Now
  • Lectures 9
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course 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.

What are the requirements?

  • Student should have some financial awareness, either be working or studying in Finance and an interest in Excel and Financial Modelling of coure.

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Documenting Assumptions
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!

Section 2: Linking Cells to Source Data
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.

Section 3: Only Enter Data Once
Only Enter Data Once
01:52
Section 4: Bad Habits
Bad Habits
03:40
Section 5: Consistent Formulas
Consistent Formulas
01:54
Section 6: Formatting & Labelling
Formatting & Labelling
02:32
Section 7: Summary
Summary
02:53
Section 8: Bonus Content - Scenario Tools in Excel
17:27

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.

13:36

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Danielle Stein Fairhurst, 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

Ready to start learning?
Start Learning Now