Excel Sensitivity Analysis Course - Financial Modeling Class
Become a Financial Modeling & Valuation Analyst (FMVA)®. Enroll today to advance your career!

Overview

Recommended Prerequisites

You are expected to have either completed the stated prerequisite course(s) or possess the equivalent knowledge prior to enroling in this course:

  1. Building a 3 Statement Financial Model
  2. Business Valuation Modeling

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.


Scenario and sensitivity analysis course overview


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.


Excel sensitivity analysis course example


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:

https://corporatefinanceinstitute.com/about/cpe-information/


sensitivity analysis excel and scenario analysis example

Scenario & Sensitivity Analysis in Excel - Financial Modeling

$97.00 Enroll Now Free Preview

Approx 2.5 hrs to complete

Upgrade

From $847.00
CFI Full Immersion Bundle & FMVA® Certification
Buy Now
From $497.00
CFI Self-Study Bundle & FMVA® Certification
Buy Now

Path to Certification

Prerequisite Courses

6 courses from beginning to intermediate level.

01Optional

Core Courses

9 courses from beginning to intermediate level.

02Required

Elective Courses

Take 3 out of 8 courses at an advanced level.

03Required

Get Certified

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.
Students must complete all core and elective courses (12 in total) and demonstrate mastery of the topics through successful completion of course materials, quizzes, and assessments.
Within 48 hours of program completion, your Blockchain Verified FMVA Certification will be emailed to you.

What Our Students Say

Delbert Adivnovak
Sensitivity Analysis for Financial Modeling
Awesome formulas! Great explanations on the functionality of data tables, sensitivity analysis, and scenarios. I really enjoyed this course!
Kaushik Agarwal
Fantabulously Good
The course is comprehensive and highly educational when it comes to learning material and undoubtedly is a Level 3 Course, given the difficuly in the direct and indirect parts. The time allotted to each activity could have been more. Overall, it's a great course.
SUNIL KUMAR SOM
Super
Hi Tim, This is what I always wanted to understand and showcase to my management and seniors. I love the way you link the variables in the indirect method and without actually chaining the inputs the probable results are there. Love from India...
George Link
Simple explanation of a more difficult topic
The only suggestion I have is when you do the tornado topic the negatives and positives side can differ as it was in my working. Therefore maybe I would suggest instead of using ABS to separate positive and negative side calculation.
See More
Todd Lincoln
This course present good information but it was a quick course. Not nearly as in depth as the others.
Teka Derick Tikum
Awesome course and vital for dynamic models and clearly understanding how our constructed financial models and valuation analysis with respond to future changing variables. Was awesome! Recommend this CFI course to professionals.
Barbara Alvarez
This is an excellent course! Advance financial modeling easy to follow and everything you need to know about sensitivity analysis. Very practical applications. Highly recommended for all finance professionals.
Rustom Rupand
This was totally worth the time I like how the outputs are displayed in charts/graphs and definitely use the template in the future. Some parts are complicated but overall a very good course!
Jared Blum
The tornado chart is super useful

Frequently Asked Questions

Can I download the Excel files and financial modeling templates?
How long do I have to complete the courses?
Are CFI courses verified?
Are there any additional fees or costs?
What currency are your courses priced in?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
More Questions?

FMVA® Financial Analyst Certification

Become a Financial Modeling and Valuation Analyst (FMVA)® by completing all required courses in accounting, finance, modeling, Excel, presentations, and strategy. From beginner to advanced courses you will have the complete training you need to become a world-class financial analyst.

Upgrade

From $847.00
CFI Full Immersion Bundle & FMVA® Certification
Buy Now
From $497.00
CFI Self-Study Bundle & FMVA® Certification
Buy Now