Over the next couple of weeks, I will be building a dynamic salesman dashboard that allows the user to interact with the spreadsheet to get the information that they need. This post will first focus on building a data validation list that will immediately make the spreadsheet interactive. (more…)
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…)
Excel dynamic charting is a great way to quickly answer questions without having to go through rows and rows of data. I’ve decided to start backwards this time by providing you guys with the final product/dashboard before giving you the tutorial on how to build it. This is a great way to learn. I haven’t hidden any of the formulas so feel free to play around with this to see if you can figure out what’s going on behind the scenes. (more…)
