Scenario & Sensitivity Analysis in Excel
Course Report
Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.
Visit Course Report
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
Case Studies,Instructor-Moderated Discussions
Skills You Will Gain
What You Will Learn
Analyzing results - sorting and organizing the data
Gravity sort table - using LARGE and SMALL functions in Excel to auto-sort
Introduction, scenario vs sensitivity
Learn how to perform sensitivity analysis? - how to enhance financial modeling and analysis
Presenting results - making the output presentation ready
Scenario analysis in Excel - structure, setup and CHOOSE function
Sensitivity model integration - direct and Indirect methods, data tables
Tornado charts - a visual representation of the results
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
Ayinde Wasiu
Instructor
Mark Morse
Instructor
Mohammad Bashar Al Barini
Instructor
Yordan Kanchev, FCCA
Instructor