Scenario Management

Resolved · High Priority · Version 2010

Tue 17 Mar 2015, 16:15 Delegate Alex said...

Alex has attended:
Excel Intermediate course

Scenario Management

I am trying to set a value range to a changing variable. As an example I have a standard capital cost analysis whereby £3.5 generates up to 130 units and £5.5 equals 260 units etc etc. I am preparing a spreadsheet where I can input the number of units and the capital investment cell needs to be used bases on an interest per capital. I believe scenario management is the answer, as I have over 60 variable cells, can you please explain how I can complete this calculation

Tue 17 Mar 2015, 16:23 Trainer Andrew said...

RE: Scenario Management

Hi Alex

Thank you for your question. I wonder if data tables might be more helpful, based on your description. You can get an overview here

https://www.stl-training.co.uk/article-1194-how-create-data-table-in-excel-2010.html

and also from Microsoft directly at
http://support.microsoft.com/en-us/kb/282856

I hope this is helpful - let us know if you have any further questions.

Kind regards,
Andrew