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.
Slicers, Subtotals, Tables, Ranges, Sort criteria, OH MY. We've got it all in this post about dealing with frustration, solutions, and spreadsheet empowerment.
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!
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!
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.
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!
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.
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!
How to build a Seating Chart Wizard for classroom teachers in Google Sheets.
How can we make better sign-in sheets that minimize the work for organizers and maximize our capacity to follow up?