Do not start by reading formulas. Rebuild the figures, put them side by side, and let the differences show you where to read.
The fastest reliable way to audit a spreadsheet you did not build is to rebuild its key figures independently, compare them one by one with a tolerance, and read the formulas only where the figures differ. In our worked case, 7 of 20 figures in a received summary do not match, and five root causes explain them. Each wrong figure looked plausible.
The case comes from the AI in Excel for Analysts course by Julian R. Sterling, author of The Real Estate Asset Manager.Get the DRM-free PDF, $19.99 →
| Measure | Alder House | Birch Court | Cedar Yard | Dunmore Park | Portfolio |
|---|---|---|---|---|---|
| Lettable area (sqm) | -300 | -300 | |||
| Passing rent (EUR k) | -60.0 | -60.0 | |||
| Vacancy rate (points) | +0.57 | ||||
| WALT (years) | -0.008 | +0.017 | |||
| Figures flagged | 1 | 0 | 1 | 2 | 3 |
A flag is one formula per figure: =IF(ABS(difference)>tolerance,1,0). Without a tolerance, rounding would flag everything. The count goes in your reply: 7 of 20.
| Figure | What the formula does | What it should do |
|---|---|---|
| Area of Dunmore Park | Adds the criterion use = Logistics | Property only: the site has one office unit |
| Rent of Alder House | Selects offices only | Every unit of the property, including the retail unit |
| Vacancy of Cedar Yard | Divides by the let area | Divides by the total lettable area |
| WALT of Dunmore Park | Weights by area | Weights by passing rent |
| WALT of the portfolio | Averages the four property WALTs | Weights every lease by its rent |
The two other flags are portfolio totals that inherit the area and rent errors. Report causes, not cells: what the formula does, what it should do, which figures it affects and by how much.
Give it the suspect formula as text, the layout of the data, the intended definition, and the two figures. Ask how the formula differs from the definition and which rows would explain the gap. Do not ask whether the model is correct: an assistant asked for a verdict tends to give a reassuring one. It can read a formula faster than you; it cannot know which definition your firm uses.
A difference says the two versions disagree, not who is right. Trace each gap to the rows. Your own figures deserve trust only if they pass their tests on a small sample and their totals tie by two routes.
Five kinds of error account for most findings: a range too short, too long or drifting; a number typed over a formula; a logic error in a criterion, a base or a weight; a unit or sign error; and a stale input. All five errors of this case were logic errors, the kind that returns a plausible number.
Every figure is computed by script from the course's running case, the Brackenridge portfolio, a fictional rent roll of 20 units, and checked on 19 November 2026. Function availability depends on your version of Excel. For education, not investment advice.
26 short video lessons on using an AI assistant in Excel without being wrong: the five-part brief, SUMIFS, SUMPRODUCT, INDEX and MATCH, a mini sample with a known answer, checks that tie and the audit of a received model. You build a checked summary from a rent roll, with step files, exercises, a prompt kit and a certificate exam ($149).
Rebuild the key figures independently, compare them with a tolerance, and read the formulas only where the figures differ.
By root cause: what the formula does, what it should do, the figures affected and the size of the effect. A list of cell addresses does not help the author.
It can read a suspect formula and say how it differs from a stated definition. It cannot know your definitions or see the data unless you provide them, and a request for a verdict gets a generic answer.
This article is one calculation from The Real Estate Asset Manager. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
See the course →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the PDF edition, $19.99