🔍

Financial Modeling Basics

Financial modeling Basics 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.

Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a Financial Modeling Basics 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.

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.

Once enrolled, our friendly support team is here to help with any course-related inquiries.

Summary

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

Features

Premium video tutorials
Personalized Learning
Learn at your own pace
Tests and Quizzes
Award winning instructors
Get Certified
Mobile - Learn on the go
Regularly updated content

Accreditations & Approvals

All courses under each learning path are accredited and approved by one or more of the following bodies as is applicable. 

Instructors

All courses are taught by reputed trainers with relevant accreditations and industry experience.

Modules

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.

 

CRaFT – Consistency

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

 

CRaFT – Robustness

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

 

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.

 

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.

Separation of Inputs + Calculations

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

 

Workbook Structure

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

 

Keyboard Shortcuts

A summary of Keyboard Shortcuts.

 

Layout Tips Part 1

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

 

Layout Tips Part 2

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

 

Layout Tips Part 3

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

 

Layout Tips Part 4

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

 

Layout Tips Part 5

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

 

Formats vs. Styles

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

 

Formats vs. Styles Part 2

How to import styles into a workbook.

 

Number Formatting Part 1

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

 

Number Formatting Part 2

Understand the coding in Custom Number Formatting.

 

Number Formatting Part 3

How to use Custom Number Formatting.

 

Number Formatting Part 4

How to use Custom Number Formatting, continued.

 

Conditional Formatting

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

 

Layout Tips Part 6

How to use Work in Progress (WIP) Flagging.

Range Names Part 1

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

 

Range Names Part 2

How to use Range Names in a formula.

 

Range Names Part 3

How to use Range Names in a formula, continued.

 

Hyperlinks

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

 

Data Validation

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

 

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.

 

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.

 

Error Checks

How to create a prima facie error check.

 

Sensitivity Check

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

Alert Checks

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

Printing and Viewing Tips

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

 

Linking Tips

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

 

Security and Protection

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

 

Version Control

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

Functions Overview

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

 

IF

Illustration and issues with the IF function.

 

SUM

Illustration and issues with the SUM function.

 

SUMIF

Illustration and issues with the SUMIF function.

 

SUMIFS

Illustration and issues with the SUMIFS function.

 

SUMPRODUCT

Illustration and issues with the SUMPRODUCT function.

 

SUMPRODUCT Part 2

An advanced example of the use of SUMPRODUCT.

 

Don’t Use HLOOKUP and VLOOKUP

Why not to use HLOOKUP and VLOOKUP functions.

 

INDEX

Illustrations of the use of the INDEX function.

 

MATCH

Illustration and issues with the MATCH function.

 

INDEX MATCH

Illustrations of the use of INDEX MATCH.

 

LOOKUP

Illustration and issues with the LOOKUP function.

 

LOOKUP Part 2

Illustration and issues with the LOOKUP function continued.

 

OFFSET

Illustration and issues with the OFFSET function.

 

OFFSET Part 2

Illustration and issues with the OFFSET function continued.

 

OFFSET Part 3

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

 

MOD

Illustrations and issues with the MOD function.

 

EOMONTH

Illustrations and issues with the EOMONTH function.

 

MAX and MIN

Illustration and issues with MAX and MIN.

 

Finale

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

Target Audience

  • Graduates exploring placement in the entry-level Financial positions across industries
  • Finance professionals needing upskilling to be future-ready or become more productive in their current roles
  • Experienced individuals exploring Financial Modeling Basics roles to join the workforce

How do I Access The Program

  • Buy the course online
  • Save your payment transaction receipt for any future reference 
  • Our team will share the credentials to enable you access your course online within 2 business days of payment transfer

Bulk Orders

Incase you are looking for bulk user licenses, or customized Learning Paths for various Job Roles, reach out to us with your detailed requirements.

Contact Us
Subscription

Monthly, Annual

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related products