If you have ever taken over something like an HOA and thought, “Cool… now I’m in charge of a spreadsheet,” you are not alone.
This week I met with a sweet lady in Mesa, Arizona who we’ll call Marlene. She had recently stepped into the role of running her Homeowners Association. We sat right at her kitchen table, opened up her Mac, and got to work.
She was brand new to spreadsheets. Not “I’m rusty” new. More like “Why does this thing have columns and why are they judging me?” new. And honestly, that is fine. Spreadsheets are one of those tools that look simple until you need them for something real.
Step one: choosing the right spreadsheet tool
We started by looking at Apple Numbers. It is free, it is installed on a lot of Macs, and it can do plenty. But after poking around for a bit, I could tell it was not clicking for her. On her screen and resolution, it felt a little cramped and a little busy.
So I showed her Google Sheets.
Google Sheets is also free, and it is made by Google. The reason I recommended it was simple.
- It autosaves. Always.
- It lives online, so you can open it from a different computer.
- You can also pull it up on an iPad without doing anything fancy.
- It feels clean and straightforward for beginners.
Yes, Apple Numbers can do most of that too, especially with iCloud. But in this case, Google Sheets felt like the smoother on-ramp. And when someone is learning something brand new, smooth matters.
The real goal: keep the HOA list intact, but make it useful
Marlene already had a member list for the HOA. The problem was that it was hard to use. It had extra columns, it needed updates, and she had real-life tasks coming up that required different versions of the same info.
So we worked through it together.
- First, we added new members to the list.
- Then we went through dues and marked who had paid and who had not.
This is where a spreadsheet finally starts feeling useful. It turns into a living list that answers real questions quickly.
Next, she needed two separate lists for an upcoming luncheon. Not complicated, but if you are new to spreadsheets, it can feel like you are trying to defuse a bomb using only a mouse.
So we made two separate lists while keeping the original list intact.
That part is important.
A lot of people accidentally wreck the original file because they copy, paste, delete, and hope for the best. Instead, we treated the original spreadsheet like the master list and created new copies for the luncheon tasks.
A few simple spreadsheet tricks that made the difference
While I was making the edits, I was also explaining what I was doing so she could repeat it later. I always aim for that mix of “let me handle this” and “here’s what I’m doing and why.”
Here are a few things we covered that made everything easier.
- How to duplicate a sheet or make a copy so the original stays safe
- How to delete columns that are not needed for a specific list
- How to use shortcut keys to speed things up
- How to clean up the view so it feels less overwhelming
Once we trimmed the extra columns, her two luncheon lists became simple and readable. And that is the whole point. If the list is too cluttered, people avoid using it.
Printing, margins, and making it actually look good
Spreadsheets are famous for one thing when it comes to printing.
They print ugly by default.
So after we built the lists, we tackled printing. We adjusted margins, scaled things so columns fit, and made sure it would print cleanly on her printer without cutting off names or running onto seven pages for no reason.
Then I showed her how to create a PDF version too.
That way she could share it with a volunteer without worrying about formatting changing or someone accidentally editing the list. PDFs are a safe “read-only” format for sharing, and for HOA stuff, that matters.
Bonus: quick iPhone cleanup wins
After we finished the HOA work, we took a few minutes to look at her phone.
She had a ton of Home Screens. Like, “How far does this hallway go?” levels of screens. She told me she was constantly swiping and swiping just to find an app.
So I showed her how to:
- Remove icons from the Home Screen without deleting the app
- Remove entire Home Screen pages she did not need
That alone can make an iPhone feel brand new.
Then I noticed something else. Her phone screen was dimming and shutting off really fast, like every 15 seconds it felt like it was giving up on life.
The reason was Auto-Lock was set to 30 seconds.
I showed her where that setting lives, explained what it does, and she chose five minutes. Simple fix, big quality-of-life improvement.
The real takeaway
This visit was not about becoming a spreadsheet expert.
It was about taking a real responsibility, like running an HOA, and making the tools less intimidating.
By the time I packed up and headed out, Marlene had:
- An updated HOA member list
- Dues marked clearly
- Two clean lists for a luncheon
- Printed copies that look right
- A PDF she can share with a volunteer
- A cleaner iPhone Home Screen
- An Auto-Lock setting that does not drive her crazy
And she also had more confidence, which is honestly the best part. Most people do not need advanced tech skills. They just need someone to sit with them, explain it without making them feel dumb, and help them get the job done.
If you are in Mesa or the East Valley and you need help with spreadsheets, printing, PDFs, or just making your devices feel easier to use, that is exactly the kind of thing I do.