Course Overview

Key Features

  • 15 Hrs of High Quality e-Learning access
  • 1 FM With MS Excel Simulation exam
  • 13 Chapter-end Quizzes
  • Excel Templates for practice
  • Case study based chapters
  • Covers Monte-Carlo simulation, Football field and floating bar charts

Training Options

Self-Paced Learning

$ 99

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Financial modeling with excel advanced

    Preview
    • Module 01 - ValuationModeling

      39:27Preview
      • 1.1 Welcome
        00:07
      • 1.2 Advanced Financial Modeling Course
        00:48
      • 1.3 Advanced Financial Modeling An Introduction
        02:10
      • 1.4 Advanced FM Course Contents
        02:13
      • 1.5 Valuation Modeling
        00:45
      • 1.6 Agenda
        00:50
      • 1.7 Excel Shortcuts for Financial Modeling 1
        02:53
      • 1.8 Excel Shortcuts for Financial Modeling 2
        02:04
      • 1.9 Excel Formulas for Financial Modeling
        02:30
      • 1.10 Building Historical and Projected Financial Statements
        10:14
      • 1.11 Ratio Analysis 1
        02:35
      • 1.12 Ratio Analysis 2
        03:13
      • 1.13 Ratio Analysis 3
        02:41
      • 1.14 Ratio Analysis 4
        05:25
      • 1.15 Summary
        00:55
      • 1.16 Quiz
      • 1.17 Thank You
        00:04
    • Module 02 - Merger and Acquisition Analysis

      24:47Preview
      • 2.1 Welcome
        00:07
      • 2.2 Merger and Acquisition Analysis
        00:24
      • 2.3 Agenda
        00:35
      • 2.4 Merger and Acquisition Analysis Basics
        02:36
      • 2.5 Bid Evaluation
        09:47
      • 2.6 Accretion and Dilution Analysis
        03:29
      • 2.7 Accretion and Dilution Analysis Example
        02:41
      • 2.8 Contribution Analysis
        01:04
      • 2.9 Contribution Analysis Example
        03:21
      • 2.10 Summary
        00:39
      • 2.11 Quiz
      • 2.12 Thank You
        00:04
    • Module 03 - Project Finance Modeling

      25:22Preview
      • 3.1 Welcome
        00:07
      • 3.2 Project Finance Modeling
        00:46
      • 3.3 Agenda
        00:39
      • 3.4 Project Finance An Introduction
        03:03
      • 3.5 Project Finance Modeling An Introduction
        02:18
      • 3.6 Date Functions in Excel
        04:13
      • 3.7 Risk Analysis
        03:10
      • 3.8 Modeling Cash Flow Waterfall
        03:42
      • 3.9 Circular References and Modeling IDC
        06:29
      • 3.10 Summary
        00:51
      • 3.11 Quiz
      • 3.12 Thank You
        00:04
    • Module 04 - Monte Carlo Simulation

      20:03Preview
      • 4.1 Welcome
        00:06
      • 4.2 Monte Carlo Simulation
        01:01
      • 4.3 Agenda
        00:33
      • 4.4 Monte Carlo Simulation An Introduction
        04:25
      • 4.5 Monte Carlo Simulation Alternative Approaches
        04:30
      • 4.6 Monte Carlo Simulation Using Excel Worksheet
        08:39
      • 4.7 Summary
        00:46
      • 4.8 Quiz
      • 4.9 Thank You
        00:03
    • Module 05 - Advanced MapReduce

      17:31Preview
      • 5.1 Welcome
        00:07
      • 5.2 Advanced Excel Functions for FM
        00:42
      • 5.3 Agenda
        00:33
      • 5.4 The INDEX Function
        06:55
      • 5.5 The MATCH Function
        04:44
      • 5.6 Advanced Lookups Using INDEX and MATCH
        03:41
      • 5.7 Summary
        00:44
      • 5.8 Quiz
      • 5.9 Thank You
        00:05
    • Module 06 - Advanced Charting Techniques

      07:46Preview
      • 6.1 Welcome
        00:06
      • 6.2 Advanced Charting Techniques
        00:40
      • 6.3 Agenda
        00:33
      • 6.4 Creating a Valuation Football Field Chart
        03:32
      • 6.5 Valuation Football Field Godrej Properties Example 1
        00:11
      • 6.6 Valuation Football Field Godrej Properties Example 2
        00:58
      • 6.7 Floating Bar Charts Importance and Uses
        01:03
      • 6.8 Summary
        00:40
      • 6.9 Quiz
      • 6.10 Thank You
        00:03

Reviews

  • Vijay Korishettar

    Vijay Korishettar

    Bangalore

    The course was quite worthwhile, good presentation of the basics of Financial Modeling & Financial Management.

  • Roopesh Singh

    Roopesh Singh

    Bangalore

    The training is really helpful for those who want to get applied knowledge.

  • Neerav Shrivastava

    Neerav Shrivastava

    Delhi

    Training session was very useful and interactive. I can implement the learning in my day to day work. Trainer was really impressive and solved our complex problems easily.

  • Rama Mahendru

    Rama Mahendru

    Delhi

    It was a good learning and this course was quite useful. Highlight was the trainer "Sameer Kalra". He is very knowledgeable and informative and I would say very patient as well. I enjoyed and learned a lot.

  • Agniva Poodar

    Agniva Poodar

    Bangalore

    Great course content and even better faculty.

  • Pavan Kumar P

    Pavan Kumar P

    Bangalore

    Very useful training on Financial Modeling. Good faculty presentation.

  • Kashmira Seth

    Kashmira Seth

    Mumbai

    The training was very well conducted. I was able to refresh the existing knowledge and enrich new computing methods. I Would like to do such trainings in future by your concern or the trainer. Completely satisfied with the course content, trainer and training methodology.

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

  • How do I enroll for the online training?

    You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

    1. Visa debit/credit card
    2. American express and Diners club card
    3. Master Card, or
    4. Through PayPal

  • What will I get along with this training?

    You will have online access to e-learning and practice tests along with the training.

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

  • Do you provide money back guarantee for the training programs?

    Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

  • Can I extend the access period?

    Yes, you can extend the access period by paying an additional fee. Please raise a request via our Help and Support portal.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

  • I am not able to access the online course. Whom should I contact for a solution?

    Please raise a request via our Help and Support portal to have your issue resolved.

  • Does the course fee include the examination fee as well?

    No, the course fee is only for earning PDU's required to appear for the respective exams.

  • What is Financial Modeling?

    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.

  • What is the use of Excel in Financial Modeling?

    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. Combined with the programmability that is built-in to Microsoft® Excel, it provides a powerful yet easy to use platform for financial modelers

  • How does Financial Modeling help professionals in their career?

    Financial Modeling helps professionals to decide how much to invest, which project OR

    Asset to invest in, and even whether to invest at all. Remember the Facebook valuation of USD 104 Billion? OR

    What prompted Tata motors Ltd. to acquire Jaguar_Land Rover? Financial Modeling answers it all

  • How will this course help me?

    The course will help you gain

    1. In-depth knowledge of the concepts
    2. Ground-up training with case study to clear all concepts
    3. Practical exercises to sharpen financial decision making skills

  • I want to know more about the training program. Whom do I contact?

    Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

Find Financial Modeling with MS Excel Advanced Certification Training in other cities

AtlantaBostonColumbusLos Angeles
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.