I will create an excel inventory control spreadsheet with dashboard

Brazil

I speak English, Portuguese

Logistics Excel Expert: Inventory, Dashboards and KPIs

Warehouse Manager with 14+ years in logistics and supply chain, including 13 years at Ambev (AB InBev) in warehousing, distribution and planning. MBA in Logistics & Supply Chain, SAP user. I build pra...
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

My Portfolio