Microsoft Excel: Using What-If Analysis-When, Why, and How 2018 is an event dedicated to training on Excel What-If Analysis. Learn about Excel Scenario Manager, Excel Data Menu, Excel Data Table, Excel Solver.
Topics
- Consider one approach for working around the 32-input limit built into Scenario Manager.
- Avoid writing repetitive formulas with Excel’s Data Table feature.
- Gain an understanding of Excel’s Goal Seek feature, which is useful in simplifying what-if analyses.
- Explore Excel’s Scenario Manager feature that enables you to store various sets of inputs, such as best case, worst case, and most likely, but without having to replicate worksheets or workbooks.
- Merge scenarios from other workbooks into your present workbook.
- Get a basic introduction to Excel’s Solver feature.
- See how to save Solver results to Excel’s Scenario Manager for reuse.
- See how to enable Excel’s Solver Add-in for more complex what-if analyses.
- Use the Summary Report aspect of Scenario Manager to compare different scenarios side by side.
- Use the FORECAST function in Excel 2016 to extrapolate trends based on existing data in your spreadsheets.
Who should Attend
- Marketing and Management Consultants
- CPAs and Accountants
- CFOs
- Bankers
- Financial Planners and Consultants
- Controllers
- Business Analysts
- Business Professionals
- Human Resources Staff
- Bookkeepers
