Skip to content

Learn Financial Models With Excel In Two Hours
Skill Success

Summary

Price
£157 inc VAT
Or £52.33/mo. for 3 months...
Study method
Online
Duration
Self-paced
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Overview

This course includes lifetime access so you can complete it at your own speed.

This course is designed for those interested to learn the basics of financial models in Excel, how to create them from scratch, learn the concepts, and execute them using real-world examples, in under two hours!

Benefits of taking this course include:

  • Unlimited and lifetime access to the course
  • Learn the course at your own pace
  • Course can be accessed on any platform
  • 24/7 Customer support

Certificates

Certificate of completion

Digital certificate - Included

Course media

Description

Who this course is for:

  • Excel users
  • Accountants
  • Data analysts

What you'll learn:

  • Brag to your friends about how you can perform Financial Modeling in Microsoft Excel confidently!
  • Create your own Financial Model in Excel from scratch in just 2 hours
  • Understand the essence of the Financial modeling concepts and techniques, and see them in action
  • See how it is done in Excel with real examples

Software version used in the course:

  • Microsoft Office 365

Last time you opened a Financial Model in Excel and are overwhelmed by the number of things to do. You don't know how to make the best use of your time. But it doesn't have to be this way!

If you're like me, you use Financial Models on a daily basis for important tasks, analysis, or evaluating projects. Whether it's for business or personal related projects, everyone wants to be able to create financial models freely and easily.

Learn Financial Models With Excel In Two Hours will cover the following topics:

Section 1 - Intro

  • Intro – Modules in the Course
  • Design Principles

Section 2 - Core

  • Aggregate Functions
  • Lookup Function
  • Forecasting
  • Mixed References And Named Ranges
  • External Links

Section 3 - Skills

  • Error Checks
  • Goal Seek
  • WACC
  • NPV and IRR

Section 4 - Model

  • Introduction
  • Staff Expenses
  • Staff Expenses Summary
  • Revenue
  • Market Analysis
  • Profit and Loss
  • NPV IRR
  • Payback Period
  • Scenario Analysis
  • Download Workbooks

Who is this course for?

This course is designed for those interested to learn the basics of financial models in Excel, how to create them from scratch, learn the concepts, and execute them using real-world examples, in under two hours!

Requirements

  • Must have completed the course Create Your First Financial Model In Excel

Career path

None

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.