Course Description

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

  • Why is the certification most sought-after?

    Given the complex nature of today’s business scenarios, there has been a shift towards using spreadsheets to facilitate detailed, comprehensive financial models. In addition, spreadsheet software also allows powerful data presentation using numerous visual elements through back-end code. Microsoft® Excel is the most feature-rich software for spreadsheet based modeling, and also most commonly used.

    Currently there are approximately 1500 professionals across the globe who are Certified in Financial Modeling with MS Excel Foundation.

  • What learning benefits do you get from Simplilearn’s training?

    At the end of Simplilearn’s Financial Modeling with MS Excel Foundation Certification Training, you will be able to gather an understanding of:
    • Valuation Modeling
    • Project Finance Modeling
    • Mergers and Acquisition Modeling
    • Macros for Financial Modeling
    • Advanced Excel functions for Financial Modeling
    • Advanced Charting and Dash boarding Techniques

  • What are the career benefits in-store for you?

    The career benefits of this course are as follows:
    • According to recent surveys by, the median salary of a Financial Consultant can range from $35,933 - $128,051.
    • As per, the average income of a Financial Modeling Analyst is $79,000.
    • Understanding of Financial Modeling techniques means minimising the risk of error and using validation tools in a better way  
    • Improves job performance

  • Who should do this course?

    The following categories of professionals can take the exam and obtain the certification:
    • MBA students
    • Commerce graduates
    • Investment Bankers
    • Business Analysts
    • Professionals into Corporate Finance
    • Project Finance or any finance and commerce professionals looking forward to strengthen their knowledge of financial modeling techniques and implication

Course Preview

    • 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
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less


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.

Agniva Poodar
Agniva Poodar Bangalore

Great course content and even better faculty.

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.

Read more Read less
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.

Read more Read less
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.

Read more Read less


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

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