Home > Skills > Data Entry > Scenarios Excel Scenario SummariesAfter you create 2 or more different Scenarios in Excel, use a Scenario Summary to show an overview of the data. This is a static report that is designed to show the Scenario data at a moment in time. |
Introduction - Scenario SummaryA Scenario is one of Excel's built-in What-If Analysis tools, along with Goal Seek and Data Table. Use Excel Scenarios to store several versions of the data in a worksheet. For example, when preparing an annual budget, the Marketing and Finance departments may have different forecasts for sales.
You can store each department's forecast as a Scenario. Then, print the scenarios separately, or compare them side-by-side, with Scenario Summary reports. |
Scenario Summary WarningBefore you build a Scenario Summary, it's important to keep this limitation in mind:
To avoid confusion later, with outdated information in a Summary Report, I recommend that you take one of the following precautions:
|
Before Creating a Scenario SummaryBefore you create a Scenario Summary, name the Scenario input cells on the Excel worksheet. This will make it easeir to read the data that's in the Scenario Summary. The report will show the variable cell names, instead of the input cell worksheet addresses. In the budget example screen shot shown above, the following names were created (there are Naming instructions here: Name a Range).
|
Video: Create a Scenario SummaryTo see the steps for creating an Excel Scenario Summary, and adding Scenario to the Excel Ribbon, watch this short video. Written instructions are below the video |
Create Scenario SummaryAlthough Excel scenarios can be complex, I've used a simple example here. The annual budget forecasts from two departments, Finance and Marketing, have been entered in an Excel workbook, and stored as Scenarios. To see the two budget scenarios side-by-side, and compare them, you can use a built-in tool - the Excel Scenario Summary. Open Scenario ManagerTo ollow these steps to create a Scenario Summary report:
The Scenario Manager dialog box opens, where you can see a list with each Scenario name. |
Build the Scenario SummaryTo create the Scenario Summary, follow these steps:
|
Get the Scenario Sample FileGet the zipped sample Excel Scenarios file. The zipped file is in xlsx format, and does not contain any macros More Tutorials |
Last updated: December 25, 2022 2:29 PM