How can you remove duplicates from an Excel dataset?

Instruction: Describe the steps to identify and remove duplicate records in a dataset.

Context: This question evaluates the candidate's ability to clean and prepare data by removing duplicates, a common task in data analysis.