Masterclass
6 Feb
3:00 PM
—
9:00 PM
Budget and Forecast Modelling in Excel
About the session
When embarking upon the budget process for your organisation this year, practical Excel tools and strong modelling skills will be critical. It’s never been more important to build robust, flexible and dynamic budget models to accurately predict business outcomes and handle the volatile economic inputs. Historically, the budget process involves pulling out the financials and rolling them forward, but last year’s actuals should not always be an automatic target.
What you'll learn?
By the end of the Masterclass, each learner will be able to:
- Calculate and apply phasing and seasonality to model drivers
- Apply the latest Excel tools such as dynamic arrays and date picker to your budget models
- Try true budgeting and forecasting techniques such as top-down, bottom-up, zero-based and flex budgeting
- Build sensitivities and break-even analysis into planning projections
This class will be delivered online-only. This is available as a single Masterclass or as part of our Premium Online Global Excel Summit ticket.
Get Tickets
Benefit from an award-winning 3-day conference plus access to exclusive networking and additional Masterclass events.