Forecasting in Excel: Scenario Planning with What If and Solver
Date:
Wednesday, October 15, 2025
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
60 Minutes
More Trainings by this Expert
Product Id : 507581
Price Details
Live: One Dial-in One Attendee
Corporate Live: Any number of participants
Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Overview:
Forecasting in Excel uses What-If Analysis and Solver to analyze different scenarios and find optimal outcomes.
What-If Analysis includes Scenario Manager, which allows you to create and store different sets of input values to compare against each other, and Goal Seek, which finds the input needed to achieve a specific result. Solver, an add-in, is used for complex optimization, allowing you to find the maximum or minimum value of a cell while adhering to set constraints.
This webinar will show how to forecast using the tools built into Excel.
Areas Covered in the Session:
- What if Analysis Tools
- Scenarios
- Goal Seek
- Data Table
- Solver Addin
- Forecasting Tool
- Forecasting in Charts
- Data Analysis Tools Addin
- Histogram
- Correlation
- Rank and Percentile
Who Will Benefit:
- Business Owners
- CEO's / CFO's / CTO's
- Managers Of All Levels
- Anybody who uses Excel on a regular basis, and want to be more efficient and productive
- Administrators
- Salespeople
- Trainers
- Bankers
- Office Workers
- Finance Professionals
- Accountants
Speaker Profile
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, and a Microsoft Certified Expert in Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training.
His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects.
His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
