SSAEScenario and Sensitivity Analysis in Excel
Rating:
English
Advanced
Face to Face
Instructor-Led Training
(F2F-ILT)
Virtual
Instructor-Led Training
(V-ILT)
COACHING
& MENTORING
(C&M)
Self-Paced
Learning
(SPL)
Select Date
Download Brochure
Course Overview
Stress-Test Your Model addresses one of the most common failure points in financial modelling: models that work perfectly under the base case and fall apart the moment an assumption changes. Built for financial analysts and FP&A professionals, this course teaches delegates how to design scenario and sensitivity analysis directly into Excel models, so that a change in one input flows cleanly th
Key Takeaways
1
Build scenario toggles that let a model flex across multiple assumption sets
2
Construct sensitivity tables that isolate which inputs actually drive the output
3
Apply what-if analysis to test a model's robustness before presenting it
4
Identify hidden fragilities in an existing model under time pressure
5
Present a model's range of outcomes with confidence rather than a single fragile number
Certifications
LEORON - Professional Development Institute
LEORON Institute is the leading corporate training and EdTech company in the EMEA region, with the most comprehensive learning and development solutions in all strategic corporate functions, including Corporate Finance, HR, Procurement and SCM, Technology, Quality, Operations and Engineering. Through instructor-led sessions, in-company training, and coaching, our faculty of experts deliver over 2,000+ programs annually, while 50,000+ learners are equipped with up-to-date relevant education and the latest tech solutions across the EMEA region.
As a NASBA-registered CPE sponsor with a KHDA educational services permit in Dubai, LEORON also offers selected professional certifications eligible for HRDF reimbursement in Saudi Arabia.
As a NASBA-registered CPE sponsor with a KHDA educational services permit in Dubai, LEORON also offers selected professional certifications eligible for HRDF reimbursement in Saudi Arabia.
Course Outline
1. Why static models fail under changing assumptions
2. Designing scenario switches into a model
3. Building sensitivity tables that isolate key drivers
4. What-if analysis using Excel's built-in tools
5. Live pressure-testing of a model against best- and worst-case scenarios
Who Should Attend?
This course is aimed at financial analysts and FP&A professionals who build or maintain models used in real planning and decision-making. It is particularly valuable for anyone who has presented a model that later broke under a simple change in assumptions and wants to prevent that from happening again.
FAQ
What Excel skill level does this assume?
Delegates should be comfortable building formulas and basic models already; this course focuses specifically on stress-testing technique rather than foundational Excel skills.
How does this connect to the Financial Modelling Master program?
This course covers one critical skill within that broader five-day Advanced Diploma, making it a practical entry point or refresher for those considering the full program.
Is this delivered hands-on or as a lecture?
The course is fully hands-on, with delegates building and stress-testing models live throughout.