Inventory Management Spreadsheet Development -- 2

Job ID: 39379926

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
Related categories: PHP Visual Basic Data Processing Data Entry Excel