What-If Analysis and Scenario Manager

In this lesson, we will learn What-If Analysis and Scenario Manager in Excel. We will understand how results change under different assumptions and how to use Goal Seek, Data Table, and Scenario Manager through practical examples. ## Lesson objective In this lesson, we will learn What-If Analysis and Scenario Manager in Excel. In the previous lesson, we covered Dynamic Array Functions. We learned how to create dynamic lists, filtered reports, and formula-based summaries using , , , and . Now we move to an important topic used for decision-making and scenario analysis in Excel: What-If Analysis. A data analyst does not only analyze historical data.