Chools - Dalilna |Scenario & Sensitivity Analysis

About Course

The course teaches you how to perform scenario and sensitivity analysis in Excel, which are useful techniques for financial modeling and analysis.
The course covers topics such as:
How to create different scenarios and analyze key metrics using data tables.
How to use solver, goal seek, and scenario manager to perform simulation analysis.
How to create gravity sort tables and tornado charts to present the results.
How to make the outputs presentation-ready and professional.
The course is designed for anyone who wants to learn how to perform scenario and sensitivity analysis in Excel, especially for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions. The course requires some basic knowledge of Excel and financial statements.

Eligibilities

To be eligible for this course, you should have some knowledge of financial modeling or have completed a 3-Statement Modeling course. You should also have advanced Excel skills and be able to use functions and formulas such as CHOOSE, LARGE, SMALL, and data tables.