FINANCIAL MODELLING CORE

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

BASIC TO INTERMEDIATE EXCEL

  • Creating a Financial Model Template
  • Cell Freeze, Row Freeze, Column Freeze and Cell Referencing
  • Logical and Statistical Functions (String Function, Offset Function, Data table, Goal seek)
  • Linkages used for Financial Modelling
  • Algebraic operations using Formulas
  • VLOOKUP / HLOOKUP
  • Match Function
  • IRR Calculation and CAGR Calculation
  • Usage of IF function, Table functions, Transpose function
  • Pivot Tables
  • Interest functions as EMI calculator

BASICS OF BUSINESS MODEL

FINANCIAL STATEMENT ANALYSIS

Student Ratings & Reviews

No Review Yet
No Review Yet