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.
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!
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!
This post is about a labor of love. It's about administrative logistics, signup forms, and unglamorous data validation. It's behind the scenes, it's in the weeds, its everything most organizations WON'T tell you.
My Rabbi asks for help sorting a spreadsheet, which pairs perfectly with my evolving plans to offer a Spreadsheet Chevruta program. Tune in for banter, reverence, tips, and .gifs!
It's 2019... do you know who your donors are? You have new data about your donors... and a LOT of it. But how do you take a list of hundreds or even thousands of donations and turn them into helpful statistics and meaningful insights? Here's my top tips for donation spreadsheets, served with a smile and side of puns and gifs.
How to use spreadsheets to sequentially number your rows (x+1 or date +1) OR undo it! Come for the gifs, stay for the puns!
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!
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!
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!