What should a social justice movement leader do when his spreadsheets aren't behaving properly? Email the Spreadsheet Whisperer, of course!
StreetStStrSt.AvenueAveAve. How many different ways can you write an address? Turns out... a LOT. Typically, when I am cleaning address data (yes, that's something I do quite regularly, what with being a spreadsheet whisperer and all), I am preparing to either (1) upload a single file into an online database or (2) create a mail … Continue reading How to compare addresses
What do my partner, date field formulas, and the Chicks have in common? Read this post to find out! Especially if you create time sheet systems to manage your workload!
What to do when you outgrow your grassroots spreadsheet systems? Try Airtable! It's flexible, freemium, and fun to use. Oh, and this is #NotAnAd!
In this edition of Dear Spreadsheet Whisperer, lessons about how to set up spreadsheets to ask hard questions about racial equity in schools.
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.
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!