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.
How to interpret survey data in Google Sheets with dynamic charts and drop down menus
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!
Dear Spreadsheet Whisperer: Or Else?
What should a social justice movement leader do when his spreadsheets aren't behaving properly? Email the Spreadsheet Whisperer, of course!
5 Google Sheets tips every organizer can use
For the month of March, I'm challenging myself to write a weekly "Listicle" style article for the different communities and audiences that make up the TDAA readership. No matter how technical this blog veers, it is and always has been my way of writing love letters to social movement organizers. This is my core motivation for learning data/tech and for writing at all! So my first post is dedicated to you <3
filter down spreadsheet formulas
Like a coffee filter, the filter functions that I'm writing about today help us get to the very essence of our data. Read on for examples of filtering and summarizing a complex dataset, informed by a recent consulting project for an emergency homeless shelter.