What should you do if the built in Excel Table Styles don't match your colors or preferences? Create a Custom Table Style, of course! Here's a post that walks you through the "how" and "why" to customize your table designs. Here's a hint- think about who else uses your spreadsheets besides just YOU! Come for the puns and stay for the data 🙂
5 days in 5 minutes
How to filter a list based on another list, featuring one of my favorite data tools... the VLOOKUP! Plus, some examples for how this tool can be used for political organizing, and the "pull rabbit out of the hat" meme makes another appearance.
now you see me, now you don’t
Have you ever played spreadsheet hide and seek with hidden columns, filter views, and more? Or have you ever needed to temporarily hide or restrict access to certain information? If yes, then this post is for you (plus, cute bunny gifs!)
strawberry shortcut cake
I wanted to share a set of tips that could supercharge ANY spreadsheet maker's work. So what could be better than SHORTCUTS? For repetitive functions, selecting cells, and navigating around a spreadsheet, keyboard shortcuts will make a heck of a difference. Here are 5 Excel shortcuts you shouldn't live without!
There’s something I’d like to address
Address management can have as many pitfalls as Philadelphia streets have potholes! In this post, I explore best practices for keeping track of addresses, thanks to many of YOU! for writing in with questions to Dear Spreadsheet Whisperer.
default, not your fault!
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.
