<< Click to Display Table of Contents >> Scenarios

iOS: The command is not freely available in this version.

The ribbon command Data | group Analyze | Scenario manager allows you to create and display "scenarios".

Scenarios can be used to observe how the calculations in a worksheet change when the values in specific cells are altered. This enables you to perform all kinds of "what-if" analysis.

Example: What effect on the total costs of a loan will it have when the duration is varied between 24, 36 and 96 months?

In this section you will learn everything you need to know about scenarios. The following topics are covered:

▪Creating scenarios

▪Showing scenarios

▪Managing scenarios

▪Merging scenarios

▪Creating a scenario summary

See the following pages for more information.