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.
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!
may showers
What do nudity, surveys, and spreadsheets have in common? Read more to find out! ps... Eureka!
shape shifter
From a downloaded file with weird fonts and titles, wacky colors, no wrapped text, superwide columns, and repeating header rows, I was able to create a useable, sortable, shareable, printable, filterable, not-make-you-want-to-throw-your-computer-out-the-window spreadsheet. And you know what the best part is? You can too!
lipstick on a pig
What do pigs, horses, donkeys, formulas, and tables have in common? Read more to find out, plus GIFs and best practices for formatting spreadsheets for optimum share-a-bility.
summary offense
What do pivot tables, the concatenate function, and Parks and Rec gifs have in common? You'll have to read this blog post to find out!
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!
