Tag Archives: Google Sheets

Spreadsheet Formulas You Need to Know, Part 2: 3 Simple Conditionals

This post is the second part of a Formulas-You-Need-to-Know series. If you haven’t seen the first part, you’ll want to start here.

But assuming you’re up to speed, get ready! This is another game changer.

Continue reading

Spreadsheet Formulas You Need to Know, Part 1: The 6 Biggest Time-Savers

analysis blackboard board bubble

Have you ever spent hours on a spreadsheet & thought “there has to be a better way”?

Then I’ve got bittersweet news. There probably was.

When I started using spreadsheets 6 years ago, I thought they were glorified Microsoft Word Tables. Except they were finicky and I could never get them to look right. 🤷🏻‍♀️

Fact is, spreadsheets come with tons of powerful functionality. The problem is just that it all sits quietly behind the scenes. And you won’t reap the benefits unless you know how to use some of them.

Enter this post series, devoted specifically to formulas.

Continue reading

⏲️ 1min Spreadsheet Hack: Adding Drop-downs to Cells

When you need staff to add data to a spreadsheet, you can end up with lots of inconsistencies. Here’s how to use data validation to create drop-down lists, so that data is entered accurately and uniformly!

Stay Out of Excel Hell: 7 Tips for Working with Spreadsheets

Anyone who regularly works with spreadsheets knows the anguish of screwing up said spreadsheets.

It usually goes like this. You’re powering through – filtering, sorting, formulating – until you notice that one row of data looks off. After frantically checking a few more rows, it hits you. Something went wrong in your manipulations, and now you need to start from scratch.

Maybe.

Spreadsheets are great, but they have also destroyed many a nonprofit worker’s day. Fortunately, we can do things to reduce the chance of this happening…and keep calm when it inevitably does.

Continue reading

⏲️ 1min Spreadsheet Hack: PROPER-ly Format Those Cells!

For any of you who work with spreadsheets too, you know those things can cost us lots of time! So I’m experimenting and sharing a few of the must-know tips via video.

For the first video in this series, check out how you can quickly format names, addresses, and organizations to have the proper capitalization!