Epistemic status: Passion project / domain I’m pretty opinionated about, just for fun.

In this post, I walk through some principles I think good spreadsheets abide by, and then in the companion piece, I walk through a whole bunch of tricks I've found valuable.

Who am I?

I’ve spent a big chunk of my (short) professional career so far getting good at Excel and Google Sheets.[1] As such, I’ve accumulated a bunch of opinions on this topic.

Who should read this?

This is not a guide to learning how to start using spreadsheets at all. I think you will get more out of this post if you use spreadsheets at least somewhat frequently, e.g.

• Have made 20+ spreadsheets
• Know how to use basic formulas like sum, if, countif, round
• Know some fancier formulas like left/mid/right, concatenate, hyperlink
• Have used some things like [...]

---

Outline:

(00:34) Who am I?

(00:48) Who should read this?

(01:20) Principles of good spreadsheets

The original text contained 3 footnotes which were omitted from this narration.

---

First published:

Source:

Narrated by TYPE III AUDIO.