We 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.
Resources
★ View the external resources here.
