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!)

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!