How to remove duplicates in Google Sheets and Excel

There's a new feature release from Google Sheets and that includes remove duplicates. Here's my video that shows you the differences between the two programs. Which spreadsheet tool do you prefer?