I will create a customized excel inventory management system with stock tracking
Excel Inventory Management and Supply Chain Specialist
About this Gig
Need a reliable Excel inventory management system for your business?
I will create a customized Microsoft Excel inventory management system to help you track stock, monitor inventory movements, and maintain accurate stock balances.
With over 9 years of practical experience in supply chain and inventory management, I understand the importance of accurate inventory records and effective stock control.
WHAT I CAN BUILD FOR YOU
Product master with SKU, description, category and unit
Stock In and Stock Out registers
Automatic stock balance calculations
Purchase and issue tracking
Minimum stock levels and reorder alerts
Inventory valuation, where required
Supplier and warehouse tracking, depending on package
Stock summary and dashboard
VBA buttons for agreed repetitive tasks in advanced packages
WHY CHOOSE MY SERVICE?
I combine practical inventory management knowledge with advanced Excel formulas, reporting and dashboard design. My focus is on building a workbook that is organized, understandable, and suitable for your actual business workflow.
DELIVERY INCLUDES
A customized Excel workbook, a sample or configured data structure, and instructions for using the system.
Platform:
Excel
•
Google Sheets
•
LibreOffice
Development technology:
VBA
•
Google Apps Script
•
Power Query
Expertise:
Formulas
•
Macros
•
Dashboard
•
Power Query
•
Charts
