My Rabbi asks for help sorting a spreadsheet, which pairs perfectly with my evolving plans to offer a Spreadsheet Chevruta program. Tune in for banter, reverence, tips, and .gifs!
pivot swivet
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!
it doesn’t have to be this way
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!
(re)portable
Imagine your data are stored in a database. When should you save a new report versus modifying a template? How should I tackle a reporting strategy? What kind of winter coat should I buy? These questions are all raised, and maybe answered!
How to save “versions” in Google Drive
How to save multiple versions of a doc in Google Drive... to the tune of "How to Save a Life" by the Fray. Come for the spoof, stay for the tips!
Ifs, Ands, AND Buts
Here's a recipe for how to use Pivot Tables, VLOOKUPs, If Statements, and the Concatenate function to take bigger data sets and manipulate them, saving you TONS of time so you can get back to organizing or putting your feet up. Plus, some lessons on segmentation. And some puns!
re”form” versus revolution
Government forms are notoriously awful! Good thing The Lab @ DC set out to redesign and re"form"at them! We could all learn from their example. Plus, some meta-analysis about my last post #WeWillNotBeErased. Come for the puns, stay for the learning!
syncing ship
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!
consistency is everything
What does cookie decorating have to do with spreadsheets? Consistency of course! Come for the Royal Icing recipe and stay for the tips about standardizing your data.
Do you learn from your mistakes?
What is a mistake? Let's use the etymology to learn some lessons about mistakes and spreadsheets. Plus, puns and a recommendation for learning more.
