Advanced Excel Analysis & Automation Program
Budget: $25 – $50 USD
I need an expert proficient in Excel who can create a program that accomplishes the following tasks:
- Data analysis: The primary function of this program will be to conduct statistical analysis. You'll write formulas that can properly separate, organize, and analyze complex data.
- Automation and macros: The program will automate data cleaning. It'll detect unnecessary or repetitive information and remove or correct it autonomously. Additionally, it should be able to generate comprehensive reports based on the cleaned data.
Your skills and experience should include advanced knowledge of Excel, statistical analysis, and programming macros. Understanding of data cleansing techniques will be pivotal for this job.
- Data analysis: The primary function of this program will be to conduct statistical analysis. You'll write formulas that can properly separate, organize, and analyze complex data.
- Automation and macros: The program will automate data cleaning. It'll detect unnecessary or repetitive information and remove or correct it autonomously. Additionally, it should be able to generate comprehensive reports based on the cleaned data.
Your skills and experience should include advanced knowledge of Excel, statistical analysis, and programming macros. Understanding of data cleansing techniques will be pivotal for this job.