Three Excel-based dashboards — inventory, retail sales & forecasting, and transportation cost — each with an interactive walkthrough and a full write-up of the formulas, tradeoffs, and what I'd do differently at scale.
A live reorder-point and ABC/Pareto stock-health dashboard over 1,000 SKUs across 5 warehouses — filterable by category, warehouse, and supplier, driven entirely by SUMIFS, no macros.
A formula-driven workbook that turns a 5,009-order export into a live sales dashboard and a segment-level demand forecast through FY2030, with a CAGR-based order-priority recommendation.
A shipping-cost-and-revenue dashboard tying carrier, transport mode, and route performance together against a live 100-shipment export — built entirely on SUMIF and AVERAGEIF.