Loading component...
Overview

CPA Members only
CPA Australia has partnered with the Corporate Finance Institute (CFI) to curate a collection of professional development courses exclusively for CPA members. CFI courses have an emphasis on hands-on, practical learning and skills acquisition. They teach in-demand industry practices, tools and techniques that help accounting and finance professionals build confidence, stand out from the competition, and make a positive impact on their careers.
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. Youll 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.
CPA Australia handles your personal information in accordance with the CPA Australia Privacy Policy. By proceeding you may be redirected to an external website to access the course.
Our Privacy Policy includes the following statement under the subsection Links to other websites:
- We may provide links to websites operated by third parties.
- We are not responsible for the privacy practices or the content of such websites which will be governed by their own privacy policies to which you are advised to refer.
Your satisfactory completion of the training module may be recorded against your CPD hours.
CFI programs will be supplied to CPA Australia members as standalone courses for 12 months from the date of purchase and as such, any associated CFI certifications are not able to be supplied. Refunds or extensions for purchases of CFI courses will only be available in exceptional circumstances and will be based on CPA Australia and CFIs cancellation terms.
Course partner
What you'll learn
- 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.
