Tag Archives: Excel Hacks

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!

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