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.
What tech stack should we use for complex application forms for a flagship fellowship program? Here's one description of what I set up and what we learned!
When Mr. Spreadsheet Whisperer is having trouble copying Google Files into folders for each camper, what should he do? Use automation to process repetitive, tedious tasks!
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.
While analyzing survey data, I encountered 3 new spreadsheet capabilities in Excel and Google Sheets!
Sorting through Google Form survey responses? What if I told you that you didn't have to rely on the auto charts from Google Forms, and instead, you could develop a fully automated, responsive, Google sheets dashboard for disaggregating data and drawing insights from the data? Here's how!
What should a social justice movement leader do when his spreadsheets aren't behaving properly? Email the Spreadsheet Whisperer, of course!
The database world is replete with options for "validating" data, but there is a huge missing link in our field, which for me boils down to VALIDATING HUMANS.
How did TDAA do at meeting its goals? How did TDAA compare to statistics from prior years? Lots of juicy metrics and reflection in this end of year round up!