Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 06th Oct'25 to 16th Oct'25
Forecasting in Excel: Scenario Planning with What If and Solver
- Forecasting fundamentals and best practices
- Structuring dynamic Excel models for planning
- Identifying key assumptions and drivers
- Using What If Analysis: Data Tables, Goal Seek, Scenario Manager
- Applying Solver for optimal solutions
- Modeling multiple scenarios and outcomes
- Linking assumptions to outputs and KPIs
- Communicating scenario results effectively
- Real-world examples of scenario planning
- Maintaining and updating forecast models
- Integrating scenario planning into regular business processes
- Avoiding common pitfalls in Excel forecasting
Overview of the webinar
Planning for the future is never straightforward. Small changes in assumptions—sales growth, costs, or market conditions—can significantly impact budgets and financial performance. Without scenario analysis, managers may be caught off guard by unexpected results.
This session provides practical, hands-on guidance for using Excel to forecast with multiple scenarios. You’ll learn how to apply What If Analysis to test different assumptions, build dynamic models, and anticipate financial outcomes. Participants will also learn how to use Excel’s Solver tool to find optimal solutions for budgeting, staffing, or investment decisions.
The course emphasizes clarity and usability. You’ll learn how to structure your forecast models, link assumptions to outputs, and communicate results effectively to stakeholders. Real-world examples will demonstrate how scenario planning can improve strategic planning, resource allocation, and risk management.
By the end of the course, participants will have the skills to build robust Excel forecasts, test multiple scenarios, and present actionable insights to support confident decision-making.
Who should attend?
- CEO, COO, Company Owners
- Small Business Owners
- Entrepreneurs, Sole Proprietors, Self-Employed Professionals
- Non-Profit Organizations
- Grant Managers and Fund Directors
- Business Management Professionals
- Vice Presidents, Directors, and Senior Officers
- Managers/Supervisors
- Board Directors/Members
- Business Brokers
- Investors or other Business Buyers
Why should you attend?
Forecasting is essential for business planning, budgeting, and decision-making, but real-world uncertainty makes it challenging. Excel provides powerful tools, like What If Analysis and Solver, to model different scenarios and evaluate potential outcomes.
This course teaches participants how to build flexible forecasts using Excel, so they can assess risks, test assumptions, and plan for multiple scenarios. By mastering these tools, finance professionals and managers can make more informed, confident decisions under uncertainty.
Faculty - Mr.Justin Muscolino
Justin brings over 20 years of wide-arranging experience in compliance, training and regulations. Most recently, he served as Head of Compliance Training at Bank of China where he led the compliance training function and created and monitored the annual training plan through a thorough training needs analysis. Previously he served as Macquarie Group’s Head of Americas Compliance Training and JPMorgan Chase’s Compliance Training Manager.Justin also worked for FINRA, a US regulator, where he created Examiner University to train examiners on how to perform their function.