Advanced Excel Database Development for Pricing
Budget: ₹12,500 – ₹37,500 INR
I'm looking for a highly skilled Excel expert to develop an advanced Excel database for our pricing sheet. The ideal candidate will have extensive experience in Excel functions, formulas, pivot tables, macros, and data analysis. This project involves organizing and automating our current pricing sheet to enhance efficiency and accuracy.
Key Responsibilities:
- Review and understand our current pricing sheet and data.
- Design and develop an advanced Excel database to streamline pricing management.
- Implement complex formulas, functions, and data validation rules.
- Create pivot tables, charts, and graphs for data visualization.
- Develop macros to automate repetitive tasks.
- Ensure data accuracy and integrity.
- Provide documentation and training on the new database.
Data Inputs: The current pricing sheet contains product information and cost details.
Desired Improvements: The primary goal is to achieve automated calculations.
Key Responsibilities:
- Review and understand our current pricing sheet and data.
- Design and develop an advanced Excel database to streamline pricing management.
- Implement complex formulas, functions, and data validation rules.
- Create pivot tables, charts, and graphs for data visualization.
- Develop macros to automate repetitive tasks.
- Ensure data accuracy and integrity.
- Provide documentation and training on the new database.
Data Inputs: The current pricing sheet contains product information and cost details.
Desired Improvements: The primary goal is to achieve automated calculations.