Google Sheets offers an =AverageIF() formula, but what if you need =ModeIF() or =MedianIf()? Here's a post on how to solve this, and why it matters for social justice orgs.
Dear Spreadsheet Whisperer: How to Build a Tax Prep Friendly Expense Tracker in Google Sheets
In this installment of Dear Spreadsheet Whisperer, "Frustrated Finance Freelancer" looks for support about how to track business expenses. We cover multiple ideas, including Pivot Tables and Filter formulas in Google Sheets.
hay in a needlestack
What to do when you find data discrepancies?! I kinda felt like I did 6 loads of laundry, came out with socks I didn't even know I had, and then figured out how to match them up. Also, Spongebob, Rubix Cubes, and pivot tables.
may showers
What do nudity, surveys, and spreadsheets have in common? Read more to find out! ps... Eureka!
summary offense
What do pivot tables, the concatenate function, and Parks and Rec gifs have in common? You'll have to read this blog post to find out!
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.
pivot swivet
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!
Dupes / dupes / dupes (Excel)
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.
One slice of data… a la mode!
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.