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.
-
ICAEW member
-
Gain access to world-leading information resources, guidance and local networks. 98% of the best global brands rely on ICAEW chartered accountants.