Forecasting - changing data for creating different forecasts

[charlesfarrell]

Hi Everyone,

I am working on an excel project for my business analysts diploma.

I have a worksheet detailing student enrollments and finaces for a number of different colleges, I have historical data for 2015 - 2017 and forecasted data for 2018 - 2020, this shows my forecast based on the current circumstance.

I have two more worksheets, one for each new projection.

I am looking for a way to amend certain values in each projection to see how this affects the forecasting, maybe with a calculator or something!?! I have no idea how to do this so any advice on the best solution would be really helpful. I have attached the file so you can see what kind of data I gather

Any help anyone could provide would be greatly appreciated!

Thanks,
Charlie