encountering a real, live Excel bug

I think I stumbled upon an Excel "bug" (gasp!!) when I was combining SUMIF formulas plus sorting alphabetically. @___@ This is a new one, grasshoppers and honeybees! Sit down, buckle in, and enjoy the ride - we're gonna get technical with some formulas and explore what to do when you get real confused.

validation rules!

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.

Year end fundraising! Now what?

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.

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!