Financial Modelling in MS Excel
From Beginner to Advance

Topic videos - 10 hours.

Preparation of financial models - 18 hours.

Attached excel files.

One year access.

All course content is updated.

Enroll Now

Course Overview

Financial modeling is an essential skill for accounting and finance professionals. Employers place a high value on it and it is in high demand in the job market.  Our financial modeling training takes you from the basics to the professional level.

This twenty-hour training is based on practical exercises. The course focuses 30% on honing the participants' MS Excel skills and 70% on the application of MS Excel in Accounting and Finance



Financial Modelling Fundamentals
If you are new to financial modelling, they will find videos starting right from the beginning and gradually progress forward.

Discounted Cash Flow
Discounted Cash Flow (DCF) is an important area covered here. Starting from the concept of DCF we will learn its application.

Capital Budgeting
We will build projects from scratch, build up relevant cash flows and use the NPV and IRR method using scenario analysis.  

Profit and Loss Case Study
In this section we will have extracted data from accounting software and we will learn how to quickly organize the data and automate our first Profit and Loss Statement.

SOFP & Cash Flow - Case Study
Continuing with the example of Profit and Loss, we will construct Statement of Financial Position and then produce a Statement of Cash Flow based on P&L and SOFP.

Business Valuation
Starting with the concepts of Business Valuation, we will value a business using different valuation techniques including FCF and FCFE and terminal value concept.

Course Curriculum

Course Pricing

Financial Modeling in MS Excel

$25 USD

  • Beginners to Advance

    • Use code "FM30" to get 30% discount
    • One Year Access to Course Content
    • MS Excel Tips and Tricks
    • Financial Modelling Fundamentals
    • Discounted Cash Flow
    • Capital Budgeting
    • Profit and Loss Case Study
    • SOFP & Cash Flow - Case Study
    • Business Valuation Theory
    • Business Valuation Case Study
    • Downloadable MS Excel Files
Buy Now

© 2025 VERTEX LEARNING SOLUTIONS