Naming Things So Future-You Understands Them
Okay. This lesson doesn't have a single new formula in it. I still think it might save you the most time out of anything in this whole module.
Here's the deal. Right now, while you're building your sheet, you know exactly what everything means. "Column C, that's obviously my markup." Sure. Today it's obvious. In March, when you haven't opened this sheet in six weeks and you're trying to figure out why your total looks wrong, Column C is just gonna be a letter. You will not remember what it's for. I promise you.
So this lesson is about naming things so future-you, who is tired and busy and does not have time to reverse-engineer your genius, can actually figure out what's going on.
Rename your tabs
Double-click any tab at the bottom of your sheet. Type an actual name. "Inventory." "Orders." "March Expenses." Not "Sheet1," not "Sheet2," not "Sheet2 (1)" because you made a copy of Sheet2 and Google just tacked a number on it.
I know that sounds tiny. It's not. When you've got six tabs and you're hunting for the one with your pricing on it, six clearly-named tabs beats six "Sheet4"s every time.
Label your columns like you're explaining it to someone new
Top row of every sheet, every column gets a header. Not "Amt." Not "Qty." Spell it out. "Amount Paid." "Quantity on Hand." You're not saving real time by abbreviating, you're just making future-you squint.
And if a column is doing something a little unusual, like it's pulling a price from another tab, put a note right in the header or the cell next to it. Right-click the cell, "Insert note," type yourself a sentence. "This pulls from the Pricing tab, don't delete that tab." Sounds paranoid. It's not paranoid, it's kind.
Name your ranges, not just your cells
This is the one people skip and I get it, it feels like an extra step. But if you're using the same chunk of cells over and over, say your list of product prices, you can actually give that whole range a name instead of remembering it's "Pricing!B2:B45."
Select the range, go to Data, then Named ranges, and just call it something like "ProductPrices." Now when you're writing a formula later, you can type that name instead of hunting down the cell reference. It reads like an actual sentence instead of a code you have to decrypt.
A word about clever formulas
I want to say this plainly because I've done the opposite and paid for it. The clever formula you're proud of today, the one that's three functions deep and does something slick, is the one you will not understand in five months. You'll open your sheet, see this tangle of parentheses, and think "what past-me monster wrote this."
Simpler is kinder to future-you. If you can write a formula in a more basic way and it takes one extra step but you'll actually remember how it works, do that. Every time. I'd rather have three plain formulas I understand than one fancy one I have to relearn from scratch.
Sooo, the spice cabinet story
Okay, I have to tell you this one because it's basically the whole lesson in one dumb late night.
I was building a lookup formula, this was probably year one of me really getting into spreadsheets, and it would not pull the right price. Kept giving me the wrong number or nothing at all. It was like 10:30 at night and I was convinced something was fundamentally broken about how I understood the tool.
So naturally, instead of looking harder at my formula, I went and reorganized my entire spice cabinet. Alphabetical first. Then I redid it by how often I actually use things, because who alphabetizes cumin next to cinnamon and expects to find anything fast. This took a while. This was not a five-minute break.
Daniel came in at some point, found me surrounded by little jars, and just went to bed. Didn't even ask.
The formula, when I finally went back to it? Typo in the column name. I'd named the header "Prise" instead of "Price" on one tab, and my lookup was searching for a column that technically didn't match. One letter. That's it.
If I'd had a clear naming habit already, actual full words in every header, checked twice, I probably would've caught that in thirty seconds instead of reorganizing my spice life at 11pm. Now when a formula breaks, before I touch anything else, I check my column names first. Every time. Learned that one the hard way, cumin jars and all.
Before next time
Go through your sheet and rename anything that's still called "Sheet1" or "Column B" in your head. Give your tabs real names, spell out your headers, and if you've got a range you use a lot, try naming it. Won't take long, and it's the kind of boring that saves you a spice-cabinet-at-11pm night later.