Excel Pivot Tables: Monitoring Daily Inventory Valuation Changes By Day
Excel Pivot tables can be a pretty handy tool for summarizing and making sense of your data. In this example, I’ve built a small table to show you how you can use pivot tables to calculate value differences between different dates. This can come in handy especially when capturing and reviewing day over day, month over month or year over year changes. In the case below, I’ve shown how you can monitor daily changes in your inventory valuation levels to capture changes in stock levels or value. You can then use this information to do further investigation from a transactional level to determine why your stock levels may have changed in that day (i.e. cycle counts, purchase order receipts, work order completions, customer RMAs/returns etc.). (more…)
