Tag Archives: Spreadsheets

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

10 Easy Project-Management Tips To Help You Work Better with Colleagues

Project-managing and working with colleagues waaaasssnn’t exactly easy before the crisis. So I’m imagining that for most of us, things feel much trickier.

I can happily spend hours working alone in a spreadsheet. And I have! But there’s an undeniable satisfaction that comes with being able to work with a bunch of people, to achieve an important outcome for your org and your mission. When that happens, it’s a great feeling.

And when that doesn’t? It’s usually a hiccup somewhere in the coordination.

Continue reading

Video: How to Highlight Duplicates in Excel (4 min)

Dealing with duplicates can be a hassle! Here’s one option to add to your toolbox. Conditional Formatting lets you highlight duplicate or unique values in a column. Check out how to do it below!

p.s. You can get more spreadsheet tips straight to your inbox by subscribing here! –> Or, if you just want the vids, follow the Employed for Good Youtube Channel!)

⏲️ 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!