Building a Rolling Forecast in Excel

Danielle Stein Fairhurst of Plum Solutions demonstrates how to build a rolling forecast, including dynamic formulas and dynamic seasonal linear trends (using FORECAST functions). We know that the world does not stop at the end of calendar year, and that updating models is both a significant effort and risk factor.
- 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.
This video was recorded for the Association for Finance Professional's DIY Automation Quick Study.
★ Access the files here ► www.afponline.org/publication...

[@gordonbarry3420]

This is exceptional!! Appreciate the fact you provide a Download, amazingly generous. Thanks

[@viansuperasistente]

Danielle, that's awesome! Had no idea of the forecasting formula. This will save a lot of time. Thanks for sharing your knowledge. I really appreciate it :D

[@plumsolutions]

Glad it was helpful!

[@indzara]

Thanks for sharing. I have not used the forecast functions so far, but your video triggered a lot of ideas. Thank you. Best wishes.

[@plumsolutions]

Glad it was helpful!

[@simsimsimsim4479]

Lovely! Thanks for sharing!

[@plumsolutions]

Thanks for watching!

[@njabulov.hadebe9102]

This is really cool, love your accent!

[@plumsolutions]

Thank you! 😃

[@wayneedmondson1065]

Interesting! Thanks for sharing :)) Thumbs up!!

[@plumsolutions]

Thanks for the visit

[@edersilvarodrigues]

Obrigado 👏👏👏👏👏👏👏👏

[@wilsonwambugu1572]

Hi Danielle. Thank you for this. I'm just starting out in PE back here in Kenya. Any advice on a financial modeling course i should consider?
A friend adviced me on FAST financial modeling.
Thanks

[@plumsolutions]

That's fantastic! Yes FAST is great, and you can also try my free intro course: plumsolutions.com.au/7-day

[@genesiabush6557]

Will this help me if i need to forecast for a call center

[@plumsolutions]

Yes, you can apply the concepts for sure.