Spreadsheets Are Arguments: Excel Skills That Persuade

Every spreadsheet that matters is making a claim: this budget balances, this forecast holds, this project pays for itself, we can afford the hire. Yet most spreadsheets are built like piles instead of arguments — numbers typed where they fit, formulas copied until they stop, the key assumption buried in a cell nobody can find. The reader is left trusting a bottom line they cannot inspect, and the builder is left defending a conclusion they cannot fully explain. Spreadsheet skill at work is not really about functions and shortcuts. It is about building a case in numbers that another person can follow, test, and believe.

Structure is the argument

A persuasive spreadsheet separates its parts the way a good brief separates its sections. Inputs live in one place, clearly labelled, so anyone can see what was assumed and change exactly that. Calculations build from the inputs and from each other — never from constants typed silently into the middle of a formula, which is where arguments go to hide. And the conclusion sits where a conclusion belongs: up front or clearly marked, not discovered by scrolling. This structure is not tidiness for its own sake. It is what makes the sheet discussable. When a manager asks “what if volume is lower?”, a structured sheet answers in a minute. An unstructured one answers in a rebuild — and the meeting moves on without the answer.

Check like a skeptic, present like an advocate

Arguments get tested, so build for the test. Cross-foot the totals a second way and make the two agree. Sanity-check the outputs against reality: does this margin resemble any margin the business has ever earned, does this growth rate have a story attached? Run the assumption you are least sure of up and down and look at what breaks — a conclusion that survives its own sensitivity test is worth presenting; one that flips on a half-point assumption deserves a warning label, and honest builders attach it themselves. Then present in the order decisions are made: the headline number first, the reasoning in plain language, the machinery one click away for whoever wants it. Formatting is part of the honesty — consistent units, rounding that doesn’t smuggle in false precision, dates on everything.

Build it to be handed over

The final test of a spreadsheet argument is whether it survives its author. Workbooks outlive the project meeting: they get reopened next quarter by a colleague, audited by a stranger, updated by someone who was not in the room. A sheet built as an argument hands over gracefully — the inputs labelled, the method visible, a short note on the first tab saying what the workbook claims, where its numbers come from, and when they were last true. A sheet built as a pile hands over as a liability: the successor either trusts it blindly or rebuilds it from scratch, and both responses are expensive. Version discipline belongs to the same craft. One workbook of record, dated and named so the current version is unmistakable, beats five near-identical copies drifting through inboxes — because an argument that exists in five versions simultaneously is, in practice, an argument nobody has actually made.

None of this requires advanced technique. It requires treating the spreadsheet as what it already is in the life of the company: a piece of persuasion that decisions ride on. The professionals whose numbers get trusted are not the ones with the most elaborate models. They are the ones whose work a skeptic can follow to the same conclusion — because it was built, from the first cell, to be followed.

← All Insights