Financial Modeling Basics

Testimonials (41 reviews)

Features

Premium video tutorials

Award-winning instructors

Personalized learning

Get certified

Learn at your own pace

Mobile (learn on-the-go)

Unlimited tests and quizzes

Regularly updated content


Overview

Financial modeling in Excel is extremely useful to forecast and make key decisions about your company's performance. This financial modeling training online 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 the course so that you can apply the practical knowledge you learn through hands-on application in Excel.

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.

Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.

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

Financial Modeling Basics
Focus video player for keyboard shortcuts
Auto
  • 720p
  • 540p
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

Summary

Skill level: Beginner
Certificate: Yes
Lessons: 55
Accredited by: CPD
Pre-requisites: None
Video duration: 5h 08m
Estimated study time: 27h 30m for all materials

Accreditations and approvals

CPD - The CPD Certification Service.


Syllabus

1

Introduction

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.

Video time: 03m 48s

2

CRaFT - Consistency

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

Video time: 06m 43s

3

CRaFT - Robustness

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

Video time: 05m 07s

4

CRaFT - Flexibility

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.

Video time: 05m 36s

5

CRaFT - Transparency

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.

Video time: 09m 02s

1

Separation of Inputs + Calculations

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

Video time: 06m 08s

2

Workbook Structure

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

Video time: 04m 01s

3

Keyboard Shortcuts

A summary of Keyboard Shortcuts.

Video time: 03m 55s

4

Layout Tips Part 1

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

Video time: 06m 14s

5

Layout Tips Part 2

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

Video time: 06m 08s

6

Layout Tips Part 3

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

Video time: 06m 09s

7

Layout Tips Part 4

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

Video time: 05m 45s

8

Layout Tips Part 5

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

Video time: 05m 51s

9

Formats vs. Styles

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

Video time: 06m 28s

10

Formats vs. Styles Part 2

How to import styles into a workbook.

Video time: 04m 05s

11

Number Formatting Part 1

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

Video time: 04m 05s

12

Number Formatting Part 2

Understand the coding in Custom Number Formatting.

Video time: 03m 24s

13

Number Formatting Part 3

How to use Custom Number Formatting.

Video time: 04m 56s

14

Number Formatting Part 4

How to use Custom Number Formatting, continued.

Video time: 04m 19s

15

Conditional Formatting

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

Video time: 06m 11s

16

Layout Tips Part 6

How to use Work in Progress (WIP) Flagging.

Video time: 04m 52s

1

Range Names Part 1

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

Video time: 05m 17s

2

Range Names Part 2

How to use Range Names in a formula.

Video time: 06m 00s

3

Range Names Part 3

How to use Range Names in a formula, continued.

Video time: 05m 52s

4

Hyperlinks

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

Video time: 05m 58s

5

Data Validation

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

Video time: 04m 54s

6

Data Validation Part 2

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

Video time: 03m 48s

7

Overall Checks

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

Video time: 07m 27s

8

Error Checks

How to create a prima facie error check.

Video time: 06m 19s

9

Sensitivity Check

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

Video time: 03m 41s

10

Alert Checks

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

Video time: 04m 13s

1

Printing and Viewing Tips

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

Video time: 07m 23s

2

Linking Tips

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

Video time: 07m 34s

3

Security and Protection

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

Video time: 05m 30s

4

Version Control

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

Video time: 03m 57s

1

Functions Overview

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

Video time: 05m 08s

2

IF

Illustration and issues with the IF function.

Video time: 06m 56s

3

SUM

Illustration and issues with the SUM function.

Video time: 05m 05s

4

SUMIF

Illustration and issues with the SUMIF function.

Video time: 08m 04s

5

SUMIFS

Illustration and issues with the SUMIFS function.

Video time: 03m 58s

6

SUMPRODUCT

Illustration and issues with the SUMPRODUCT function.

Video time: 06m 54s

7

SUMPRODUCT Part 2

An advanced example of the use of SUMPRODUCT.

Video time: 05m 44s

8

Don't Use HLOOKUP and VLOOKUP

Why not to use HLOOKUP and VLOOKUP functions.

Video time: 05m 37s

9

INDEX

Illustrations of the use of the INDEX function.

Video time: 04m 53s

10

MATCH

Illustration and issues with the MATCH function.

Video time: 05m 48s

11

INDEX MATCH

Illustrations of the use of INDEX MATCH.

Video time: 07m 37s

12

LOOKUP

Illustration and issues with the LOOKUP function.

Video time: 06m 44s

13

LOOKUP Part 2

Illustration and issues with the LOOKUP function continued.

Video time: 06m 12s

14

OFFSET

Illustration and issues with the OFFSET function.

Video time: 07m 08s

15

OFFSET Part 2

Illustration and issues with the OFFSET function continued.

Video time: 06m 57s

16

OFFSET Part 3

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

Video time: 06m 59s

17

MOD

Illustrations and issues with the MOD function.

Video time: 05m 22s

18

EOMONTH

Illustrations and issues with the EOMONTH function.

Video time: 05m 47s

19

MAX and MIN

Illustration and issues with MAX and MIN.

Video time: 05m 00s

20

Finale

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

Video time: 01m 46s

Download syllabus