Next Live Workshop Dates
Workshop: Cutting-edge Financial Modeling
- What skills does a financial modeler need?
- Tool selection
- Rebuilding an inherited model
đź“… Monday, 10 November 2025 UK US (Tuesday, 11 November 2025 Sydney)
⏰ 7:00 pm – 9:00 pm GMT (2:00 pm – 4:00 pm EST) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Workshop: Advanced Excel Tools & Functions
- Sensitivity analysis with data tables
- Using LAMBDAs with dynamic arrays
- Introduction to 5G modelling
đź“… Tuesday, 11 November 2025 UK US (Wednesday, 12 November 2025Sydney)
⏰ 7:00 pm – 9:00 pm GMT (2:00 pm – 4:00 pm EST) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Workshop: Advanced Financial Modeling Techniques
- Building model schedules in depth
- Dealing with model circularity
đź“… Wednesday, 13 November 2025 UK US (Thursday, 14 November 2025 Sydney)
⏰ 7:00 pm – 9:00 pm GMT (2:00 pm – 4:00 pm EST) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Workshop: Advanced Practical Financial Modeling
- Building a 3-way funding model
đź“… Thursday, 14 November 2025 UK US (Friday, 15 November 2025 Sydney)
⏰ 7:00 pm – 9:00 pm GMT (2:00 pm – 4:00 pm EST) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Course Overview
What we Cover:
You will learn advanced techniques such as array formulas and data tables for sensitivity analysis and how to incorporate these into a fully functioning financial model.
The challenges:
In the ever-changing business environment, being able to accurately model and forecast the volatile economic inputs is a critical skill for business professionals. Build on your existing modeling skills and apply new techniques to better analyze financial data, predict revenues and cost and assess risks to justify business decisions in the most time-efficient and effective way.
The Barriers:
- Short-cuts and techniques to build a financial model in less time
Become super-efficient in Excel through intensive use of keyboard shortcuts and best practices to efficiently build an effective and robust model. - Experience designing solutions to real-world examples
Create a financial model based on real-world financial modeling challenges. Incorporate current economic uncertainties into the model in order to take more calculated risks and make more informed business decisions. - Analytical thought on fluctuating economic assumptions in financial modeling
Identify correct economic inputs to model and deal with fluctuations. Quantify uncertainty in forecasting models with stress-testing, what-if analysis and risk analysis techniques. - Knowledge on how to deal with uncertainty and risk in financial modeling
Explore the several different ways to perform scenario and sensitivity analysis in Excel and learn to model in detail the complex but most commonly used methods of showing scenarios using a combination of formulas and drop-down boxes
Learning Outcomes:
- Insights into defining the “uncertainties” that affect companies’ ability to produce accurate Financial Models.
- Advanced techniques to develop and manage more robust, multi-layered models to ensure maximised efficiency of financial models through in-depth use of functions and tools.
- Understand how to build for the “real world”, allowing for flexibility and future change.
- Streamline model building by applying best practice functions, tools and techniques.
- Structure financial models to be more efficient and flexible for continuous maintenance and future expansion.
- Application of effective simulation techniques to examine the risk of a project.
- Incorporate current uncertainties into the model in order to take more calculated risks and make more informed business decisions.
- Quantify uncertainty in forecasting models with stress-testing, what-if analysis and risk analysis techniques.
- Explore the many different ways to perform scenario and sensitivity analysis in Excel.
Business Benefits:
During the course, participants will hone their advanced modeling skills and experience designing solutions to real-world examples. Learn to efficiently build an effective and robust financial model based on real-world financial modeling challenges. Incorporate current economic uncertainties into the model in order to take calculated risks and make more informed business decisions.
“Danielle did a great job of teaching the subject matter in a clear and easy to understand way. Even for a seasoned Excel user, I learnt new easier techniques from the initial lesson. I was able to revamp my models at work by the second lesson.“
Course Facilitators
Danielle Stein Fairhurst
Course Facilitator
Danielle Stein Fairhurst, Principal Consultant at Plum Solutions, is an MBA qualified business professional with many years’ experience as a financial analyst.
Prerequisites: No Prerequisite knowledge is required to be successful in this course
Advanced Preparation: No advanced preparation is required
Program Level: Basic
Delivery Method: Group Internet