Forecast sheet versus exponential smoothing in analysis toolpak
I would like to understand if there are differences between these 2 functions in excel? I read that the forecast sheet is based on exponential triple smoothing aaa version which is essentially the same as holt winters. How about exponential smoothing in analysis toolpak? They sound identical
Projecting Data Figures - Years in Advance
Hello everyone! I'm sailing into unchartered territory in Excel and am quite stumped and endless searching on the internet hasn't helped me too much to find the answer that I'm after. I'm needing to project future year totals from the data I've been provided. I've got figures of jobs per industry from years 2012/2013 and then in 2017/2018 which leads to a positive or negative change after 5 years. I'd like to forecast what changes there'd be in another 5 or so years time but can't get my head around on how to do it exactly. Any information would be very much appriected! I've attached my excel spreadsheet with the relevant data that I'd like to project from.