Microsoft 365 Excel – Use What if Analysis
This short introductory lesson on using What-if Analysis in Excel provides a quick overview of how to collaborate in the cloud and with artificial intelligence (AI) by using What-If Analysis, including Scenarios, Data Tables, and Goal Seek. The module provides informational videos covering key points and simulations demonstrating each of the steps necessary to achieve the learning outcomes, along with transcripts, closed captions, and additional resources expanding on the module’s topic.
- Use Scenarios to get what-if analysis for multiple variables (up to 32)
- Use Data Tables to get what-if analysis for one or two variables, with many values for each variable
- Use Goal seek to determine the potential inputs needed to produce a specific result
