Ahh, nothing like a good pep talk to make you feel validated. When I can't cheer you on, try data validation tools to add "dropdown menus" inside of your spreadsheets. Google Sheets and Excel users will both find something of value here. Read more for useful tips and tutorial videos.
spreadsheet bliss
Isn't it great when spreadsheets just WORK, making your repetitive tasks faster and more accurate? Here are two examples of spreadsheet tools I've built with a combination of Salesforce exports and spreadsheet prowess. Using them makes me feel proud and blissful!
expand, contract
Spreadsheets or life-in-general bringing you stress? Here's a tutorial about how to wrangle your spreadsheets with the "Group Rows" function. Plus, a mindfulness exercise!
“Change management” for change-makers
What does the moon, popcorn, and caterpillars have in common? Changing phases, of course! This post is all about getting better at change management. BONUS: my favorite lil dumpster fire meme makes a cameo appearance!
Black Lives Matter at School! 3 ideas for teaching spreadsheet fundamentals
In this edition of Dear Spreadsheet Whisperer, I offer 3 creative ideas for how to introduce spreadsheet fundamentals in the classroom. *Signal Boost* Black Lives Matter at School week of action is Feb 4-8 this year!
my people
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!
