I will create an excel inventory control spreadsheet with dashboard
Logistics Excel Expert: Inventory, Dashboards and KPIs
About this Gig
Need to know exactly what you have in stock, what is about to run out and where your money is tied up? I will build a practical Excel inventory control spreadsheet for your business.
I am a warehouse manager at a logistics operator, so I build tools based on how a real warehouse works, not just nice-looking sheets.
What you get:
- Item register with cost, minimum stock and opening balance
- - Stock in/out log with drop-down lists to avoid typing errors
- - Automatic balance and stock value per item
- - Low-stock alert highlighted in red
- - Automatic ABC curve (Standard and Premium)
- - Summary tab with charts and a monthly KPI dashboard (Premium)
Built only with native formulas, no macros: works in any Excel version and in Google Sheets. You receive the file ready to use, with instructions.
Before ordering, send me a message describing your products and how you control stock today, so I can recommend the right package.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Formatting
•
Formulas
•
Dashboard
•
Charts
•
Data validation

