Financial Modeling with MS Excel Foundation & Advanced Certification
5.0 /5- Offered bySimplilearn
- Private Institute
- Estd. 2010
Financial Modeling with MS Excel Foundation & Advanced Certification at Simplilearn Overview
Duration | 56 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Future job roles | Application Security, Audacity, Appraisal, Asp .Net, Asset Allocation |
Financial Modeling with MS Excel Foundation & Advanced Certification at Simplilearn Highlights
- Accredited by International Association for Six Sigma Certification (IASSC)
- Excel Templates for practice, Case study based chapters & Quizzes
- A great course for learning Financial modelling
- Certification Course
Financial Modeling with MS Excel Foundation & Advanced Certification at Simplilearn Course details
- Financial modeling is the process of creating a complete mathematical model which helps in any financial decision making
- It is a mandatory activity for investment bankers, bankers, project finance persons, equity researchers, Private Equity folks & Venture Capitalists
- Microsoft Excel has become the standard tool for finance professionals worldwide as it provides a comprehensive set of functions in an intuitive, easy-to-use pattern for an entire range of financial modeling scenarios
Financial Modeling with MS Excel Foundation & Advanced Certification at Simplilearn Curriculum
Module 01 - Valuation Modeling
Excel Shortcuts for Financial Modeling 1
Excel Shortcuts for Financial Modeling 2
Excel Formulas for Financial Modeling
Building Historical and Projected Financial Statements
Ratio Analysis 1
Ratio Analysis 2
Ratio Analysis 3
Ratio Analysis 4
Summary
Quiz
Thank You
Module 02 - Merger and Acquisition Analysis
Welcome
Merger and Acquisition Analysis
Agenda
Merger and Acquisition Analysis Basics
Bid Evaluation
Accretion and Dilution Analysis
Accretion and Dilution Analysis Example
Contribution Analysis
Contribution Analysis Example
Summary00:39
Quiz
Thank You
Module 03 - Project Finance Modeling
Welcome
Project Finance Modeling
Agenda
Project Finance An Introduction
Project Finance Modeling An Introduction
Date Functions in Excel
Risk Analysis
Modeling Cash Flow Waterfall
Circular References and Modeling IDC
Summary
Quiz
Thank You
Module 04 - Monte Carlo Simulation
Welcome
Monte Carlo Simulation
Agenda
Monte Carlo Simulation An Introduction
Monte Carlo Simulation Alternative Approaches
Monte Carlo Simulation Using Excel Worksheet
Summary
Quiz
Thank You
Module 05 - Advanced MapReduce
Welcome
Advanced Excel Functions for FM
Agenda
The INDEX Function
The MATCH Function
Advanced Lookups Using INDEX and MATCH
Summary
Thank You
Module 06 - Advanced Charting Techniques
Welcome
Advanced Charting Techniques
Agenda
Creating a Valuation Football Field Chart
Valuation Football Field Godrej Properties Example 1
Valuation Football Field Godrej Properties Example 2
Floating Bar Charts Importance and Uses
Summary
Thank You
Other courses offered by Simplilearn
Financial Modeling with MS Excel Foundation & Advanced Certification at Simplilearn Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?
FinanceAccountingAccounting and ControlFinancial Modeling with MS Excel Foundation & Advanced Certification