FINANCIAL MODELLING & VALUATION

Financial   Modelling  & Investment Banking Online Courses

(Only one Training for Career in Finance)

(Adv Excel, VBA, Financial Modelling, Project Financing, Valuation, M&A)

Complete Financial Modelling and Investment Banking Course?

Financial Modeling is the process to make Financial Projection of the company on the basis of assumptions and schedules. Financial Model includes the Projection of Income Statement, Balance Sheet and Cash Flow Statement.  Financial Modelling and Valuation is the most required skill in Equity Research, Investment Banking, Project Financing, Credit Research,  Hedge funds or any other mainstream Finance profile.

Following are the various modules included in the Online Course:

  1. Basic and Advance Excel 2013
  2. VBA (Macro) Programming
  3. Basic Charts and Dashboards Training
  4. Introduction and Financial Statements Analysis
  5. Financial Modelling for Telecom, Auto, Real Estate, FMCG, Oil & Gas etc
  6. Valuation of COmpany with DCF, Trading and Transaction Combs
  7. Merger and Acquisition Accretion and Dilution Analysis

Advanced Excel Online Training (Module 1)

In this module, you will learn excel from Basic to Advance. You will see videos covering all the functions and tools step by step. By the end of training, You would have covered more than 100 basic and advanced functions, important shortcuts of excel with practical examples. To list a few functions like Vlookup, Hlookup, Index, Offset, Indirect, Choose, Sumifs, Database, Filter, Adv Filter are all covered with multiple examples. After doing this online course, You hardly need anything more to learn in Excel.

Excel VBA Training Videos (Module 2)

Join this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel VBA Macros.

During this course, you will build a foundation of working with Excel VBA Macros. This foundation will be built as you engage in simple exercises. Each of the exercises will introduce a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

Excel Dashboards Training Videos (Module 3)

In this module you will learn how to create charts and dashboards in excel.

Financial Modelling Basics (Module 4)

In this module, you will learn to make step by step financial models using excel.

Financial Modelling Case Study of Colgate Palmolive (Module 5)

In this module, we have prepared step by step financial Model (using excel) of a US based company “Colgate Palmolive”. So you will learn financial Modelling using excel with real example.

Relative Valuation Model in Excel (Module 6)

In this module, you will learn how to make company valuation using Relative Valuation Model (Trading Combs).

DCF Valuation Model in Excel (Module 7)

In this module, you will learn how to make company valuation using Discounted Cash Flow (DCF) Valuation Model using Excel.

Play
Play
Play
Play
Play
Play
previous arrow
next arrow
previous arrownext arrow
Slider
Click To Call

X
CONTACT US