Management
Star icon
Most Popular
Hands on Training icon
Hands On Training
Star icon
Hands on Training icon

Scenario & Sensitivity Analysis in Excel

compare button icon

$41

Visit Course

Visit Course

Course Features

icon

Duration

2.5 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

2.5 hours

Course Description

This course will help you perform Excel sensitivity analysis. It focuses on the practical application of this technique for financial professionals in financial banking, equity research and finance. This tutorial walks you through the entire process of creating an Excel analysis.

Course Overview

projects-img

Personlized Teaching

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

check-card-img

Introduction, scenario vs sensitivity

check-card-img

Learn how to perform sensitivity analysis? - how to enhance financial modeling and analysis

check-card-img

Scenario analysis in Excel - structure, setup and CHOOSE function

check-card-img

Sensitivity model integration - direct and Indirect methods, data tables

check-card-img

Analyzing results - sorting and organizing the data

check-card-img

Gravity sort table - using LARGE and SMALL functions in Excel to auto-sort

check-card-img

Tornado charts - a visual representation of the results

check-card-img

Presenting results - making the output presentation ready

Target Students

check-card-img

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

Author Image

Mohammad Bashar Al Barini

Instructor

Scenario & Sensitivity Analysis in ExcelThis course is very useful. I recommend it to every one!
Author Image

Ayinde Wasiu

Instructor

Highly RecommendedA detailed breakdown of one of the most important component of financial modeling and decision making. I enjoyed all the contents of the course. Highly recommended!
Author Image

Yordan Kanchev, FCCA

Instructor

Amazing course The course is extremely helpful and practical. The skills learnt can be immediately put into practice.
Author Image

Mark Morse

Instructor

ChallengingI'M LEARNING A LOT!

$41

Visit Course

Visit Course

Offer Percent Icon

1 Coupon Available
Get upto 10% Discount