Multiple Scenarios

Create Multiple Scenarios in Microsoft Excel

The Scenario Manager in Microsoft Excel is part of the What IF Analysis tools feature found on the Data tab of the Ribbon. Users can add different scenarios all with different data sets, and then see the impact through the Scenario Manager.


It is recommended to create an actual scenario so that the intitial data set can be retrieved if required. Multiple scenarios can be added into the scenario manager and the results shown or displayed. However, there is a limit to the number of changing cells that can be used.


Use the scenario summary feature to compare results side by side. The current figures column is a duplicate of the last screen viewed; it can be deleted. Each summary sheet is a dead copy and not linked to the source data in anyway once displayed. Old summary sheets should be deleted to avoid confusion. It is advisable to create everything before any meeting takes place as it is a lot more difficult to produce the correct results on the fly.

Formulae in Scenarios

To create a formula, type the equals symbol first and then the formula. As soon as you click OK the formula is converted to a number and cannot be seen anymore. Before you start the process select the Actual option, otherwise the result may be incorrect.

Select courses here.

Select online courses here.

Training courses take three formats, one to one, classroom based or online sessions through Microsoft Teams. All courses have after course support available and training manuals and examples used are available on request.

Leave a Reply

You must be logged in to post a comment.


“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA