A what-if analysis tool that allows you to save and switch between different sets of input values for a model.
Provalo con l'IAScenario Manager enables users to create, store, and compare multiple versions of data inputs within a single worksheet. It is particularly useful for modeling best-case, worst-case, and expected-case outcomes without manually overwriting cells.
A financial analyst uses Scenario Manager to store three different sets of interest rates and tax percentages to see how each affects the final net profit.
Scenario Manager is best for comparing discrete sets of multiple variables, whereas Data Tables are designed to test a range of values for one or two specific variables.