Financial Modeling Basics

by Liam Bastick

5h 02m

Auto
  • HD
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc
Auto
  • HD
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc
Auto
  • HD
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

Overview

Financial modeling in Excel is extremely useful to forecast and make key decisions about your company's performance. This online course is designed for beginners, to give you a solid foundation in the preparation needed before you build a financial model. You will learn the necessary concepts, functions and features required to structure and design your financial model to maximize usability and minimize risk. Examples are provided throughout so that you can apply the practical knowledge you learn through hands-on application in Excel.


Syllabus

Introduction 3m 42s

Introduction and the semantics of what constitutes "best" in "best practice". We consider a good model has four key attributes: Consistency, Robustness, Flexibility, and Transparency.

Watch lesson

CRaFT - Consistency6m 37s

An explanation of the reason models should be consistent, and key elements of a workbook that should be consistent.

CRaFT - Robustness5m 01s

An explanation of why models should be materially free from error.

CRaFT - Flexibility5m 30s

User should consider what inputs should be variable and how they should be able to vary. Example of methods to control how inputs can be varied.

CRaFT - Transparency8m 56s

An explanation of why models must be clear, concise, and fit for the purpose of key decision makers. Modelers should consider the logical flow of a model at the outset as well.

Separation of Inputs + Calculations6m 02s

How to design your model so that it separates the inputs and calculations.

Workbook Structure3m 55s

Go over the elements that should be incorporated into a workbook.

Keyboard Shortcuts3m 49s

A summary of Keyboard Shortcuts.

Layout Tips Part 16m 08s

Layout tips can assist in building a financial model in Excel which is easy to navigate through and understand.

Layout Tips Part 26m 02s

Layout tips for updating workbook names, adding hyperlinks, dates and freezing panes.

Layout Tips Part 36m 03s

General tips and options to change in Excel when laying out a typical worksheet in a financial model.

Layout Tips Part 45m 39s

Layout Tips for using the RANDBETWEEN function to generate random numbers for testing and labelling units.

Layout Tips Part 55m 45s

Formatting tips to improve the look and keep the layout of the template consistent. 

Formats vs. Styles6m 22s

Highlight the difference between formats and styles in Excel, why they are important and when to apply them.

Formats vs. Styles Part 23m 59s

How to import styles into a workbook.

Number Formatting Part 13m 59s

It is important how numerical data is presented in Excel. Learn how to effectively use number formatting.

Number Formatting Part 23m 18s

Understand the coding in Custom Number Formatting.

Number Formatting Part 34m 50s

How to use Custom Number Formatting.

Number Formatting Part 44m 13s

How to use Custom Number Formatting, continued.

Conditional Formatting6m 05s

When to use conditional formatting, and how to effectively apply it.

Layout Tips Part 64m 46s

How to use Work in Progress (WIP) Flagging.

Range Names Part 15m 11s

How to effectively assign and use range names in an Excel worksheet.

Range Names Part 25m 54s

How to use Range Names in a formula.

Range Names Part 35m 46s

How to use Range Names in a formula, continued.

Hyperlinks5m 52s

When and where to use hyperlinks to aid end user navigation.

Data Validation4m 48s

Understand how to restrict what end users type into a cell using Data Validation, with examples of lists and whole numbers.

Data Validation Part 23m 42s

Understand how to restrict what end users type into a cell using Data Validation, with examples of text length and custom validation.

Overall Checks7m 21s

Highlight the situations where checks are useful, and how the different checks fit into 3 categories. Error Checks, Sensitivity Checks, and Alert Checks.

Error Checks6m 13s

How to create a prima facie error check.

Sensitivity Check3m 35s

How to create a sensitivity check and where to use one.

Alert Checks4m 07s

The check that checks for everything else sensitivity and error checks don't.

Watch lesson

Printing and Viewing Tips7m 17s

The steps to take to ensure that the model looks as intended when printed.

Linking Tips7m 28s

The proper habits to adopt when linking cells together, and the reasons why.

Security and Protection5m 24s

The proper steps to take to protect the integrity of the model.

Version Control3m 51s

The naming conventions to adopt and the habits that should be practiced.

Functions Overview5m 02s

An overview of the key functions used for financial modeling in Excel.

IF6m 50s

Illustration and issues with the IF function.

SUM4m 59s

Illustration and issues with the SUM function.

SUMIF7m 58s

Illustration and issues with the SUMIF function.

SUMIFS3m 52s

Illustration and issues with the SUMIFS function.

SUMPRODUCT6m 48s

Illustration and issues with the SUMPRODUCT function.

SUMPRODUCT Part 25m 38s

An advanced example of the use of SUMPRODUCT.

Don't Use HLOOKUP and VLOOKUP5m 31s

Why not to use HLOOKUP and VLOOKUP functions.

INDEX4m 47s

Illustrations of the use of the INDEX function.

MATCH5m 42s

Illustration and issues with the MATCH function.

INDEX MATCH7m 31s

Illustrations of the use of INDEX MATCH.

LOOKUP6m 38s

Illustration and issues with the LOOKUP function.

LOOKUP Part 26m 06s

Illustration and issues with the LOOKUP function continued.

OFFSET7m 02s

Illustration and issues with the OFFSET function.

OFFSET Part 26m 51s

Illustration and issues with the OFFSET function continued.

OFFSET Part 36m 53s

A final look at the illustration and issues with the OFFSET function.

MOD5m 16s

Illustrations and issues with the MOD function.

Watch lesson

EOMONTH5m 41s

Illustrations and issues with the EOMONTH function.

MAX and MIN4m 54s

Illustration and issues with MAX and MIN.

Finale1m 40s

An overview of what we have covered in the Financial Modeling Basics course.


Description

Highlights:

  • 55 practical tutorials.
  • Understand the four key attributes of a good financial model.
  • Useful Excel keyboard shortcuts to speed up your modeling.
  • Layout tips to make your model easy to navigate through and understand.
  • How to design your model to separate the inputs and calculations.
  • The difference between formats and styles, and how to import styles into a workbook.
  • How to effectively use number formatting and custom number formats.
  • When and how to effectively apply conditional formatting.
  • How to effectively assign and use range names, add hyperlinks and data validation.
  • The importance of checks to keep your model error free.
  • Printing and viewing tips, linking tips and security tips to protect your model.
  • Key Excel functions that are essential to know when building a financial model.

Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a GoSkills Excel certification can boost your career.

If you have mastered the basics and want to apply your knowledge to build a financial model, then check out the Financial Modeling Techniques course.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.


Accreditations and approvals

CPD - The CPD Certification Service.

Reviews1

View all reviews