StreetStStrSt.AvenueAveAve. How many different ways can you write an address? Turns out... a LOT. Typically, when I am cleaning address data (yes, that's something I do quite regularly, what with being a spreadsheet whisperer and all), I am preparing to either (1) upload a single file into an online database or (2) create a mail … Continue reading How to compare addresses
how to combine three contact lists
How to use simple spreadsheet formulas to merge three or more contact lists into one. Useful for data cleanup, data migration, surveys, event management, and email blasts!
introducing: xlookup
Puppies are organizing to convince the zoning board to protect their dog park! They need help from VLOOKUP and XLOOKUP to get the job done. Follow along as we learn the ins and outs of these powerful functions in Excel and Google Sheets!
5 Google Sheets tips every teacher can use
Teachers, I am so humbled by your brilliance and I will keep fighting for a world that treats you with the dignity you deserve. Here's a tiny contribution toward making your day slightly more magical.
Dear Spreadsheet Whisperer: Gettin’ Schooled
In this edition of Dear Spreadsheet Whisperer, lessons about how to set up spreadsheets to ask hard questions about racial equity in schools.
may showers
What do nudity, surveys, and spreadsheets have in common? Read more to find out! ps... Eureka!
spreadsheet role up
Why social movement organizations need spreadsheet champions as one of many important roles to play! Plus, the first time I tried (and failed) to learn VLOOKUPs.
Dear Spreadsheet Whisperer: Quickbooks, MS Access, and Spreadsheets, oh my!
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.
spreadsheet bliss
Isn't it great when spreadsheets just WORK, making your repetitive tasks faster and more accurate? Here are two examples of spreadsheet tools I've built with a combination of Salesforce exports and spreadsheet prowess. Using them makes me feel proud and blissful!
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.