How to remove duplicates in Excel

If you’ve ever had a data dump into a spreadsheet result in a mess of duplicate values, follow this step-by-step to learn how to remove them.