I will create an excel inventory tracker with stock alerts and summary

Pakistan

I speak Urdu, English

Excel Data Entry, Inventory Trackers and Sales Dashboards

Hi, I'm Zamil. I create organized Excel spreadsheets for small businesses and individuals. My services include data entry, spreadsheet formatting, inventory trackers, and simple sales dashboards. I us...
About this Gig

Keep your inventory organized with an easy-to-use Excel tracker.


I will create an inventory spreadsheet for up to 50 products, including:


  • Product ID, name and category
  • Stock quantity and unit cost
  • Automatic stock value calculations
  • Low-stock and out-of-stock alerts
  • Summary of product counts, stock quantities and inventory value
  • One chart showing stock value by product
  • Clear formatting and data validation


The tracker uses Excel formulas to update calculations when you change stock quantities or costs. It helps you review current stock and identify products that need attention.


You will receive an editable Excel workbook, with delivery in 3 days and 2 revisions within the agreed scope.


This package covers a current-stock tracker. VBA macros, buttons, external data connections and purchase/sales transaction tracking are not included.


Please message me before ordering to discuss your requirements and Excel version.

Platform:

Excel

Development technology:

Excel

Expertise:

Formatting

•

Formulas

•

Functions

•

Charts

•

Data validation

My Portfolio