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.
Upon completion of this microlesson, learners will be able to do the following:
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