Financial Modeling with MS Excel Advanced

simplilearn
5.0
1 opinion
  • Excellent and perfectly aligned with required and relevant topics.
    ← | →

Course

Online

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • Excellent and perfectly aligned with required and relevant topics.
    ← | →
100%
4.5
excellent

Course rating

Recommended

Centre rating

Pramod Kumar Bura

5.0
19/03/2014
What I would highlight: Excellent and perfectly aligned with required and relevant topics.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017
2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • 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.

See related categories

Financial Modeling with MS Excel Advanced

Price on request

The best Excel courses

See all

See all