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

Scenario & Sensitivity Analysis in Excel

Course Cover
compare button icon
Course Report - 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.

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

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

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!

Mark Morse

Instructor

ChallengingI'M LEARNING A LOT!

Mohammad Bashar Al Barini

Instructor

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

Yordan Kanchev, FCCA

Instructor

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