Excel Mixed-Data Cleaning Project
Budget: ₹100 – ₹400 INR
I have several Excel spreadsheets that contain a mix of text and numerical fields. They need a thorough pass of data cleaning and validation so the information is consistent, accurate, and ready for downstream analysis.
The job centres on:
• Removing duplicate or irrelevant rows
• Correcting formatting issues (dates, decimals, text case)
• Flagging and resolving inconsistent or out-of-range values
• Verifying that key fields match predefined validation rules
Please return a fully cleaned workbook along with a brief summary of the issues you found and the actions you took. Consistent use of Excel’s built-in tools, formulas, or Power Query is fine—whatever you normally deploy for reliable results—as long as the final file is error-free and easy for me to audit.
The job centres on:
• Removing duplicate or irrelevant rows
• Correcting formatting issues (dates, decimals, text case)
• Flagging and resolving inconsistent or out-of-range values
• Verifying that key fields match predefined validation rules
Please return a fully cleaned workbook along with a brief summary of the issues you found and the actions you took. Consistent use of Excel’s built-in tools, formulas, or Power Query is fine—whatever you normally deploy for reliable results—as long as the final file is error-free and easy for me to audit.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Data Scraping
Data Visualization
Data Analysis
Data Management