98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Scenario Summary
Scenario Summary
Resolved · Low Priority · Version 365
Emma has attended:
Excel Advanced course
Scenario Summary
Would you be able to add data to scenario summaries to predict % increase for upcoming years. For example, I work with cancer stats, so would I be able to include total cancer stats for 2020,2021,2022 and based on average increase use the table to see how an average percentage increase for upcoming years?
RE: Scenario Summary
Hi Emma,
Thank you for the forum question.
If you have calculate average increase and want to predict future years it is not really a job for the scenario manage.
The advantage of the scenario manager is in a model with several variables.
Example:
We know that the cost for each different cancer treatments. We have predicted the increase in cancer patients for future years. We know the current capacity to treat cancer patients.
Then we could use the scenario manager to build different scenarios.
What will the cost be with the estimated increase and the current variety of cancer treatments and do we have enough capacity?
What will the cost be if the increase is higher than estimated and the future variety of cancer treatments are different than current and do we have enough capacity?
If the only variable is the percentage then you have no need of the scenario manager.
If You have calculated let us say the average increase to 5%. I would type 5% in a cell. Then I would use a cell reference to the cell with the 5% to add 5% to my 2022 numbers to get expected 2023 numbers and again add 5% to my 2023 numbers to get 2024. You can always chance the percentage in the cell to another percentage.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 27 Jul 2023: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Difference between Two DatesThe DATEDIF function computes the difference between two dates. The DATEDIF function is as follows: |