職位描述
I have an Excel workbook that holds our product-level inventory data, and it has grown messy over time. I need a detail-oriented Excel pro to bring it back into shape by:
• Identifying and removing every duplicate line item (including hidden rows or filtered ranges)
• Flagging or filling in any missing SKUs, descriptions, costs, or category fields so the sheet is complete and reliable
Please rely on native Excel tools—Power Query, advanced filters, conditional formatting, lookup functions, or any other method you prefer—as long as the final file is accurate and easy for my team to maintain.
Deliverables
1. A cleaned master worksheet with no duplicates and all essential fields populated or clearly marked “Missing”.
2. A short change log or comments tab that explains what was removed or amended so we can audit the work if needed.
Accuracy is everything here, so I will review the file against the original before sign-off. If this sounds straightforward to you and you have a track record handling product or inventory data, I’d love to see how quickly you can turn this around.
---
來源:Freelancer.com | 出價次數:20 | 剩餘時間:6 日 | 專案類型:固定預算