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.
google google sheets sheets
Part 4 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: de-duping rows in a Google Sheets spreadsheet (and some more thoughts about de-duping in general). Also, happy birthday, Malcolm X! Rest in power.
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.
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.
Re-member-ships
Some ideas for "best practices" on managing memberships from The Spreadsheet Whisperer. If you structure your data properly, you won't have to remember when people re-member. Are you with me?
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.
The Absolute Merge-iest
Welcome back to The Mail Merge Are Alright, #4 in a series about how to pull-off Mail Merges for your changemaking needs. This week, an introduction to Conga, a tool that lets you merge data from a database into Docusign contracts, Word docs, Excel Spreadsheets, and more!
Predicting the future
Students in A's North Philly classroom are studying population growth. The problem? The rate of population change has reached an inflection point so we can't really rely on the past to make a population growth model. In this post, a few perspectives on predicting the future, aka making population projections!
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.
Why I love Venn Diagrams
I've been captivated by Venn Diagrams lately, so I want to dedicate this post to this strange and enduring data viz and design technique. In this post: Venn Diagrams Then and Now; Why Changemakers should (and kinda do) embrace "Venn Diagram Thinking"; Venn Diagrams as art and social commentary.
