Excel Data Cleaning & Formatting

I have several spreadsheets that have grown messy over time—duplicate rows, inconsistent date formats, stray blank columns, and a mix of numeric and text values that should be uniform. The immediate goal is to bring this data back to a reliable, analysis-ready state.

Here’s what I need:
• Import the raw tables (some arrive copied from PDFs) into a single Excel workbook.
• Remove duplicates, fix mis-aligned columns, standardize dates, numbers, and text casing, and flag any obviously corrupt entries.
• Apply a clean, uniform formatting template so every sheet shares the same header style, font, and number formats.

Deliverables
1. A fully cleaned, well-formatted .xlsx file.
2. A brief change log summarizing the main corrections you performed so I can track what was altered.

Acceptance Criteria
• No duplicate IDs or rows remain.
• All dates use the same locale-specific format.
• Numeric fields are stored as numbers, not text.
• Visual layout is consistent across every worksheet.

Please highlight relevant experience with large-scale data cleaning or Excel formatting in your proposal; concrete examples or before/after snapshots are especially helpful. Familiarity with built-in Excel tools such as Power Query or advanced filters will be considered a plus.