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 Welcome00:07
      • 1.2 Advanced Financial Modeling Course00:48
      • 1.3 Advanced Financial Modeling An Introduction02:10
      • 1.4 Advanced FM Course Contents02:13
      • 1.5 Valuation Modeling00:45
      • 1.6 Agenda00:50
      • 1.7 Excel Shortcuts for Financial Modeling 102:53
      • 1.8 Excel Shortcuts for Financial Modeling 202:04
      • 1.9 Excel Formulas for Financial Modeling02:30
      • 1.10 Building Historical and Projected Financial Statements10:14
      • 1.11 Ratio Analysis 102:35
      • 1.12 Ratio Analysis 203:13
      • 1.13 Ratio Analysis 302:41
      • 1.14 Ratio Analysis 405:25
      • 1.15 Summary00:55
      • 1.16 Quiz
      • 1.17 Thank You00:04
    • Module 02 - Merger and Acquisition Analysis 24:47
      • 2.1 Welcome00:07
      • 2.2 Merger and Acquisition Analysis00:24
      • 2.3 Agenda00:35
      • 2.4 Merger and Acquisition Analysis Basics02:36
      • 2.5 Bid Evaluation09:47
      • 2.6 Accretion and Dilution Analysis03:29
      • 2.7 Accretion and Dilution Analysis Example02:41
      • 2.8 Contribution Analysis01:04
      • 2.9 Contribution Analysis Example03:21
      • 2.10 Summary00:39
      • 2.11 Quiz
      • 2.12 Thank You00:04
    • Module 03 - Project Finance Modeling 25:22
      • 3.1 Welcome00:07
      • 3.2 Project Finance Modeling00:46
      • 3.3 Agenda00:39
      • 3.4 Project Finance An Introduction03:03
      • 3.5 Project Finance Modeling An Introduction02:18
      • 3.6 Date Functions in Excel04:13
      • 3.7 Risk Analysis03:10
      • 3.8 Modeling Cash Flow Waterfall03:42
      • 3.9 Circular References and Modeling IDC06:29
      • 3.10 Summary00:51
      • 3.11 Quiz
      • 3.12 Thank You00:04
    • Module 04 - Monte Carlo Simulation 20:03
      • 4.1 Welcome00:06
      • 4.2 Monte Carlo Simulation01:01
      • 4.3 Agenda00:33
      • 4.4 Monte Carlo Simulation An Introduction04:25
      • 4.5 Monte Carlo Simulation Alternative Approaches04:30
      • 4.6 Monte Carlo Simulation Using Excel Worksheet08:39
      • 4.7 Summary00:46
      • 4.8 Quiz
      • 4.9 Thank You00:03
    • Module 05 - Advanced MapReduce 17:31
      • 5.1 Welcome00:07
      • 5.2 Advanced Excel Functions for FM00:42
      • 5.3 Agenda 00:33
      • 5.4 The INDEX Function06:55
      • 5.5 The MATCH Function04:44
      • 5.6 Advanced Lookups Using INDEX and MATCH03:41
      • 5.7 Summary00:44
      • 5.8 Quiz
      • 5.9 Thank You00:05
    • Module 06 - Advanced Charting Techniques 07:46
      • 6.1 Welcome00:06
      • 6.2 Advanced Charting Techniques00:40
      • 6.3 Agenda00:33
      • 6.4 Creating a Valuation Football Field Chart03:32
      • 6.5 Valuation Football Field Godrej Properties Example 100:11
      • 6.6 Valuation Football Field Godrej Properties Example 200:58
      • 6.7 Floating Bar Charts Importance and Uses01:03
      • 6.8 Summary00:40
      • 6.9 Quiz
      • 6.10 Thank You00: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