Dynamic Financial Forecasts
In an ‘Ask Ken Anything’ session, Ken Puls and the attendees worked together to build a forecast sheet that is fully dynamic so that is would update upon a data model refresh, forecasting the next two years of sales!
(Screenshot of chart showing sales figures from 2020-01-31 to 2021-12-31 and forecasted sales from 2022-01-31 to 2024-12-31)
(Skillwave Training Logo)
In an AKA session, I had a spontaneous question about budgeting and #FinancialForecasting techniques. That led us through several #Excel features including Goal Seek, Data tables and Excel’s built-in Forecast Sheet function, which resulted in a nice forecast sheet built against a #DataModel.