What to do when you find data discrepancies?! I kinda felt like I did 6 loads of laundry, came out with socks I didn't even know I had, and then figured out how to match them up. Also, Spongebob, Rubix Cubes, and pivot tables.
filter down spreadsheet formulas
Like a coffee filter, the filter functions that I'm writing about today help us get to the very essence of our data. Read on for examples of filtering and summarizing a complex dataset, informed by a recent consulting project for an emergency homeless shelter.
if we don’t get it… shut it down
TL;DR... Sign up for an upcoming course, no wait, an experience, with my spreadsheet soulmate Emily! You'll learn how and why to organize your tech workspaces so that you can shut down your computer every night in peace. Plus, you'll get to join a supportive, like-minded cohort with personal coaching from Emily.
clouds
This Joni Mitchell + Brandi Carlisle + Zadie Smith + plastic suitcases full of beads + cloud-anatomy + data lovin' babe is living her best life, moving data between sandboxes and more! Cheers to THAT!
Steven Universe presents: Filter Views
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!
i’m learning CiviCRM!
What's out there in the land beyond Salesforce? Turns out, quite a lot! Keep reading for musings on open source technology and a PG-13 meme.
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!
Digital self care, vol v
What do passwords and canned air have in common? Read this blog post to find out!
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.
