No Forecast Sheet In Excel Mac. The forecast.ets function on excel calculates seasonal results using an exponential smoothing algorithm. If the problem still occurs, quit excel, restore the file to its original location, and go to the next step.
New forecasting capabilities we also revamped the forecasting capabilities provided in excel 2016. Select the range a1:b13 shown above. In previous versions, only linear forecasting had been available.