Recommended Prep Courses
These preparatory courses are optional, but we recommend you to complete the stated prep course(s) or possess the equivalent knowledge prior to enrolling in this course:
Scenario and sensitivity analysis course overview
This advanced financial modeling course will teach you how to perform Excel sensitivity analysis with a focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions. The tutorial goes step by step through all the formulas and functions required to perform the analysis in Excel from scratch.
What will I learn about Excel sensitivity analysis?
This course is highly condensed and students will learn a lot in a short time. The agenda for this tutorial is:
- Introduction, scenario vs sensitivity
- Why perform sensitivity analysis? - how to enhance financial modeling and analysis
- Scenario analysis in Excel - structure, setup and CHOOSE function
- Sensitivity model integration - direct and Indirect methods, data tables
- Analyzing results - sorting and organizing the data
- Gravity sort table - using LARGE and SMALL functions in Excel to auto-sort
- Tornado charts - a visual representation of the results
- Presenting results - making the output presentation ready
By the end of this course, you will have a thorough grasp of how to build a robust sensitivity analysis system into your Excel financial model. Form and function are both critical to ensuring you can handle quick changes and information requests when you're working on a live transaction.
Why take this Excel sensitivity analysis course?
This course is designed based on years of practical experience performing financial model sensitivity analysis. We use real-life templates and examples to teach you how to perform it step-by-step the way industry veterans do.
Unlike other courses, ours uses both the direct and direct methods of measuring financial sensitivity - and applies those methods to both operating and financial stresses.
Our sensitivity analysis Excel template can be downloaded at the end of the course and used as an example in your own work.
For further CPE information, please read before purchasing:
- Skills Learned Financial Modeling and Valuation, Sensitivity Analysis, Strategy
- Career Prep Investment Banking and Equity Research, FP&A, Corporate Development
7 courses from beginner to intermediate level.01Optional
11 courses from beginner to intermediate level.02Required
Take 3 out of 11 courses at an advanced level.03Required
Submit your FMVA® checklist and order your certificate.04Required
Join Our Community
Get access to the Global Corporate Finance Society.05Optional
How the Certification Works
FMVA® Financial Analyst Certification courses are offered 100% online, allowing you the flexibility to start the financial analyst program anytime and learn when it’s most convenient for you.
The program is a part of the All Access Subscription, which includes all programs and courses.
CFI courses are designed by instructors with over 21 years of financial analyst training experience.
Vinodh Kumar Soundararajan
Excellent Course !
KOFFI ASSOUMAN EUDES BEDEL
Would highly recommend this course to anyone willing to advance their skill-set in financial modeling and valuation analysis in Finance and investment Industry, comparing to CFA I personally found out that CFA is time-consuming and more theoretical after CFA you feel you still need some practical course for your Career, unlike CFI-FMVA provides great immense and valuable and practical knowledge in financial modeling, excel , budgeting & forecasting, strategy, presentation, accounting, and investment and business valuation, because of all that great combination the most distinguished about this certificate is you will become a confident a world-Class Financial Analyst.
The tornado chart is super useful