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.
In this installment of Dear Spreadsheet Whisperer, we use pivot tables, VLOOKUPs, and a mail merge to send top notch donor acknowledgement letters. Plus, gifs and cat memes!
Part 3 in a mini-series exploring the great, big world of “de-duping” – or, how to handle repeated info in a spreadsheet or database. In this installment: using Microsoft Excel to highlight duplicates and summarize data.
I talk a lot about making meaning out of data-- that's what I want to support changemakers to be able to do! Looking more closely at these student write-up records can help guide a strategy toward pursuing restorative justice and student growth and accountability. My goal was to leap from 650 entries in the restorative justice discipline log to identifying trends and outliers, and using that information to recommend actions.