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.
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.
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.
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?
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.
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.
Read on, for a tutorial and step-by-step instructions about how to Mail Merge a fundraising letter using Microsoft Word and Microsoft Excel. Next week, we'll cover merges using Google Drive - part of an on-going series dedicated to Mail Merge for Changemakers.
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.
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.
When I left the Urgent Care facility after I fell, staff members handed me a wad of receipts including my diagnosis, my visit summary and notices about my BMI and blood pressure. In this blog post: why these data are NOT alright.