Category Archives: Spreadsheets

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

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