Today I wanted to focus on time-saving skills and tricks that will supercharge your spreadsheet powers and save you time. Understanding and modifying Excel's "default settings" can get you well on your way to a spreadsheet that works for you, instead of the other way around.
clean up in column 5!
9 tips for getting your spreadsheet data in tip-top shape. Especially useful for cleaning petition data!
home, home on the range
Whether you use spreadsheets for household budgeting, workout routines, live performances of your favorite band, or cross-country road trips - many of us have personal spreadsheet projects besides our changemaking spreadsheet projects. In this post, we use my Kitchen Utensils wishlist to dig into how to design a good spreadsheet (rows and columns) to capture the data of your dreams.
much ado about nothing
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.
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.
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!
Mail Merge and the Office, Sweet!
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
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.
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.
