Project · Beginner · 5h
Project: An inventory workbook with reorder alerts
Build an inventory workbook with a products table, stock movements, reorder points, a dashboard and checks.
- spreadsheets
- project
Inside this project
- Build a workbook with a products table (SKU, name, cost, reorder point, lead time), a movements table (date, SKU, quantity in or out), a stock-on-hand summary with SUMIFS, reorder alerts with conditional formatting, a pivot dashboard by category, validation on all inputs and a checks block.
- Milestone 1: Structure
- Milestone 2: Calculations
- Milestone 3: Dashboard and checks
The full project opens with a membership that covers Excel Skills.
Sign in if you already subscribe.
Sign in