Sales Dashboard – Lite

Description
This Excel sales analytics template allows you to track sales volume, sales revenue, cost of goods, sales profit, profit margin and year over year sales growth. This dashboard will help you identify top-performing products and track sales trends.
It is perfect for sales teams who need to improve and enhance sales performance



This ready to use sales dashboard template includes these sales key metrics:

• Sales Volume, Sales Revenue, Cost of Goods, Sales Profit and Profit Margin
• Actual vs Previous year variance
• Analyses can be filtered by year, month, division, product category and by product

Using this template is quite easy, you just need to:

• Define products, product categories and divisions
• Regularly enter or import actual sales data

Template Requirements:

• Works on PC with Windows.
• Does not work on a MAC.
• Requires Microsoft Excel 2016 or higher with Power Pivot add-in. 👉 Watch this video to find out if your Excel version includes the Power Pivot add-in https://youtu.be/-3U0Om5d_JU
• Allow Macros to run (enable content when opening file).
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on Excel file “User Guide”.

Template Customization:
Colors, fonts, and all style attributes can bechanged to suit your needs. If you want to make changes on your own, just enterthe password included with the file to unlock the template.