Financial Modeling in MS-Excel

30 hours of training + certification

One exam only

Score 70% or more to get certified

Task-Based

 Modes of training
​

Online - live training on our LMS platform
(or)

Classroom training at Pune, Lohegaon

 Overview of the Course

Financial modeling is a process to build an abstract model of a company's financial position and performance of a company's assets, portfolio or any other investments.

Course Highlights

  • Live interactive session

  • Sessions conducted by industry finance & banking expert

  • E-material including Excel templates will be provided for future reference

  • Industry based examples

Course Structure:

​

  • Domain - Finance

  • Level of training - Basic to Advanced

  • Technologies used in this training - MS-Excel ( You can enroll to Excel training if you are not at an intermediate skill-level - click here)
     

Select your plan

Financial Modeling in Excel

  • What is a financial model? – An overview

  • MS-Excel and finance - when & how to use Excel in finance

  • Functions in Excel

  • Dashboards

  • Data cleaning/structuring

  • Developing analytics - Industry-wise
    Statistics and Excel

  • Regression modeling in Excel

  • Working capital - models in Excel

  • Marginal analysis - models in Excel

  • Capital budgeting - models in Excel

  • Bonds - models in Excel

  • Valuation modeling in Excel

  • Derivatives modeling in Excel

  • What next?

What you'll get?
Join-thedots course completion certificate