Today's post is all about how to find empty cells in your spreadsheet. You might be giving me a blank stare from behind your computer screen, but if I were you, I wouldn't a-void this post! #PunsIntended This post is chock-full of useful tips that you can apply to projects like data cleaning, volunteer on-boarding, and even getting better donation stats.
Data cleaning is a “contact” sport
Like contact sports, "Contact Segmentation" has rules to learn and skills to develop... and sometimes it can make you feel sore/grumpy/bruised. In this post, I offer 4 "Rules of the Game" and 3 Skills that will help you make it to the clean data finish line.
Duped, again!
Part 1 in a mini-series exploring the great, big world of “de-duping” - or, making sure that you don’t repeat the same information twice in a spreadsheet or database. This post includes "instant-gratification" links to tried and true de-duping resources.
Merge, baby, merge! (in Google Sheets!)
This is the third installment in a series called "The Mail Merges Are Alright" featuring the National Student Walkout and the mass-email sending tool, GMASS.
The Mail Merges Are Alright
The Mail Merges Are Alright: a mini-series dedicated to using Mail Merge to fuel social movements. In this post: anatomy of a Mail Merge and why changemakers should embrace the tool.
Not more than the sum of its parts
When you're setting up Sums, Subtotals, SumIfs (and more...) in Google Sheets - you might end up with more than you bargained for. Here to help you make sense of it all, the Spreadsheet Whisperer.
Freeze Spreadsheets: Blizzard Edition (also, RSVP for webinars!)
Today, we're going to talk about how to freeze rows and columns so that they are visible no matter how big your spreadsheet is, or how far you scroll. Also! Don't miss out on my second webinar with the Working Families Party and ResistHere.
Post Pi Day Pie Chart “Round” up
Maybe you're thinking I should finally get a-round (hehe) to making my point about pie charts. I don't blame you. I think pie charts are a good tool for changemakers (despite all of the banter and vitriol!) Please don't turn me into mincemeat!
How to build a “table” in Google Sheets
Back when The Data Are Alright was just a prototype, I made a blog post about one of my favorite Excel tricks, the "Format as Table" feature but the instructions were only for Excel users. Now, I'm eating my words and serving up a second helping, this time in Google Sheets.
Turn it upside down!
However you do your work to turn our political system upside down, I hope you can make good use of this post, whether it's inspiration from the Purim story or the technical tips about rotating your data that most resonates with you. I've been doing movement work for long enough to know that we desperately need both!