The Spreadsheet Wizard — an illustrated card from The Accountant Arcana
I·the magician

The Spreadsheet Wizard

One pivot table between chaos and a client who finally understands their own numbers.

upright

As Below, So In The Pivot Table

Somewhere today, a mess of a general ledger export — forty thousand rows, three currencies, a column labeled 'misc' — is sitting open in front of you, and you are the only person in the building who can look at it and see the shape it wants to become. You drag a field into rows. You drag another into values. You watch total chaos fold itself, almost politely, into eleven clean subtotals. Nobody else in the meeting will understand what just happened, and that's fine — that's the whole trick.

The Magician's table has four tools and infinite possibility; yours has a keyboard shortcut for a pivot table and a SUMIFS formula you've had memorized since your second busy season. Today you conjure order from a spreadsheet that arrived looking like a crime scene, and you make it look effortless, because effortless is the performance. Nobody claps for a good VLOOKUP. You clap for yourself, quietly, alone, at your desk.

what may cross your path

  • A raw data export lands in your inbox looking unusable, and you fix it before your coffee's cold.
  • You build a formula so elegant you screenshot it just to admire it for a second.
  • Someone asks 'how did you do that so fast' and you genuinely don't know how to explain the keyboard shortcut.
  • A pivot table collapses forty thousand rows into one clean number a client can actually understand.
Trust the tool you already know cold. Today doesn't need a new trick, it needs you to run the one you've mastered, cleanly, without second-guessing it.

I already have everything I need open in front of me.

masterytechnical skillcontroltransformationquiet power
reversed · the shadow

N/A, N/A, N/A

The formula was perfect. You know it was perfect — you wrote it the same way you've written it four hundred times — and it returned #N/A anyway, three times in a row, and something in you that usually holds steady quietly gave out around the fourth try. A trailing space. A merged cell from years ago nobody ever unmerged. Something small and stupid is hiding in that lookup range, mocking you, and you will find it eventually, but not before you've questioned whether you actually know how spreadsheets work at all.

This is the Magician staring at his own table, momentarily convinced none of the tools are his. The power didn't leave — it's just buried under one bad cell reference, waiting for you to slow down enough to see it. It always is. You'll fix it in four minutes once you stop trying to fix it in forty seconds.

what may cross your path

  • A formula that's worked flawlessly for months suddenly returns an error with no visible cause.
  • You retype the exact same VLOOKUP three times, convinced the fourth time will somehow be different.
  • A merged cell or trailing space you can't see is quietly breaking a range you'd swear is clean.
  • You question, briefly and sincerely, whether you actually know Excel at all.
Step away from the keyboard for ninety seconds before your fifth attempt. The bug is almost always smaller and dumber than the panic makes it feel.

The error is small. My skill is not.

frustrationself-doubtsmall errorstechnical blockbroken confidence