Scenario & Sensitivity Analysis in Excel (On-Demand - CFI)
Overview
Scenario and sensitivity analysis are critical tools for financial professionals to evaluate uncertainty, model risks, and make informed decisions. This course teaches how to build dynamic Excel models that adapt to multiple business cases, test key assumptions, and identify the variables with the greatest impact on outcomes. You’ll learn to use data tables, scenario managers, and visual tools like charts to communicate financial implications clearly. Whether working in investment banking, FP&A, or valuation, this course equips you to deliver more insightful, decision-ready analysis.
Access expires 180 days from purchase date |
Applicable for
Learning Objectives
By the end of this course, you will be able to:
- Build a dynamic scenario manager for different business cases
- Create outputs that clearly show which variables have the greatest impact
- Integrate sensitivity analysis using Excel best practices
Content
Course Content Created: July 2017
Course Content Updated: October 2018
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by CFI. Corporate Finance Institute (CFI) courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The instructions on how to access this course will be included on your registration confirmation.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
- 2.5
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 4
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Scenario & Sensitivity Analysis in Excel (On-Demand - CFI)
- 2.5
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 4
- Credits
Overview
Scenario and sensitivity analysis are critical tools for financial professionals to evaluate uncertainty, model risks, and make informed decisions. This course teaches how to build dynamic Excel models that adapt to multiple business cases, test key assumptions, and identify the variables with the greatest impact on outcomes. You’ll learn to use data tables, scenario managers, and visual tools like charts to communicate financial implications clearly. Whether working in investment banking, FP&A, or valuation, this course equips you to deliver more insightful, decision-ready analysis.
Access expires 180 days from purchase date |
Applicable for
Learning Objectives
By the end of this course, you will be able to:
- Build a dynamic scenario manager for different business cases
- Create outputs that clearly show which variables have the greatest impact
- Integrate sensitivity analysis using Excel best practices
Content
Course Content Created: July 2017
Course Content Updated: October 2018
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by CFI. Corporate Finance Institute (CFI) courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The instructions on how to access this course will be included on your registration confirmation.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.