Forecasting in Excel: Scenario Planning with What If and Solver

Id: 8759
Recorded
Session
$159.00
Single Attendee
$359.00
Group Attendees

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 40 years of professional experience. He is a Microsoft Certified Trainer, and a Microsoft Certified Expert in Excel. He has trained over 45,000 businesspeople in on-line webinars, public seminars, and on-site training sessions. 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 a trainer on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, ChatGPT, PowerBi, and CoPilot, 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 and another book on Excel Pivot Tables. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.