Xlsx Data Validation and Error Checking -- 2
Budget: ₹600 – ₹1,500 INR
I need an experienced data analyst who can meticulously check my xlsx sheet for data validation and missing values. The sheet contains various data types, and I need:
- Number range checks: Ensure all numerical data falls within the specified limits.
- Text format checks: Validate all text entries for consistency and correctness.
- Weight calculation: Verify the weight data against the corresponding entries.
In addition, I need some formulas and calculations added to the sheet. This includes:
- Weight calculation: Help me assess the weight data.
- Conditional formatting calculations: Assist in setting up conditions for data formatting.
Ideal candidates should have:
- Proficiency in Excel with a deep understanding of its formulas and functions.
- Strong analytical skills with keen attention to detail.
- Experience with data validation and error checking.
Please ensure you have these skills before bidding.
- Number range checks: Ensure all numerical data falls within the specified limits.
- Text format checks: Validate all text entries for consistency and correctness.
- Weight calculation: Verify the weight data against the corresponding entries.
In addition, I need some formulas and calculations added to the sheet. This includes:
- Weight calculation: Help me assess the weight data.
- Conditional formatting calculations: Assist in setting up conditions for data formatting.
Ideal candidates should have:
- Proficiency in Excel with a deep understanding of its formulas and functions.
- Strong analytical skills with keen attention to detail.
- Experience with data validation and error checking.
Please ensure you have these skills before bidding.