Financial Modeling with MS Excel Advanced

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More

Important information

Typology Course
Methodology Online
  • 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.

Opinions

5.0
Course rating
100%
Recommended
4.5
excellent
Centre rating

Reviews on this course

P
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

Reviews on other courses at this centre

Certified Six Sigma Green Belt

G
Girish Ravi
4.5 21/12/2015
What I would highlight: I can say you simply learn here as learning is made simple. Good experienced trainers, lots of options to learn from - online, virtual classroom etc. Learning never stops when you are associated with Simplilearn. So many courses to choose from across project management, quality, technology, business etc. Got my PMP credentials too through Simplilearn and journey continues. Am happy I chose Simplilearn. Happy Learning.
What could be improved: Nothing
Would you recommend this course?: Yes

Microsoft® Project 2013

S
Subhojit Chak
4.0 15/12/2015
What I would highlight: I have just started my courses with Simplilearn and their support is awesome and very prompt. The faculty too is very good. I can rate as a very good quality professionally handled... corporate training.
What could be improved: Nothing
Would you recommend this course?: Yes

Holiday PPC Advertising

N
Nagarjuna DN
5.0 15/12/2015
What I would highlight: "Getting a high quality training from industry expert at your convenience, affordable with the resources you need to master what you are learning. "
What could be improved: Nothing
Would you recommend this course?: Yes

2D Video Game Character Animation for Beginners

K
Krati G
5.0 14/12/2015
What I would highlight: Simplilearn is Simply trustworthy and reliable institute for learning. It has helped me get a good understanding of the concepts of Digital Marketing.
What could be improved: Nothing
Would you recommend this course?: Yes
See all

Achievements for this centre

2017
2016

How do you get the CUM LAUDE seal?

All courses are up to date

The average rating is higher than 3.5

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 2 years

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.


Students that were interested in this course also looked at...
See all