Utah Community Learning

Wrapping up: keeping your sheets alive after class

About 15 minutes

Wrapping up: keeping your sheets alive after class

Okay sooo. This is the last lesson in this module, and it's kind of a weird one because I'm not teaching you a new skill. I'm just talking about what happens after class ends and you're on your own with this thing.

Because here's the thing. A lot of people build a really nice sheet in a class like this and then it just... sits there. Life happens, the sheet gets stale, and eventually opening it feels like guilt instead of useful. I don't want that for you. So let's talk about how to actually keep a sheet alive once nobody's making you touch it every week.

Give it a job, not a shrine

The sheets that survive in my house are the ones that answer a question I keep asking myself. Where's the money going. Is this contract up for renewal. Am I buying wipes at a reasonable rate (yes, that's a real one I built, don't ask).

The sheets that die are the ones I built because a sheet felt like the responsible thing to have. No question behind them, just vibes. If your budget sheet or your tracker doesn't have a question attached to it anymore, that's worth noticing. Either find the question again or let the sheet go. Not every sheet needs to live forever.

Autosave is not optional

I've said this before in this course and I'll say it one more time because it matters more once class is over and nobody's reminding you. Turn on autosave. Check that it's on. If you're in Excel and not using OneDrive, save manually and build the habit of hitting Ctrl+S like it's a tic.

I learned this one the hard way. Dawson, who was three at the time, dumped apple juice straight into the keyboard while I was mid-formula. I lost about twenty minutes of work because autosave was off and I hadn't saved in a while. Sticky keys, dead time, the whole thing. I turned autosave on that day and I have not shut up about it since. Don't be a hero about saving your own work. You will lose that bet eventually, and it's usually a toddler holding the cards.

Let it get a little messy

Not gonna lie, my actual home sheets are not pretty. There's a cell in my budget, B12, that for one whole day said "kkkkkkkk" because my daughter Lilly climbed into my lap while I was working and typed a straight line of k's into it. I saw it, laughed, and just left it there for a day because it made me smile every time I opened the file. Then I cleaned it up. Eventually.

The point is, a live sheet has fingerprints on it. Typos, a weird note to yourself, a cell that says "fix this later" that you never fix. That's fine. A sheet that's too precious to touch is a sheet you'll stop opening.

A once-a-month check-in, not a daily grind

You don't need to live in this sheet. Pick one small, boring recurring moment, first Sunday of the month, payday, whatever fits your life, and just open it and update it. Ten minutes. Check that your categories still make sense. Delete a formula that's clearly broken instead of letting it rot.

This connects to something I believe pretty firmly: you do not need forty categories to make a budget work. Five or six is plenty. If you're finding your tracker exhausting to update, the fix usually isn't more discipline, it's fewer categories. People quit not because they're lazy, they quit because they built something too detailed to maintain. Simplify before you give up.

Know what belongs on paper

Some of what we tracked in this course might genuinely belong on paper going forward, or in a note on your phone, not in a spreadsheet at all. I keep birthdays and anniversaries in a physical notebook, one page per month, and I've done that for years even though I do this for a living all day. It's just the right tool for that particular job. A sheet isn't automatically the better answer. Use whatever you'll actually keep using.

When a sheet breaks

If you come back to a sheet in a month and a formula's clearly wrong, don't panic and don't scrap the whole thing. Click into the cell, look at what it's actually pointing at, and ask "okay this is broken, why." Usually it's a reference that moved when you inserted a row, or a copied formula that dragged wrong. Fixable in a minute, most of the time.

Before next time

You don't have homework from me this time. Just open one sheet from this course sometime this week, even for two minutes, and see if it still feels useful. If it doesn't, that's information too.

  • C
Wrapping up: keeping your sheets alive after class — Spreadsheets for Everyday Use · Utah Community Learning