How to Track Inventory Trends in Excel. Tracking inventory trends helps you determine a quantity that's vital to your business's success: the amount to order for each of your products. If this ...