I think I stumbled upon an Excel "bug" (gasp!!) when I was combining SUMIF formulas plus sorting alphabetically. @___@ This is a new one, grasshoppers and honeybees! Sit down, buckle in, and enjoy the ride - we're gonna get technical with some formulas and explore what to do when you get real confused.
If only
Slicers, Subtotals, Tables, Ranges, Sort criteria, OH MY. We've got it all in this post about dealing with frustration, solutions, and spreadsheet empowerment.
spreadsheet bliss
Isn't it great when spreadsheets just WORK, making your repetitive tasks faster and more accurate? Here are two examples of spreadsheet tools I've built with a combination of Salesforce exports and spreadsheet prowess. Using them makes me feel proud and blissful!
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!
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.
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!
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.
3 easy Excel wins for organizers
Most of us learned organizing the slow way. But it doesn't have to be that way with learning spreadsheets! Here are 3 easy tricks that will make your work MUCH easier, so you can get back to changemaking!
You may be seated
How to build a Seating Chart Wizard for classroom teachers in Google Sheets.
“I want a sign-in sheet that *does the work for me!*”
How can we make better sign-in sheets that minimize the work for organizers and maximize our capacity to follow up?
