Financial Modelling in MS Excel

From Beginners to Advance

 Financial Modelling in MS Excel

 Financial Modeling is an essential skill for accounting and finance professional.

It is very much in demand in the job market and is highly valued by employers. Our Financial Modeling training takes you from basics to professional level.  This twenty hours training is based on practical exercises  

The course focuses 30% on honing the participants MS Excel skills and 70% focus on application of  MS Excel in Accounting and Finance 

Financial Modelling Fundamentals
For those who 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 an investment appraisal project 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 our Statement of Financial Position and then produce a Statement of Cash Flow based on P&L and SOFP.

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

What You Will Learn

1. Introduction to Excel
2. Useful tips and tools for your work in Excel
3. Keyboard shortcuts in Excel
4. Excel's key functions and functionalities made easy
5. Update! SUMIFS – Exercise
6. Financial functions in Excel
7. Microsoft Excel's Pivot Tables
8. Case study - Building a complete P&L in Excel
9. Introduction to Excel charts
10. Profit and Loss Statement Preparation - Case Study

11. Financial modeling fundamentals
12. Introduction to Company Valuation
13. Learn how to build a Discounted Cash Flow Model in Excel
14. Business Valuation - Complete practical exercise
15. Capital Budgeting - The theory
16. Capital Budgeting - A Complete Case study - DCF Modelling
17. Impact of interest rates and exchange rates on NPV
18. Sensitivity Analysis in Capital Budgeting  - DCF

Course Curriculum

Reviews

5

Top Rated
  • 5 100%
  • 4
  • 3
  • 2
  • 1
Daniel Mupfigo

Nice Course

Nice practical course for working professionals. At least I learnt a lot on how to use Excel more efficiently in day to day work.

2 months ago
Prithviraj Runjeet

Very Practical

Very good course for working accountants who want to do automation of accounting statement in daily work life. Definitetly a good course.

4 months ago
Esmatullah Nisar

Excellent Course

I enjoyed this course and learnt many new things. I am using MS Excel for many years but did not know how much I did not know. A very good course for working accountants.

4 months ago
Abdul Rafay Khan Khan

Thankyou So much Sir Ali

Thankyou So much Sir Ali

5 months ago
Jamil Ur Rehman

Financial modelling made Easy

Credit must be given to Sir Ali for his great efforts to present financial modelling course, directed towards accounting and finance professionals. This course really enhaces confidence level to prepare and analyze financial data and is recommended professional certification.

6 months ago
Trymore Mufanechiya

Difficulty things made easy

Very clear and easy to understand - Trymore ([email protected])

6 months ago
See more reviews

Course Pricing

  • Financial Modeling in MS Excel

  • $18 USD

    Beginners to Advance

    Buy Now
  • 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
  •  

© 2023 VERTEX LEARNING SOLUTIONS