Hi - do you need to improve the way your weekly, monthly or annual sales are reported?
It seems that many companies do not fully utilise the power of Microsoft Excel when reporting sales, cost of sales etc to their departments or senior management. Microsoft Excel’s power gives you the ability to copy and paste periodic data into a spreadsheet that automatically updates a corporate dashboard. Updating a dashboard should take no longer than the time it takes to copy and paste data. Dashboards can be as flexible or as complex as you wish but ultimately you should be able to switch views / scenarios quickly.
The use of dropdown menus or scroll bars should give users choices rather needing to guess parameters. Graphs that alter or update at the change of a dropdown or the slide of a bar.
Please contact me if you would like to discuss ad-hoc dashboard building further. I hope you find this useful.