Revenue and Spend Analytics Excel Dashboard

Description
The file looks at a range of sales and expense metrics, compares actual to plan to and includes prior year to date positions with variances. It has a bridging waterfall chart which operates over several years and a number of other charts including a modified gauge and some interesting plan v actual charting solutions . The report uses a slicer to compare each geographic region however this could be easily changed to spin the model by department or product or operational area. Additionally the report considers metrics about customer numbers, staffing, sales volumes and cost of goods sold.

The file has a number of worksheets that feed into key calculations pages and updating the model is a matter of replacing the existing data, a short video will aid in the update of the existing model. So genuinely the metrics could be changed to suit quickly and easily, when compared to starting the process from scratch.

Users will gain the maximum benefit from this file if they are already competent spreadsheets users. The file is designed for people who use Excel on a regular basis, and are comfortable with using its tools and functions. Incorporation of new data should be plug and play considering the calculations you wish incorporated

-> If you want to acquire a full range of my Best Dashboards, have a look here: https://www.eloquens.com/tool/BN8rC7ld/startups/kpi-dashboards/premium-dashboard-models-the-very-best

-> If you want to learn with me how I actually build these Dashboards with dozens of best practices, check out my advanced video course here: https://www.eloquens.com/tool/dXVXtKZK/startups/kpi-dashboards/advanced-dashboard-design-course

- Marcus Small