Resources Corporate Training Higher Education
Explore our course

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 payscale.com, the median salary of a Financial Consultant can range from $35,933 - $128,051.
    • As per indeed.com, 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

  • Financial modeling with excel advanced

    • Module 01 - ValuationModeling

      39:27
      • 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:47
      • 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:22
      • 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:03
      • 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:31
      • 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:46
      • 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
  • Free Course

    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

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

    View More

    View Less

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.

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
View More View Less

      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.

      View More View Less

          Contact Us

          800-492-2295

          (Toll Free)

          People Also Bought

          Finance for Non-Financial Professionals Finance for Non-Financial Professionals Course Explore
          Financial Modeling with MS Excel Foundation & Advanced Financial Modeling with MS Excel Foundation & Advanced Course Explore

          Our Singapore Correspondence / Mailing address

          #14-302, The Plaza, 7500A Beach Road, Singapore 199591

          Choose your Location

          Let us know your convenient schedule

          Name *
          Email *
          Phone Number
          Date (MM/DD/YYYY)
          • Disclaimer
          • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
          Help and Support