Utah Community Learning

Okay who here just types numbers into boxes

About 15 minutes

Okay who here just types numbers into boxes

Okay sooo. First real question of this whole course, and I ask it every time I teach this: who here has opened a spreadsheet and just... typed numbers into boxes. No formulas, no plan, just numbers going in because that's what the boxes are for.

If your hand went up, good. That's most people. That's honestly almost everyone the first time, and probably the second and third time too. I'm not asking to embarrass anyone. I'm asking because once I know that's where a room is at, I know exactly what to teach next.

Here's the thing. Most people don't actually have a spreadsheet problem. They have a question problem. You open a blank sheet and it's terrifying, not because spreadsheets are hard, but because there's no question living in it yet. A blank grid doesn't know what you want from it. Neither do you, half the time, which is why you end up just... typing numbers into boxes.

Start with the question, not the sheet

Before you open anything, say your question out loud. An actual sentence. Not "I should track spending" but something like:

  • "How much did we spend on groceries last month compared to the month before?"
  • "Which of my three kids' activities is actually costing me the most?"
  • "Am I actually saving anything or just moving money around?"

Notice none of those are "make a budget." Making a budget is a task. Knowing where your money went in December is a question. Questions are what spreadsheets are good at. Tasks are what make you stare at a blank sheet for twenty minutes and then close the laptop.

Write your question on a sticky note if you have to. I'm serious. Stick it on the monitor. When you get lost later, and you will, that sticky note is what gets you back.

A small at-home exercise

Try this before our next session, it takes ten minutes:

  1. Pick one real question you have about your own life right now. Money, time, meal planning, whatever. Something you genuinely don't know the answer to.
  2. Open a blank sheet.
  3. In row 1, type column headers that would let you answer that question. Just headers. No data yet.
  4. Stop there. Don't fill anything in. Just look at whether the headers actually answer your question if they were full of real numbers.

That's it. If your headers don't get you to an answer, that's useful information too. It means the question needs to get more specific, and that's fine, that's normal, that's most of week one for everybody who's ever done this.

Turn on autosave now, while you're thinking about it

While you've got the sheet open for that exercise, go find the autosave toggle and turn it on. Right now. I'll wait.

I say this every course and I'll keep saying it. Manual saving is a bet against toddlers, and toddlers win. Mine did, literally, with a cup of apple juice and a keyboard, and I lost about twenty minutes of formula work I did not feel like redoing that day. Autosave went on within the hour and it has not gone off since.

If you're on a shared or public computer, obviously don't save anything with personal financial info sitting around after you're done, that part's just common sense. But for your own device, your own file, autosave is not optional in my class. It's the one rule I actually enforce.

A word on pace

Not gonna lie, I had a stretch a while back where I had three things back to back to back, all needing my full attention, and I ran completely out of gas. I had to cancel plans with a friend last minute over text, which I hate doing, and afterward I wrote one word in the front of my little notebook: "batteries." Just a reminder to myself that I run out, same as anyone.

I bring that up because this course is going to move in short chunks with real breaks, on purpose. If today felt slow, that's intentional. We're not doing a marathon session. Spreadsheets reward patience way more than they reward cramming, and so do people, honestly.

Before next time

Do the ten-minute exercise above, headers only, no data. Bring your question and your headers next time, even if you think they're wrong. Wrong headers are still a great place to start a real conversation.

  • C
Okay who here just types numbers into boxes — Spreadsheets for Everyday Use · Utah Community Learning