Excel Customer Data Cleanup

I have a set of raw customer records that must be transformed into a clean, reliable Excel spreadsheet. The work involves:
• Accurate data entry from the original source files
• Thorough data cleaning to remove duplicates, fill in missing fields, and standardize names, addresses, phone numbers, and emails
• Rigorous data validation to flag inconsistencies and ensure every column follows the correct format

I will provide the source files and a template that shows the final column structure I need. Use Microsoft Excel functions—such as VLOOKUP/XLOOKUP, conditional formatting, and data validation rules—to automate checks wherever possible.

Deliverable: one well-organized .xlsx file ready for immediate use, with all customer information verified and clearly documented (e.g., a “Notes” or “Issues Resolved” tab listing any assumptions or unresolved anomalies). Accuracy is critical, so please outline how you will quality-check your work when you respond.