How to remove duplicates in Excel

If you've ever had a data dump into a spreadsheet result in a mess of duplicate values, we'll go over how to remove those on this how-to.