Excel Data Cleanup & Reporting
Budget: ₹12,500 – ₹37,500 INR
I have several workbooks that combine text fields, numerical columns, and a few legacy formulas that no longer behave as expected. The immediate goal is to clean this mixed data set, rebuild the key formulas, and turn the refreshed information into clear, share-ready reports.
Some cleaning rules are already documented—for instance, standardising date formats and trimming stray spaces—but others still need to be defined. I will share the existing guidelines and sample files; from there I’d like your input on the best additional rules to remove duplicates, catch outliers, and normalise inconsistent labels.
Once the data is tidy, the project shifts to creating or repairing formulas and functions so the sheets calculate totals, variances, and percentages automatically. Finally, I want polished summary tables and visual-ready charts that I can drop straight into a presentation.
Deliverables:
• One clean, fully validated master sheet (no errors in the audit).
• Updated formula set with clear cell comments explaining logic.
• A concise report sheet containing dynamic summaries and charts.
Everything should stay within standard Excel—no add-ins required—so I can maintain the files myself after hand-over.
Some cleaning rules are already documented—for instance, standardising date formats and trimming stray spaces—but others still need to be defined. I will share the existing guidelines and sample files; from there I’d like your input on the best additional rules to remove duplicates, catch outliers, and normalise inconsistent labels.
Once the data is tidy, the project shifts to creating or repairing formulas and functions so the sheets calculate totals, variances, and percentages automatically. Finally, I want polished summary tables and visual-ready charts that I can drop straight into a presentation.
Deliverables:
• One clean, fully validated master sheet (no errors in the audit).
• Updated formula set with clear cell comments explaining logic.
• A concise report sheet containing dynamic summaries and charts.
Everything should stay within standard Excel—no add-ins required—so I can maintain the files myself after hand-over.