Interactive Sales Dashboard (excel)

Description
This ready to use interactive Excel sales and profitability dashboard allows you to visualize your sales and profit data by showing the following reports: 



The dashboard allows you to follow in real time:

1 Total Sales by year
2 Total sales by months ((trend analysis)
3 Profit by month (trend analysis) 
4 Category Sales and profit amount 
5 Sub-Category Sales amount 
6 Top 5 product sales amount
7 Salesman sales amount ranking
8 Top 5 Customer sales amount
9 Top 5 Areas sales amount
10 Geographical sales allocation map


its simple to use and interact with your needs by simply selecting from slices the reports that you need. 


User Guide:
1- Fill your data in the "Data tab" - after deleting the sample data 
2- Refresh all PV tables
3- Use slicers in dashboard tab to select whatever charts you need
4- Enjoy the dashboard


The dashboard tab is protected (with no password) just in order to keep the format save. you can simply unlock the sheet by following the below steps: 
1- go to review menue tab 
2- click on "Unprotect sheet" 
And thats it, you are free now to edit the dashboard color, size , chart , etc. 


It is a practical and easy to use tool and easy to customize.