Excel Dataset Cleaning & Validation

I have several large, raw datasets from the retail sector that must be transformed into clean, reliable spreadsheets for a patient-records-management initiative. The files mainly hold customer information, and I need every detail entered, validated, and formatted in Microsoft Excel so the data can be imported directly into our core system without a hitch.

Here’s what I expect:

• Accurate entry of every record, followed by thorough data validation and cross-checking to guarantee 100 % correctness.
• Removal of duplicates, correction of obvious errors, and consistent formatting with clear headings and filters already in place.
• Delivery of well-structured, password-protected workbooks on the agreed timeline, with full respect for confidentiality standards.

If you’re meticulous with Excel functions—VLOOKUP/XLOOKUP, conditional formatting, data-validation rules, PivotTables for spot-checks—and you understand the importance of safeguarding personal information, let’s get this started.