職位描述
I have an existing Excel workbook that has slowly become a patchwork of inconsistent names, mixed-format dates, and cells that refuse to behave. Your task is to go through the file, standardise every text field, bring all dates into a single, clearly documented format, and apply consistent number and currency formatting where needed. No new data needs to be entered—this is a pure cleanup and organisation job.
I will share the workbook via OneDrive; after your pass it should open without any warnings, filters should work smoothly, and the whole sheet should look and feel uniform. Please include a short “before / after” change log or a separate tab outlining the main transformations so I can trace what was done.
Acceptance will be based on:
• Uniform name capitalisation and spelling
• Dates converted to the agreed format throughout
• All numeric columns stored as numbers (not text)
• No hidden duplicates or stray blank rows/columns
• File returned in .xlsx, ready for immediate use
If you’re comfortable with Excel’s find-replace, Power Query, or similar cleanup tools and can deliver quickly, I’d love to get this file back in shape.
---
來源:Freelancer.com | 出價次數:12 | 剩餘時間:6 日 | 專案類型:固定預算