Join Curt Frye for an in-depth discussion in this video Editing and deleting scenarios, part of Learning Excel What-If Analysis.
…The business environment changes all the time.…Labor and raw materials cost rise and fall, customer demand varies…over time, and you might choose to introduce or retire specific products.…In any case, you will probably need to edit…or even delete a scenario to meet your new situation.…In this movie, I'll show you how to change…or get rid of scenarios in your planning workbooks.…I will work with the EditAndDelete workbook which you can find in the chapter…one folder of your exercise files archive.…The first thing I need to do is display my scenarios.…
So I'll click the data tab on the ribbon.…And then in the data tools group, click what if analysis.…And then click scenario manager.…Doing so displays the scenarios that are available for the worksheet.…If I want to edit this scenario, all I need to…do is click it, and in is case I'll click high labor.…And then click the Edit button.…Doing so displays the Edit Scenario dialog box, which is exactly…the same as the Add Scenario dialog box, except for the name.…
- 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.