What's the best way to use a database for distributed organizing? Can Salesforce even do this? Plus, beautiful, custom watercolor illustrations from the one and only Katie Blanchard.
Not knowing if a given scenario is easy or hard, or if there's an easier work-around to avoid a super-hard thing, feeds the overwhelm/impostor machine. It's so clarifying and liberating to just know what you're getting yourself into. PLUS, baby animal memes!
Special guest "Axolotl Questions" aka my mom (!!!!) comes to the Spreadsheet Whisperer with a question about how to organize poems for her upcoming research project.
Slicers, Subtotals, Tables, Ranges, Sort criteria, OH MY. We've got it all in this post about dealing with frustration, solutions, and spreadsheet empowerment.
In this installment of Dear Spreadsheet Whisperer, we hear from an old friend who's storing contact information in.... Quickbooks! I offer advice about how to make better use of contact segmentation features and how to begin to explore a better database system.
What do unicorns, squirrels, and building blocks have to do with healing the Admin / End User divide? Read more to see my answer to an illustrious Salesforce User who's looking for resources to support her organization's Admin team to connect with a non-technical audience.
In this installment of Dear Spreadsheet Whisperer, we use pivot tables, VLOOKUPs, and a mail merge to send top notch donor acknowledgement letters. Plus, gifs and cat memes!
A new motto to help us grow technological resilience. An infographic (kind of). A reflection on why this blog is so important to me. A double dose of imagination. And more!
How to use spreadsheets to sequentially number your rows (x+1 or date +1) OR undo it! Come for the gifs, stay for the puns!
It's time for end of year fundraising, so you export your data for volunteers, but then gifts come in and spreadsheets need to be refreshed. How do you handle the spreadsheet chaos? Meet my friend Ryan and how they can use good documentation to streamline this very confusing situation!
Plus, some good puns!