Join Curt Frye for an in-depth discussion in this video Summarizing scenarios, part of Learning Excel What-If Analysis.
…When you add scenarios to a workbook, it can be…difficult to remember exactly which values are in which scenario.…You might also step away from a workbook for…a few days or few weeks, and forget everything.…That's why its helpful to create a summary worksheet that…contains your worksheets original values, and the values of each scenario.…In this movie, I will show you how to create a…scenario summary and I'll base my work on the summarize workbook,…which you can find in the chapter one folder of your exercise files archive.…This workbook already has some scenarios applied to this worksheet.…
To display those, I'll click the data tab.…Click, what if analysis, in the data tools group, and click scenario manager.…When I do, the scenario manager dialog box opens and…you can see that I have three scenarios in it.…To create a summary worksheet,…I'll click the summary button.…Doing so displays the scenario summary dialogue box and I…can select the type of report that I want to create,…in this case I'll stay with scenario summary instead of…
- 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.