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.
Instructor
Tom Fragale