Sign In
    Saved
      Sign In
      Saved

Scenario & Sensitivity Analysis in Excel

Home / CFI / Scenario & Sensitivity Analysis in Excel
Certification

Scenario & Sensitivity Analysis in Excel

Learn how to do scenario & sensitivity analyses in Excel for FP&A and investment banking.

1 Coupon Available

Login To View All

Description

View More

Features

This course includes

Duration

2.5 hours
Video Content
2.5 hours
Level
Intermediate
Instruction Type
Self Paced
Delivery Method
Online
Available on
Desktop, Laptop
Accessibility
Limited Access
Language
English
Subtitles
English

Skills

Financial ManagementFinancial ModelingFinancial AnalysisExcel

Learning Goals

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

Course Content

View More

Target Audience

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

Instructors

Profile Image

Mohammad Bashar Al Barini

Instructor

View More
Profile Image

Ayinde Wasiu

Instructor

View More
Profile Image

Yordan Kanchev, FCCA

Instructor

View More
Profile Image

Mark Morse

Instructor

View More

Course Overview

Instructor-Moderated Discussions

Post course interactions

Case-Based Learning

Personalized Teaching

FAQs

Can I download the Excel files and financial modeling templates for the course?

How long do I have to complete the courses?

Are CFI courses officially accredited?

Are there any additional fees or costs?

What currency are your courses priced in?

How do I earn my certificates?

Will these courses help me advance my career?

Can I email the instructor if I have questions?

What is the price of the subscription?

What is included in the subscription?

More Questions?

View More

₹3,018

Percent Icon

1 Coupon Available
Get Upto 10% Discount

0