Financial modelling is an essential skill that straddles business, accounting, and technology, and will continue to do so. In order to build good financial models, we increasingly rely on accessible and reliable data. Although the complexity of this data layer varies depending on the organisation and its level of maturity, all large organisations do eventually outgrow the unregulated “wild west” nature of spreadsheets. Transitioning from standard financial models in Excel to alternative solutions can feel like jumping out of the frying pan and into the fire. But what if there was a way to avoid this by remaining within the Microsoft ecosystem?

Watch these industry leaders in the next instalment in this virtual meetup series to discuss merging financial modelling and analytics with a scalable approach to leveraging Excel Innovation (DA & LAMBDAs) and other power tools in the Microsoft Stack such as MS Fabric.

At this special event, the panel showcase a breakthrough in financial modelling by demonstrating how to create a scalable financial model using Dynamic Arrays and LAMBDAs. We then explore the process of publishing and integrating this model into Power BI through the recently announced MS Fabric. The focus of the session will revolve around the challenges financial modellers face when dealing with large datasets – without having to rely solely on IT or external vendors for assistance. While the industry is currently captivated by AI and Copilot technologies, which will no doubt bring remarkable advancements to the process, they won’t solve the limitations of Excel when it comes to decision-making at scale.

Access the accompanying files
★ Watch Part 1 Future of Financial Modelling with ChatGPT – or not?