Quality Seal Emagister EMAGISTER CUM LAUDE

Financial Modeling with MS Excel Foundation & Advanced

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.

Important information

Opinions

A

19/03/2014
What I would highlight Training was very informative; trainer has good knowledgeable of ITIL which he shared brilliantly.

Would you recommend this course? Yes.

What you'll learn on the course

Advanced
Excel MS
Ms Excel
Financial
Modeling

Course programme

Course Preview
  • Financial Modeling with MS Excel
    • Module 00 - Introduction
      • 1 Introduction to Financial Modeling program
      • 2 Agenda
      • 3.What is Financial Modeling
      • 4 Course structure
      • 5 Spreadsheet usage in Financial Modeling
      • 6 Thank You
    • Module 1A - Part 01 - Introduction to valuation modeling
      • 1 Module 1-A : Valuation modelling Part 1 - Introduction to valuation modelling
      • 2 Agenda
      • 3 Understanding integrated financial models
      • 4 Understanding integrated financial model (ctd1)
      • 5 Understanding integrated financial models (ctd2)
      • 6 Understanding integrated financial models (ctd3)
      • 7 Understanding integrated financial models (cdt4)
      • 8 Understanding integrated financial models (cdt5)
      • 9 Understanding integrated financial models (cdt6)
      • 10 Case study 1 : How to define a worst case scenario
      • 11 Scenario analysis
      • 12 Case study 1 : how to define a worst case scenario (ctd1)
      • 13 Case study 1 : How to define a worst case scenario (ctd2)
      • 14 Working with cash-flows
      • 15 Working with cash-flows (ctd1)
      • 16 Case study 2 : building a cash-flow projection for a fixed-coupon bond
      • 17 Interest-rates and the price of time
      • 18 Interest-rates and the price of time (ctd1)
      • 19 Interest-rates and the price of time (ctd2)
      • 20 Interest-rates and the price of time (ctd3)
      • 21 Interest-rates and the price of time (ctd4)
      • 22 Quiz
      • 23 Thank You
    • Module 1A - Part 02 - Putting it together : How to value a company
      • 1 Module 1-A : Valuation modelling Part 2 - Putting it together : How to value a company
      • 2 Agenda
      • 3 Backward-looking accounting-based valuation techniques
      • 4 Backward-looking accounting-based valuation techniques (ctd1)
      • 5 Backward-looking accounting-based valuation techniques (ctd2)
      • 6 Backward-looking accounting-based valuation techniques (ctd3)
      • 7 Backward-looking accounting-based valuation techniques (ctd4)
      • 8 Backward-looking accounting-based valuation techniques (ctd5)
      • 9 Backward-looking accounting-based valuation techniques (ctd6)
      • 10 Backward-looking accounting-based valuation techniques (ctd7)
      • 11 Backward-looking accounting-based valuation techniques (ctd8)
      • 12 Backward-looking accounting-based valuation techniques (ctd9)
      • 13 Backward-looking accounting-based valuation techniques (ctd10)
      • 14 Case study 3 : profitability analysis
      • 15 Forward-looking accounting-based valuation techniques
      • 16 Forward-looking accounting-based valuation techniques (ctd1)
      • 17 Forward-looking accounting-based valuation techniques (ctd2)
      • 18 Discounted cash-flows valuation techniques
      • 19 Discounted cash-flows valuation techniques (ctd1)
      • 20 Discounted cash-flows valuation techniques (ctd2)
      • 21 Discounted cash-flows valuation techniques (ctd3)
      • 22 Discounted cash-flows valuation techniques (ctd4)
      • 23 Quiz
      • 24 Thank You
    • Module 1B - Part 01 - Profitability analysis
      • 1 Module 1-B : Project finance modeling Part 1 - Profitability analysis
      • 2 Agenda
      • 3 The Internal Rate of Return (IRR)
      • 4 Case study: Calculating an IRR
      • 5 Case study: Calculating an IRR (ctd1)
      • 6 Analysis of costs
      • 7 Analysis of costs (ctd...)
      • 8 Analysis of costs (ctd...)
      • 9 Opportunity cost
      • 10 Opportunity cost (ctd 1)
      • 11 Opportunity cost (ctd 2)
      • 12 Case study: The prisoner's dilemma
      • 13 Case study: The prisoner's dilemma (ctd1)
      • 14 Case study: The prisoner's dilemma (ctd2)
      • 15 Case study 6 : Profitability of a Venture Capital("VC") fund investment
      • 16 Various measures of profitability
      • 17 Case study 6 : Profitability of a Venture Capital("VC") fund investment
      • 18 Quiz
      • 19 Thank You
    • Module 1B - Part 02 - Capital usage and diversification
      • 1 Module 1-B : Project finance modelling Part 2 - Capital usage and diversification
      • 2 Agenda
      • 3 Introduction to Capital
      • 4 Introduction to Capital (ctd 1)
      • 5 Introduction to Capital (ctd 2)
      • 6 Introduction to Capital (ctd 3)
      • 7 Introduction to Capital (ctd 4)
      • 8 Introduction to Capital (ctd 5)
      • 9 Capital-based profitability measures
      • 10 Capital-based profitability measures (ctd 1)
      • 11 Capital-based profitability measures (ctd 2)
      • 12 Capital-based profitability measures (ctd 3)
      • 13 Capital-based profitability measures (ctd 4)
      • 14 Capital-based profitability measures (ctd 5)
      • 15 Contribution of additional risks
      • 16 Case study 7 : understanding diversification
      • 17 Case study 7 : Understanding diversification (ctd 1)
      • 18 Assessing required capital
      • 19 Case study 8 : Calculating a Value at Risk
      • 20 Case study 8 : Calculating a Value at Risk (ctd 1)
      • 21 Quiz
      • 22 Thank You
    • Module 1C - Part 01 - Advanced company valuation
      • 1 Module 1-C : Merger and acquisition modeling Part 1 - Advanced company valuation
      • 2 Agenda
      • 3 From several values to one valuation
      • 4 From several values to one valuation (ctd1)
      • 5 From several values to one valuation (ctd2)
      • 6 From several values to one valuation (ctd3)
      • 7 From several values to one valuation (ctd4)
      • 8 From several values to one valuation (ctd5)
      • 9 Influence of external factors
      • 10 Influence of external factors (ctd1)
      • 11 Case study 9: impact of credit rating agencies
      • 12 Case study 9: impact of credit rating agencies (ctd1)
      • 13 Case study 9: impact of credit rating agencies (ctd2)
      • 14 Case study 9: impact of credit rating agencies (ctd3)
      • 15 Analysis of synergies
      • 16 Analysis of synergies (cdt1)
      • 17 Quiz
      • 18 Thank You
    • Module 1C - Part 02 - Debt and equity structures
      • 1 Module 1-C : Merger and acquisitions modelling Part 2 - Debt and equity structures
      • 2 Agenda
      • 3 Financing acquisition deals
      • 4 Financing acquisition deals (ctd1)
      • 5 Financing acquisition deals (ctd2)
      • 6 The various types of M and A deals
      • 7 The various types of M and A deals (ctd1)
      • 8 Case study 10: valuing warrants
      • 9 Case study 10: valuing warrants (ctd1)
      • 10 Case study 10: valuing warrants (ctd2)
      • 11 Capital increases: dilution and accretion effects
      • 12 Case study 11: Leveraged buy-outs
      • 13 Case study 11: Leveraged buy-outs (ctd1)
      • 14 Case study 12: Full valuation model
      • 15 Case study 12: Full valuation model (ctd1)
      • 16 Case study12 Full valuation model (ctd2)
      • 17 Quiz
      • 18 Thank You
    • Module 2A - Part 01 - Introduction to the use of macros
      • 1 Module 2-A : Macros for financial modelling Part 1 - Introduction to the use of macros
      • 2 Agenda
      • 3 Writing and using macros
      • 4 Writing and using macros (cdt1)
      • 5 Writing and using macros (cdt2)
      • 6 Writing and using macros
      • 7 Case study 13: price of a fixed coupon bond macro
      • 8 Case study 13: price of a fixed coupon bond macro (ctd1)
      • 9 Case study 13: price of a fixed coupon bond macro (ctd1)
      • 11 Working with cells and ranges
      • 12 Working with cells and ranges (ctd1)
      • 13 Working with cells and ranges (ctd2)
      • 14 Working with cells and ranges (ctd1)
      • 15 Working with cells and ranges (ctd2)
      • 16 Working with cells and ranges (ctd3)
      • 17 Working with cells and ranges (ctd4)
      • 18 Working with cells and ranges (ctd5)
      • 19 Case study 14: applying a function to an array
      • 20 Working with cells and ranges (ctd6)
      • 21 Using VB forms controls for flexible GUIs
      • 22 Case study 15: Displaying the result of a calculation in a VB form
      • 23 Quiz
      • 10 Case study 13: price of a fixed coupon bond macro (ctd1)
    • Module 2A - Part 02 - Dynamic use of macros and advanced concepts
      • 1 Module 2-A : Macros for financial modelling Part 2 - Dynamic use of macros and advanced concepts
      • 2 Agenda
      • 3 The various elements of VBA coding
      • 4 The various elements of VBA coding (ctd1)
      • 5 The various elements of VBA coding (ctd2)
      • 6 The various elements of VBA coding (ctd3)
      • 7 The various elements of VBA coding (ctd4)
      • 8 The various elements of VBA coding (ctd5)
      • 9 Case study 16: defining new types of objects
      • 10 Case study 16: defining new types of objects (ctd1)
      • 11 Case study 16: defining new types of objects (ctd2)
      • 12 Case study 16: defining new types of objects (ctd3)
      • 13 Case study 16: defining new types of objects (ctd4)
      • 14 Breaking circular loops
      • 15 Breaking circular loops (ctd1)
      • 16 Writing a comprehensive macro
      • 17 Case study 17: Monte-Carlo simulation macro to price an equity option
      • 18 Case study 17: Monte-Carlo simulation macro to price an equity option (ctd1)
      • 19 Case study 17: Monte-Carlo simulation macro to price an equity option (ctd2)
      • 20 Case study 17: Monte-Carlo simulation macro to price an equity option (ctd3)
      • 21 Quiz
    • Module 2B - Part 01 - Spreadsheet data manipulation
      • 1 Module 2-B : Advanced Excel Functions for Financial Modelling Part 1 - Spreadsheet Data Manipulation
      • 2 Agenda
      • 3 Search Functions
      • 4 Search Functions (ctd1)
      • 5 Case study: Vlookup Function
      • 6 Ranges and Names
      • 7 Name Manager
      • 8 Name Manager (ctd1)
      • 9 Introduction to the Excel Solver
      • 10 Introduction to the Excel Solver (ctd1)
      • 11 Case study: calculating an IRR using the Excel Solver
      • 12 Case study: calculating an IRR (ctd1)
      • 13 Quiz
      • 14 Thank You
    • Module 2B - Part 02 - Using excel built-in functions
      • 1 Module 2-B : Advanced Excel Functions for Financial Modelling Part 2 - Using excel built-in functions
      • 2 Agenda
      • 3 Statistical Functions
      • 4 Case study: Percentile Function
      • 5 Case study: Percentrank Function
      • 6 Probabilistic Functions
      • 7 Normal Distribution Functions
      • 8 Normal Distribution Functions
      • 9 Normal Distribution Functions
      • 10 Normal Distribution Functions
      • 11 Normal Distribution Functions
      • 12 Case study: Black-Scholes Model
      • 13 Case study: Black-Scholes Model (ctd1)
      • 14 Case study: Black-Scholes Model (ctd2)
      • 15 Case study: Black-Scholes Model (ctd3)
      • 16 Date and Time Functions
      • 17 Date and Time Functions
      • 18 Case study: Bond Valuation using DAYS360 Function
      • 19 Case study: Bond Valuation using DAYS360 Function
      • 20 Case study: Bond Valuation using DAYS360 Function
      • 21 Case study: Bond Valuation using DAYS360 Function
      • 22 Text and String Functions
      • 23 Text and String Functions (ctd1)
      • 24 Text and String Functions (ctd2)
      • 25 Quiz
      • 26 Thank You
    • Module 2C - Part 01 - Using charts in Excel
      • 1 Module 2-C : Advanced charting and dash-boarding techniques Part 11 - Using charts in Excel
      • 2 Agenda
      • 3 Charts basics
      • 4 Charts basics (ctd1)
      • 5 Charts basics - Case study 23: examples of charts
      • 6 Charts basics - Case study 23: examples of charts (ctd1)
      • 7 Charts basics - Case study 23: examples of charts (ctd2)
      • 8 Charts basics - Case study 23: examples of charts (ctd3)
      • 9 Charts basics - Case study 23: examples of charts (ctd4)
      • 10 Charts formatting
      • 11 Charts formatting (ctd1)
      • 12 Charts formatting (ctd2)
      • 13 Charts formatting (ctd3)
      • 14 Advanced charting techniques
      • 15 Advanced charting techniques (ctd1)
      • 16 Advanced charting techniques (ctd2)
      • 17 Advanced charting techniques (ctd3)
      • 18 Advanced charting techniques - Case study 24: changing the data ranges from VB
      • 19 Quiz
      • 20 Thank You
    • Module 2C - Part 02 - Using tables and automatic formatting
      • 1 Module 2-C : Advanced charting and dash-boarding techniques Part 2 - Using tables and automatic formatting
      • 2 Agenda
      • 3 Using tables
      • 4 Using tables (ctd1)
      • 5 Creating dashboards
      • 6 Creating dashboards (ctd1)
      • 7 Creating dashboards (ctd2)
      • 8 Creating dashboards (ctd3)
      • 9 Creating dashboards (ctd4)
      • 10 Creating dashboards (ctd5)
      • 11 Creating dashboards - Case study 25: creating a company dashboard
      • 12 Quiz
      • 13 Thank You

Additional information

  • What is this course about?

    Simplilearn’s Financial Modeling with MS® Excel Foundation & Advanced training enables professionals to handle finance models by applying advanced level tools and applications of Excel. Financial Modeling is the task of building a model representing financial asset and performance of a business. Financial Modeling skills are must for finance and commerce professionals especially for almost all mid-senior management professionals worldwide. The added skills gained through MS Excel training helps finance and commerce professionals to gain an in-depth understanding of financial modeling techniques to succeed in today’s demanding environment.


Compare this course with other similar courses
See all