Excel Cleanup & Sheet Organization

via Freelancer ·

Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted20 minutes ago
The current workbook has become cluttered and hard to read. I need it fully organized, formatted, and cleaned so that every sheet is accurate and easy to navigate.

Scope of work
• Fix all inconsistent names, dates, and number formats so the data follows one clear standard.
• Remove every duplicate or blank row to leave only unique, meaningful records.
• Apply a tidy layout—clear headings, logical column widths, and a light color scheme—to make information pop at a glance.
• When the data is consistent and polished, split it into separate sheets based on category or type; the master sheet should remain intact for reference.

Deliverable
A single Excel workbook (.xlsx) containing:
1. A master sheet with corrected, deduplicated data.
2. One tab per category/type, automatically updated from the master through formulas or Power Query so future edits stay in sync.
3. Basic documentation (a short note inside the file or a text document) explaining any formulas, named ranges, or query steps used.

Acceptance criteria
• No duplicate rows and no empty filler rows.
• Consistent date, text, and numeric formatting across all tabs.
• Sheet tabs clearly named and logically grouped.
• File opens without errors in Microsoft Excel 2016 + and Microsoft 365.

The job is complete when the workbook meets the above checks and I can filter, sort, or add new records without breaking the structure.
visual basic data processing data entry excel virtual assistant microsoft office excel vba excel macros data analysis data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.