Tag Archives: Excel

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

5 Excel List Nightmares Any Nonprofit Employee Can Fix

No matter which department you work for at your organization, chances are that Excel spreadsheets have touched your life in one way or another.

If you’re like me, then you’re eager to dive into that world of cells and formulas. Or, maybe you dread it each time you see an email request with a .csv or .xlsx attachment. That dread gets reinforced once you open the file, see the glaring errors, and realize you’ll have to make corrections manually. If it’s a long list, this can take hours.

Continue reading