Excel Duplicate Record Cleanup

I'm looking for assistance in identifying and capturing duplicates within a single Excel file. The duplicates include both exact match duplicates and partial match duplicates based on similar text values.

Requirements:
- Experience with Excel and data manipulation
- Ability to handle both exact and partial match duplicates
- Familiarity with techniques to identify similar text values

Ideal Skills:
- Proficient in Excel functions and formulas
- Detail-oriented with a keen eye for data discrepancies
- Previous experience in data cleaning or data management tasks

Please provide a brief overview of your experience and approach to this task.