Excel: A Financial Modelling System
Abstract
Since the calculation engine of Excel was the subject of a major upgrade to accommodate Dynamic Arrays in 2018, there has been a series of seismic changes to the art of financial modelling. This paper will show the traditional financial modelling techniques for spreadsheets can be replaced by radically different approaches that have significant gains in readability, performance and flexibility. With so much power added to the Excel engine in recent years, it is the responsibility of financial modellers to ensure that they are building in the simplest and most auditable way possible going forward.
- Journal ref
- Proceedings of the EuSpRIG 2026 conference 'Spreadsheets, AI Agents, Trust, and Governance' ISBN 9781-905404-61-2 1-905404-61-2 Copyright 2026, European Spreadsheet Risks Interest Group and Authors