Need to maintain multiple views of the same data? Learn about my "Filter Square Mindset" of applying Filter Views rather than Filters in Google Sheets! Plus, gifs, cartoons, puns, and more!
call me, maybe?
Getting ready for your Q4 fundraising phone-a-thons? Follow these simple steps in Excel or Google Sheets to format your phone numbers for optimum ease!
hide and seek
=IF(FIND(ers, keepers), "", "weepers"). In other words, using text functions to make sense of lists. Plus, gifs and my pet turtle, Prince!
rising to the occasion: two offerings
A template to track your donations and a resource guide for new protesters. Dreaming and building a world where #BlackLivesMatter.
borders / no borders
How do you apply borders and formatting to a spreadsheet, and then copy them somewhere else? When should you use borders? Are geopolitical borders wrong? Yes, we tackle all this and MORE! Plus, .GIFs!
beginner friendly
Inspired by Samin Nosrat, thinking about formats available to us for lists, spreadsheets, and more complex options - and when to pick the right one at the right time. Plus, gifs and memes!
i am not a crocheter
How learning a new crafting medium offers insights into resilient spreadsheet skill building. Plus, puns, puns, and more puns.
validation rules!
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.
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!
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!