excel tip

Identify duplicate values.

In many instances, duplicate values -- like duplicate content when managing SEO -- can be troublesome if gone uncorrected. In some cases, though, you simply need to be aware of it. Whatever the situation may be, it's easy to surface any existing duplicate values within your worksheet in just a few quick steps. To do so, click into the Conditional Formatting option, and select Highlight Cell Rules > Duplicate Values Using the popup, create the desired formatting rule to specify which type of duplicate content you wish to bring forward. In the example above, we were looking to identify any duplicate salaries within the selected range, and formatted the duplicate cells in yellow. In marketing, the use of Excel is pretty inevitable -- but with these tricks, it doesn't have to be so daunting. As they say, practice makes perfect. The more you use these formulas, shortcuts, and tricks, the more they'll become second nature. To dig a little deeper, check out a few of our favorite resources for learning Excel. Want more Excel tips? Check out this post on how to create a pivot table with medians. Editor's note: This post was originally published in January 2019 and has been updated for comprehensiveness.