How to Translate Text Quickly (using Google Sheets)

I know my way around a few spreadsheet formulas. I love a good VLOOKUP and PROPER situation!

But this formula is so cool and fun (and surprising!) that I had to share.

Continue reading “How to Translate Text Quickly (using Google Sheets)”

6 Questions to Help You Prep for Your Data Migration

So! Your org is implementing a new system. What’s your game plan for migrating all that data?

Perhaps you don’t have one, because #time. You spent enough of it searching for the right platform in the first place, and deciding whether to migrate at all. Then, you had to jump through all those hoops to start implementing!

Continue reading “6 Questions to Help You Prep for Your Data Migration”

8 Kinds of Nonprofit “CRM” Databases for Managing Constituents

To those shopping for your org’s next CRM: how’s that process treating you? 

Continue reading “8 Kinds of Nonprofit “CRM” Databases for Managing Constituents”

VIDEO: How to Clean a Messy Spreadsheet in under 10 min

Have you ever looked at a spreadsheet and thought “where do I even begin?”

Sometimes it’s a file we inherit from someone else in our org. Other times, it’s a data entry project turned disaster. Either way, our sector is no stranger to the messy spreadsheet. 

Continue reading “VIDEO: How to Clean a Messy Spreadsheet in under 10 min”

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

No more sorting, cutting, pasting and resorting to calculate data. These formulas have got you covered.

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 2: 3 Simple Conditionals”

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

Even if you’ve never used formulas before in your spreadsheets, you’ll be happy you scanned these formulas. They can save you hours of manual spreadsheet time.

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 “Spreadsheet Formulas You Need to Know, Part 1: The 6 Biggest Time-Savers”