Designed and developed a comprehensive inventory management spreadsheet in LibreOffice Calc, suitable for small businesses, online sellers, and inventory tracking needs. The spreadsheet features automated calculations, inventory valuation, stock level monitoring, supplier tracking, order status management, and a visual dashboard for quick insights.
Key Features:
• Inventory quantity tracking
• Automatic inventory value calculations
• Order status monitoring (Arrived, In Transit, Processing, Not Started)
• Supplier and category management
• Low stock visibility
• Interactive dashboard with charts and summaries
• Conditional formatting for improved readability
• Clean, professional, and user-friendly design
This project demonstrates my ability to create organised, efficient, and visually appealing spreadsheets using formulas, data validation, conditional formatting, and dashboard elements to support business operations and decision-making.
Tools Used: Microsoft Excel, Spreadsheet Formulas, Conditional Formatting, Data Validation, Dashboard Design, and Inventory Management.