Description
Sales Dashboard in Microsoft Excel
We demonstrate this product on our YouTube channel as-is. It is recommended that you watch the complete tutorial before making a purchase.
Upon purchase, you can download the excel file, There are 5 sheets within the Excel Workbook-
- Dashboard: Interactive Dashboard with visuals
- Input Data: As part of the sales tracking process, this sheet needs to be updated regularly.
- Master Data: This is the product catalog sheet, which must be updated when a product is added or removed.
- Analysis: All backend calculations have been performed to visualize the data from the input sheet in this sheet.
- Color Guideline: This sheet contains the reference color codes for customizing the dashboard theme.
Additionally, the dashboard has two backgrounds, one of which is a plane and the other is a gradient fill. You can change them from the Selection Pane.
Please refer to the tutorial for more information: Sales Dashboard in Excel
Note:
- Excel Office 365 version was used to create this Dashboard
- Every time you update data, you should refresh the entire sheet (click on “Refresh All” under the Data tab).
- If you have difficulty downloading the file after making the payment, please contact us at info@leanexcelsolutions.com or use the Contact Form
- For more information, please refer to the blog: Sales Dashboard in Excel and Power BI
Reviews
There are no reviews yet.