Next Live Workshop Dates
Workshop: About Financial Modeling
- Model design
- Cell referencing
- Reducing errors in financial models
- Assumptions documentation
- Bullet-proofing your model
đź“… Monday, 27 October 2025 UK US (Tuesday, 28 October 2025 Sydney)
⏰ 7:00 pm – 9:00 pm GMT (3:00 pm – 5:00 pm EDT) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Workshop: Excel Tools & Functions
- What’s new in Excel for Microsoft 365 or 2021
- Working with dynamic arrays
- Must-know Excel functions
- Financial functions
- Best practice for formula nesting
đź“… Tuesday, 28 October 2025 UK US (Wednesday, 29 October 2025 Sydney)
⏰ 7:00 pm – 9:00 pm GMT (3:00 pm – 5:00 pm EDT) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Workshop: Financial Modeling Techniques
- Linking the financial statements into a 3-way model
- Sensitivity & scenario analysis
đź“… Wednesday, 29 October 2025 UK US (Thursday, 30 October 2025 Sydney)
⏰ 7:00 pm – 9:00 pm GMT (3:00 pm – 5:00 pm EDT) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Workshop: Practical Financial Modeling
- Building a dynamic cashflow model
đź“… Thursday, 30 October 2025 UK US (Friday, 31 October 2025 2025 Sydney)
⏰ 7:00 pm – 9:00 pm GMT (3:00 pm – 5:00 pm EDT) (6:00 am – 8:00 am AEDT)
Field of Study: Basic Finance CPD / CPE Credits: 2
Course Overview
What we Cover:
You will learn the fundamentals of modeling techniques, best practice and how to design and create a user-friendly model.
The challenges:
Being able to accurately model and forecast is a critical skill for finance professionals, especially when considering a new project. This class explores the practical usage of Excel modeling techniques in a financial model.
During the session you’ll create your own model to take away and use for future reference. You will learn how to design and create a user-friendly model, which can then be used by anyone with limited knowledge of Excel.
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:
- Streamline model building by applying best practice functions, tools and techniques
- Apply commonly used formulas in new and different ways
- Deal with risk and uncertainty by creating scenarios and performing sensitivity analysis
- Build stress-tests, what-if and sensitivity analysis into your model by incorporating economic fluctuations
- Master key steps to get the most out of Excel functionality to improve your financial modeling
- Learn how to expedite and enhance the decision-making process
- Maximize your analytical abilities by learning conventional and new approaches of modeling
- Translate business concepts into logically structured models and formats
- Select which advanced formulas are appropriate in different situations
- Perform various advanced scenario modeling techniques
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 has years of experience and was able to solve any problems or questions we had in the course.”
Course Facilitator
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