Excel Data Cleanup & Corrections

I’m working with a sizeable Excel worksheet that has become messy over time, and I need a fresh set of eyes to bring it back into shape. Your primary focus will be twofold: correct existing data entry errors and resolve several formatting problems that affect usability and reporting.

Here’s what I’m facing right now:
• Numerous cells carry inconsistent date formats—some dates are incomplete or entirely missing, while others switch between slashes, dashes, and regional order. I want every valid date converted to a single, uniform style and any partial dates flagged so I can supply the missing information.
• Text entries fluctuate between uppercase, lowercase, and mixed case. They should follow a consistent sentence-case convention that improves readability across the file.

Alongside those points, I need you to comb through the sheet for obvious entry mistakes—typos, misplaced values, or anything that doesn’t conform to the column’s intent—and correct them where the fix is unambiguous. If something looks inaccurate but isn’t certain, highlight it so I can confirm.

Deliverables:
1. A cleaned Excel file with:
– Unified date format applied across all date columns
– Standardised text case throughout descriptive columns
– Corrected data values where errors were clear
2. A brief changelog (can be an extra tab) noting any assumptions you made or rows you flagged for my review.

I’m looking for someone comfortable with Excel functions such as TEXT, DATEVALUE, Flash Fill, and data-validation tools—or whatever advanced methods you prefer—to finish this efficiently and accurately. Let me know your estimated turnaround and any questions you have about the dataset, and we’ll get started.