Join Curt Frye for an in-depth discussion in this video Showing and hiding scenarios, part of Learning Excel What-If Analysis.
…After you create a scenario, you can apply it to your worksheet,…to change the data displayed and the formulas that use the data.…In this movie, I will show you how to apply…and hide multiple scenarios to see how they affect your calculations.…For my sample file, I'll use the ShowAndHide workbook, which you…can find in the chapter one folder of your exercise files archive.…This file already contains a number of scenarios.…To display those I'll…click the Data tab, then in the Data Tools…group click what if analysis and click Scenario Manager.…
Doing so displays the Scenario Manager…with the scenarios that I've already created.…So I have three.…They are high labor.…High warehouse utilities and low inventory.…If I want to display a scenario inside of the…worksheet, all I need to do is select it such…as I've done here with the low inventory scenario and then click the show button.…So let's just take a quick look at the current state of the worksheet.…For inventory I have 1.6 million, 1.4 and…1.3 so with low inventory selected in the dialog…
- Explain how to create a scenario in Excel.
- Identify the two input values that should be used to create a two variable data table.
- Recall what the Excel feature Goal Seek is used for.
- Recognize the three things that must be separated from one another to make reading a worksheet with multiple units easier.
- Describe the tools that Excel provides to manipulate data.
- Break down the steps required to recalculate a worksheet's formulas.