Here we are illustrating application of Excel and VBA in valuation of inventories of raw materials, finished goods and stock in trade.