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!
syncing ship
It's time for end of year fundraising, so you export your data for volunteers, but then gifts come in and spreadsheets need to be refreshed. How do you handle the spreadsheet chaos? Meet my friend Ryan and how they can use good documentation to streamline this very confusing situation! Plus, some good puns!
mixed messages
On one hand, data skills are impossible to learn (and we blame the individual). On the other hand, companies tell us that advanced coding skills are easy to develop, 1, 2, 3! How can these be true at the same time? Who benefits from these messages? It's classic capitalism doublespeak: make non-data people feel insignificant and intimidated, then sell us a solution to our problem. I call BULLSHIT on these dynamics and offer 8 tips for wrangling a sloppy spreadsheet that you can use right away!
online to offline
Online-to-offline digital organizing is all the rage, but what about online to offline spreadsheets (aka printing)? If you've ever struggled to print Google Sheets, this tutorial is for you. Come for the gifs, stay for the tips!
the spreadsheet whisperer is alright!
Life update! I moved in with my partner! Introducing... some spreadsheets I'm using to set up our kitchen, including The Spreadsheet Whisperer's kitchen supply reccos and Weekly Meal Planning. Read on for all that, and more....
now you see me, now you don’t
Have you ever played spreadsheet hide and seek with hidden columns, filter views, and more? Or have you ever needed to temporarily hide or restrict access to certain information? If yes, then this post is for you (plus, cute bunny gifs!)
much ado about nothing
Today's post is all about how to find empty cells in your spreadsheet. You might be giving me a blank stare from behind your computer screen, but if I were you, I wouldn't a-void this post! #PunsIntended This post is chock-full of useful tips that you can apply to projects like data cleaning, volunteer on-boarding, and even getting better donation stats.
Data cleaning is a “contact” sport
Like contact sports, "Contact Segmentation" has rules to learn and skills to develop... and sometimes it can make you feel sore/grumpy/bruised. In this post, I offer 4 "Rules of the Game" and 3 Skills that will help you make it to the clean data finish line.
Duped, again!
Part 1 in a mini-series exploring the great, big world of “de-duping” - or, making sure that you don’t repeat the same information twice in a spreadsheet or database. This post includes "instant-gratification" links to tried and true de-duping resources.
Merge, baby, merge! (in Google Sheets!)
This is the third installment in a series called "The Mail Merges Are Alright" featuring the National Student Walkout and the mass-email sending tool, GMASS.
