Summarizing scenarios


show more Summarizing scenarios provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Creating Business Budgets show less
please wait ...

Summarizing scenarios

One tremendous advantage to working with scenarios in Excel is that they're only visible when you show them in the worksheet. Of course, that's their disadvantage as well. Unless you copy a scenario's values to another worksheet, you can't recall them without opening the Scenario Manager. However, Excel does let you create just such a worksheet summarizing all of your scenarios in the single place you can leave in your workbook, copy to another workbook, or print. To do that you create what's called a scenario summary worksheet. Before you create it though, you must ensure that no scenarios are applied when you create the summary worksheet.

I'll show you when I get over there, but first let me create the summary worksheet. To do that, click What-If Analysis and once again we're on the Data tab. Click Scenario Manager and then click Summary. We want a scenario summary, and the cells that are changing as a result of the changes within the scenarios are E7 and D13. Cl...

Summarizing scenarios
Video duration: 2m 18s 1h 3m Intermediate

Viewers:

Summarizing scenarios provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Creating Business Budgets

Subject:
Business
Software:
Excel
Author:
please wait ...