Skip to content
Utah Community Learning

Where to go next and what I don't teach

About 15 minutes

Where to Go Next and What I Don't Teach

Okay. This is really it. Last lesson of the whole course.

I want to spend it on two things. Where you go from here, and being honest with you about what I'm not the right person to teach you. Both matter more than they sound like they would.

Where to go next

You now have an inventory tracker, an invoice system, and a dashboard that pulls from both. That's genuinely the core of running a small business on a spreadsheet. Most people never build all three. You did it in six weeks.

Sooo here's my actual advice: don't add anything new for a month.

I mean it. Use what you built. Let it get lived-in. You'll find the rough edges way faster by using it for real invoices and real inventory counts than by imagining what you might need someday. A spreadsheet that's actually being used teaches you more than a tutorial does.

After a month, if something's bugging you, that's your next lesson to go learn. Maybe it's "I wish this column auto-filled." Maybe it's "I want a second dashboard for my slow season." Let the annoyance point you toward what to learn next instead of guessing.

What I don't teach

I want to be straight with you about three things, because I'd rather you know the edges of what I know than find out the hard way.

Pivot tables. I can make one work if I really have to, but pivot tables and I have a complicated relationship 🙈. I don't fully trust myself with them, and I'm not going to stand up here and pretend I do. If you get to a point where you're managing hundreds of rows of sales data and you need to slice it a dozen different ways, a pivot table is probably the right tool. Just know you'll want a different teacher, or a good afternoon with the help articles, for that one.

Apps Script, macros, that whole automation layer. Some people build actual mini-programs inside their spreadsheets. Auto-send an email when a cell changes, that kind of thing. That's a different class taught by someone smarter than me on that front. I know it exists. I know it's powerful. I have never needed it for the stuff I actually run, and I'm not going to fake my way through teaching it to you.

The "why" behind some formulas. Sometimes I know a fix without being able to fully explain the mechanics of why it works. I'll tell you "put a dollar sign there" and it'll work, and if you ask me to explain exactly what's happening under the hood, sometimes I've got a real answer and sometimes I've got "it just does, trust me." I'd rather admit that than make something up that sounds smart.

None of that means you can't learn those things. It just means you shouldn't learn them from me, and you definitely don't need them yet. Ninety percent of running a small business off a spreadsheet is a SUM formula, a lookup, and knowing roughly what your numbers should be before you look. You've got all three. That's the whole game for a long while.

A story before I let you go

My husband Daniel fixes up bikes on the side. For about a year he wouldn't track any of it. Cash in a coffee can, basically. Numbers in his head. It drove me a little nuts, honestly, because I could see exactly what he needed and he just would not sit down and do it.

So I built it for him. One page. No fancy stuff, no dashboard, no color coding. Just what came in, what parts cost, what he charged. That's it.

He uses it now. Every time. Won't admit I was right about it, but he uses it, and that's the same thing.

I tell you that because I want you to remember: the simplest version that actually gets used beats the impressive version that sits there. You didn't need to build anything as complicated as what we built in this course. You could've stopped after week two with just the inventory tab and been better off than most people. Everything past that was bonus.

One last check against reality

Before you close this out and start running your business on this thing for real: go count something. Physical boxes, actual cash in the drawer, whatever you've got. Check it against what your sheet says. A spreadsheet will tell you a very confident wrong number if something's off, and it won't feel wrong, it'll just sit there looking right. Trust it, but check it. Every time, not just once.

That's the class. Thank you for building something real instead of just watching me build one. That's the part that actually sticks.

Before next time: there isn't one, there's just Monday. Open your dashboard on Monday morning like you actually run a business now. Because you do. ❤️

Where to go next and what I don't teach · Google Sheets for Small Business Owners · Utah Community Learning