Inventory Tracking Excel

An Excel file that teaches how to perform Inventory Tracking Excel operation.

Excel Dashboard for Inventory Tracking Excel

Material cards are defined. Entry and exit slips are being processed. The available amount is calculated by the formula. Critical level warnings are given. The pivot report shows the stock rotation.

Hope it is useful.