Scenario & Sensitivity Analysis in Excel
$41
Course Features
Duration
2.5 hours
Delivery Method
Online
Available on
Limited Access
Accessibility
Desktop, Laptop
Language
English
Subtitles
English
Level
Intermediate
Teaching Type
Self Paced
Video Content
2.5 hours
Course Description
Course Overview
Personlized Teaching
Case Based Learning
Post Course Interactions
Instructor-Moderated Discussions
Skills You Will Gain
What You Will Learn
Introduction, scenario vs sensitivity
Learn how to 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
Target Students
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 fun
Course Instructors
Course FAQs
$41
1 Coupon Available
Get upto 10% Discount