Revenue and Expense Report by Region

Description
The Excel dashboard draws on the rollover cell method that allows you to rollover cells with your mouse and change the metrics. The Excel rollover technique in combinartion with dashboards is a simple concept which has far reaching implications for interactive Excel dashboards. The years on the right of the dashboard are interactive and as your mouse rolls over these cells the whole dashboard will change to reflect the data in that particular year. Conditional formatting is used heavily to highlight the active year and the numerical tables. While the dashboard has quite a bit of information I ran out of fresh ideas in the right bottom so put the social media symbols for that particular section, kind of works though. There is a drop down on the right to choose region and there is a dropdown in the web tracking section to choose the country statistics.

To find and benefit from more downloadable Excel tools from The Smallman, please visit my channel page where you can find an even broader range of metrics and dashboards.

If you have any questions regarding this tool, don’t hesitate to reach out by starting a discussion below or private messaging directly through my Eloquens author channel.