Inventory Management Spreadsheet Development -- 2
Budget: ₹750 – ₹1,250 INR
I need an Excel spreadsheet to manage my product inventory efficiently.
Requirements:
- Enter and organize product data: Product names and IDs, Stock levels, Price per unit
- Use data validation to prevent input errors
- Apply formulas such as SUM and COUNTIF for stock tracking
- Create sortable and filterable tables
- Design a basic dashboard with:
- Yearly trends
- Monthly updates
- Category breakdown
- Highlight low stock levels using conditional formatting
- Ensure data accuracy for easy monthly updates
Ideal skills and experience:
- Proficiency in Excel
- Experience with data validation, formulas, and creating dashboards
- Attention to detail
- Ability to deliver accurate and organized data
Requirements:
- Enter and organize product data: Product names and IDs, Stock levels, Price per unit
- Use data validation to prevent input errors
- Apply formulas such as SUM and COUNTIF for stock tracking
- Create sortable and filterable tables
- Design a basic dashboard with:
- Yearly trends
- Monthly updates
- Category breakdown
- Highlight low stock levels using conditional formatting
- Ensure data accuracy for easy monthly updates
Ideal skills and experience:
- Proficiency in Excel
- Experience with data validation, formulas, and creating dashboards
- Attention to detail
- Ability to deliver accurate and organized data