STYMStress-Test Your ModelScenario 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 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 1200+ programs annually, while 25,000+ professionals are equipped with up-to-date relevant education and the latest tech solutions across the EMEA region.We help our valued clients with a wide range of services, including Training Needs Analysis, Competency Development and Assessment, and custom-built e-Learning solutions that cater to specific industries and knowledge areas.LEORON mission remains boosting competitiveness of our clients worldwide through continuous learning, while we strive to achieve our vision of becoming the best quality corporate training and EdTech Company in the EMEA and the world.Whether our clients are facing difficulties re-organising their brand, equipping their workforce with an extra set of skills or aiming to assess competencies within an existing structure, our development planning is a great solution.LEORON’s mission is to help our worldwide clients boost their competitiveness by improving the competency levels of their employees, through top quality training and development solutions delivered by unrivaled global experts and facilitated by the best training managers in the industry.
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.