Rolling forecastWe know that forecasting does not stop at the end of the financial year, and that updating models is both a significant effort and risk factor. Learn to build a rolling forecast, including dynamic formulas and dynamic seasonal linear trends using standard Excel functions.

No registration required; just click below to watch this complimentary ten-minute demo:

  • Building a rolling forecast can help you to reset your model to focus on time periods without using Lookup functions or adding infinite columns.
  • Dynamic formulas make your models flexible and changeable and can save you time while decreasing model risk. 
  • Automated forecasting tied to rolling forecasts provides a view to any period. In addition, it creates a  baseline, “naïve forecast” to compare actual results versus business projections.
  • Graphically integrating actuals, budget and forecast can help to deliver your finance message.


Access the files here