In this installment of Dear Spreadsheet Whisperer, we hear from an old friend who's storing contact information in.... Quickbooks! I offer advice about how to make better use of contact segmentation features and how to begin to explore a better database system.
What does the moon, popcorn, and caterpillars have in common? Changing phases, of course! This post is all about getting better at change management. BONUS: my favorite lil dumpster fire meme makes a cameo appearance!
Inspired by Marie Kondo's new show about tidying your home, a post about keeping and deleting data in your spreadsheets and databases. With puns and gifs!
What is a mistake? Let's use the etymology to learn some lessons about mistakes and spreadsheets. Plus, puns and a recommendation for learning more.
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!
9 tips for getting your spreadsheet data in tip-top shape. Especially useful for cleaning petition data!