Killing the Manual Roll-Forward (It Deserved It) | Sean Mooney
About the event
In this in-person session live in London, we will hear from Sean Mooney.
What to Expect You know the drill. It's working day three, the actuals have landed, and you're about to spend your afternoon dragging formulas, repointing ranges and whispering "please don't break" at a workbook held together by hope and paste-special.
There is a better way, and it doesn't involve VBA, macros or crying. Using a live MI pack and a three-statement model, Sean will show how modern Excel gives you time back:
• LET and LAMBDA: write a calculation once, give it a name, and never copy it across 400 cells again • SEQUENCE, FILTER and friends: date spines, actuals/forecast switches and roll-forwards that rebuild themselves when a new month arrives • Live Power Query tables feeding the whole thing, so "updating the actuals" becomes one click • Patterns you can steal on Monday morning, plus an honest view on when LAMBDA is genius and when it's just showing off
Suitable for anyone who builds management reporting or models in Excel and would like their evenings back.
This meeting will be held in Meeting Room 3 of Canada Water Library (literally next to the Canada Water DLR station)
Afterward, we will walk a few paces to Leadbelly's Bar & Kitchen for some drinks and chat.
