What-If Analysis in Excel – Recorded Excel Live Class
In this 1-hour class, we look at the awesome power of What-If Analysis in Excel. What If Analysis in Excel allows you to test out different scenarios without complex formulas.
In this tutorial we cover Goal Seek, Scenario Manager, Data Tables, and Solver. Once again, this class was hosted by the excellent Deborah Ashby.
In this What-If Analysis tutorial, we teach you:
- What is WhatIf Analysis and why is it useful?
- The PMT function –
- Three examples of Goal Seek in Excel
- How to work with Scenario Manager
- How to create a one-variable Data Table
- How to create a two-variable Data Table
- Introduction to the Solver add-in
Download the Excel file and follow along:
To learn Excel with Simon Sez IT. Take a look at the Excel courses we have available.
Other Excel classes you might like:
- Logical Functions in Excel
- Designing Better Spreadsheets in Excel
- Introduction to Power Pivot & Power Query in Excel
Take a look at more recorded live classes from Simon Sez IT.
For more Free Excel tutorials from Simon Sez IT. Take a look at our Excel Resource Center.
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
