Excel hell: how simple checksums can ease the pain of financial modelling
Cell-based modelling is a root cause of Excel hell. Some of the unavoidable issues include simple errors in formula construction; returning error values; errors in formulas dependent on other feeder cells that are only apparent later; and errors containing the notation #REF that make financial statement rollups unreadable.
At the most basic level, even very simple checksums can help you to maintain the integrity of every spreadsheet you construct. However, most people fail to plan this aspect, usually due to time pressures, but also because of a lack of expertise or even pure laziness. Therefore, why not build every new spreadsheet from a template already containing a basic checksum structure?
In this article, we show you how to do this so that there will be nothing to stop you from implementing checksums!
Continue reading
This content is not freely available. To access 'Excel hell: how simple checksums can ease the pain of financial modelling' you need to be one of the following:
ACA student
This content is available to ACA students. If you want to start the ACA qualification there are several routes you can take
Business and Finance Professional
An internationally recognised designation and professional status from the ICAEW.
Portfolio Careers Community
Practical support and guidance for finance professionals in an independent advisory role, from making the first step to having an established portfolio.