Tag Archives: Spreadsheets

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!

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