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.
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.
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!
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!
=IF(FIND(ers, keepers), "", "weepers"). In other words, using text functions to make sense of lists. Plus, gifs and my pet turtle, Prince!
A template to track your donations and a resource guide for new protesters. Dreaming and building a world where #BlackLivesMatter.
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!
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!
How learning a new crafting medium offers insights into resilient spreadsheet skill building. Plus, puns, puns, and more puns.
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.