MS Excel: How to identify and remove duplicates

In this video I will show you different methods to identify and delete duplicated records from a spreadsheet. We will use conditional formatting, the concat function, and the remove duplicates tool.