Address management can have as many pitfalls as Philadelphia streets have potholes! In this post, I explore best practices for keeping track of addresses, thanks to many of YOU! for writing in with questions to Dear Spreadsheet Whisperer.
Data cleaning is a “contact” sport
Like contact sports, "Contact Segmentation" has rules to learn and skills to develop... and sometimes it can make you feel sore/grumpy/bruised. In this post, I offer 4 "Rules of the Game" and 3 Skills that will help you make it to the clean data finish line.
Re-member-ships
Some ideas for "best practices" on managing memberships from The Spreadsheet Whisperer. If you structure your data properly, you won't have to remember when people re-member. Are you with me?
The Mail Merges Are Alright
The Mail Merges Are Alright: a mini-series dedicated to using Mail Merge to fuel social movements. In this post: anatomy of a Mail Merge and why changemakers should embrace the tool.
Not more than the sum of its parts
When you're setting up Sums, Subtotals, SumIfs (and more...) in Google Sheets - you might end up with more than you bargained for. Here to help you make sense of it all, the Spreadsheet Whisperer.
From “Confirmation Confusion” to “Confirmation Champion”
Confirmation Confusion wrote to Dear Spreadsheet Whisperer for help with hiding fields on their Newsletter Sign Up form. Now, they're ready to become Confirmation Champion!
Let me Google that for you
Well, with tech questions, it's not what you ask, it's how you ask it. It's the same with asking Google, Jeeves, (or me, The Spreadsheet Whisperer), when you need help with Excel. Here are some tried and true tips for asking good questions, so that you can get better, quicker answers.