Rapid Excel Data Cleaning & Prep

I have a small dataset that needs to be polished fast so I can jump straight into analysis. The file currently contains duplicate rows, empty cells, inconsistent text and date formats, and a few obvious entry errors. I want all of that tidied up directly in Excel or Google Sheets—no Python this time—so I can open the workbook and start exploring it immediately.

Here is exactly what I need:

• Remove every duplicate record.
• Replace each missing value with a clear placeholder I can easily spot later (please use something obvious like “N/A” rather than deleting rows).
• Correct any incorrect or out-of-range entries you find.
• Standardise column formats (dates as dates, numbers as numbers, text capitalisation consistent, etc.).

Please keep a short change log on a separate tab so I can trace what was altered. I’m looking to receive the cleaned file, fully ready for analysis, as soon as possible. If you have any quick insights on the overall data quality while cleaning, feel free to add a short note—I always appreciate the context.