Quality Seal Emagister EMAGISTER CUM LAUDE

Financial Modeling with MS Excel 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

P

19/03/2014
What I would highlight Excellent and perfectly aligned with required and relevant topics.

Would you recommend this course? Yes.

What you'll learn on the course

Ms Excel
Modeling
Advanced
Excel MS
Financial

Course programme

Course Preview
  • Financial modeling with excel advanced
    • Module 01 - ValuationModeling
      • 1.1 Welcome
      • 1.2 Advanced Financial Modeling Course
      • 1.3 Advanced Financial Modeling An Introduction
      • 1.4 Advanced FM Course Contents
      • 1.5 Valuation Modeling
      • 1.6 Agenda
      • 1.7 Excel Shortcuts for Financial Modeling 1
      • 1.8 Excel Shortcuts for Financial Modeling 2
      • 1.9 Excel Formulas for Financial Modeling
      • 1.10 Building Historical and Projected Financial Statements
      • 1.11 Ratio Analysis 1
      • 1.12 Ratio Analysis 2
      • 1.13 Ratio Analysis 3
      • 1.14 Ratio Analysis 4
      • 1.15 Summary
      • 1.16 Quiz
      • 1.17 Thank You
    • Module 02 - Merger and Acquisition Analysis
      • 2.1 Welcome
      • 2.2 Merger and Acquisition Analysis
      • 2.3 Agenda
      • 2.4 Merger and Acquisition Analysis Basics
      • 2.5 Bid Evaluation
      • 2.6 Accretion and Dilution Analysis
      • 2.7 Accretion and Dilution Analysis Example
      • 2.8 Contribution Analysis
      • 2.9 Contribution Analysis Example
      • 2.10 Summary
      • 2.11 Quiz
      • 2.12 Thank You
    • Module 03 - Project Finance Modeling
      • 3.1 Welcome
      • 3.2 Project Finance Modeling
      • 3.3 Agenda
      • 3.4 Project Finance An Introduction
      • 3.5 Project Finance Modeling An Introduction
      • 3.6 Date Functions in Excel
      • 3.7 Risk Analysis
      • 3.8 Modeling Cash Flow Waterfall
      • 3.9 Circular References and Modeling IDC
      • 3.10 Summary
      • 3.11 Quiz
      • 3.12 Thank You
    • Module 04 - Monte Carlo Simulation
      • 4.1 Welcome
      • 4.2 Monte Carlo Simulation
      • 4.3 Agenda
      • 4.4 Monte Carlo Simulation An Introduction
      • 4.5 Monte Carlo Simulation Alternative Approaches
      • 4.6 Monte Carlo Simulation Using Excel Worksheet
      • 4.7 Summary
      • 4.8 Quiz
      • 4.9 Thank You
    • Module 05 - Advanced MapReduce
      • 5.1 Welcome
      • 5.2 Advanced Excel Functions for FM
      • 5.3 Agenda
      • 5.4 The INDEX Function
      • 5.5 The MATCH Function
      • 5.6 Advanced Lookups Using INDEX and MATCH
      • 5.7 Summary
      • 5.8 Quiz
      • 5.9 Thank You
    • Module 06 - Advanced Charting Techniques
      • 6.1 Welcome
      • 6.2 Advanced Charting Techniques
      • 6.3 Agenda
      • 6.4 Creating a Valuation Football Field Chart
      • 6.5 Valuation Football Field Godrej Properties Example 1
      • 6.6 Valuation Football Field Godrej Properties Example 2
      • 6.7 Floating Bar Charts Importance and Uses
      • 6.8 Summary
      • 6.9 Quiz
      • 6.10 Thank You

Additional information

  • What is this course about?

    Simplilearn’s Financial Modeling with MS® Excel Advanced training enables professionals to handle finance models by applying advanced Excel tools and applications. 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 advanced 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