Excel Dynamic Dashboard Friday Freebie: Watching Inventory Valuation Trends
Using the Option Button Form Control To Build a Dynamic Inventory Valuation Trend Dashboard
This week I decided to build an Excel Dynamic Dashboard using the option button. Reviewing inventory valuation trends using historical data is a great way to oversee and monitor how much inventory you are carrying in your facility at any given moment. It can also act as an indicator of whether or not you are meeting inventory reduction initiatives and targets. In this dashboard I decided to use the option button as a means of allowing the user to select a period (year) which will in turn display the inventory valuation trend for that time frame. I also included the average value of the inventory within the dashboard which also updates dynamically based on the user’s selection. (more…)
