Manage Excel Scenarios
Microsoft Excel - From Beginner to Expert in 6 Hours
/ EXCEL DASHBOARD REPORTS
Back To Excel Model Analyzer Start & Demos
Manage Scenarios Use this tool to do any of the following:
1. Add a column with the same format as the other ones.
For example, you can add a column with "Year 2010" as heading.
2. Delete columns
3. Get the values output variables take when input variable values are changed in the model.
4. Change the values of the input variables in the model as you deem convenient.With the Scenario tables module option of the Scenario sheet wizard we have created the following scenario sheet:
In the following example, analyze the sales and sales cost from 2005 to 2007.
Enter the values of all input variables in the table.Open the Manage Scenarios dialog and click the Run button to get the values of output variables. You can select another set of values from the tables and run the tool as many times as
you wish and analyze their impact on the output variable (in the example, Gross Margin)WARNING
As you run the tool, the original values in your model are kept, but if you want
to replace that set of input variable values in your model, use thebutton
If you want to add or delete input or output values, use the Manage Inputs & Outputs tool.
Do not add columns manually, as this will result in errors. Use the Add-In to enter data
in an adequate and quick manner. This process is validated by VBA code.Back To Excel Model Analyzer Start & Demos
Model Analyzer for Excel
Secure Payment Options
Special! Free Choice of Complete Excel Training Course AND Excel Add-ins Collection on all purchases of Model Analyzer for Excel
1 Personal License $139.95 USD 2 - 5 Personal Licenses $118.95 USD 6 - 10 Personal Licenses $104.95 USD 11+ Personal Licenses $69.95 USD Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us
