Inventory accounting and brand sorting in Excel

The project included the consolidation, filtering, and accounting of inventory balances of footwear from well-known brands (Nike, Puma, Adidas, etc.). The table implemented automatic totals (SUM function), categorization by batch numbers (LOT 1, LOT 4, LOT 5), and conditional formatting for instant detection of product shortages in the warehouse. The sheet was professionally prepared for convenient monitoring and sales reporting.