Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales

✔ Link to download the data file for Practice:
https://leanexcelsolutions.com/sales-dashboard-in-excel-power-bi/

✔ Download the complete dashboard file from Store: https://leanexcelsolutions.com/product/sales_dashboard_b2c_bussiness_in_excel/

There are 5 sheets within the Excel Workbook-
1. Dashboard: Interactive Dashboard with visuals
2. Input Data: This sheet has to be updated regular basis to capture actual sales data
3. Master Data: This is the product catalog sheet, which has to be updated on the addition/ deletion of the product from the list
4. Analysis: This sheet includes all backend calculations done to visualize the data from the input sheet.
5. Color Guideline: This sheet has the reference color codes to customize the theme of the dashboard.

Interactive sales dashboard designed in Excel for B2C type of Businesses using Slicers, Pivot Tables & Pivot Chart. Learn step-by-step to create a highly visual dashboard in excel.

Timeline:
00:00 - Introduction
01:03 - Dashboard Overview
02:16 - Datasheets Overview
05:10 - Prepare Database
10:31 - Analysis & Prepare Visuals
26:04 - Design Background
31:14 - Design Dashboard
38:48 - Format Visuals
Recommended Videos:
Dynamic Scrolling Chart: https://youtu.be/OiqTUO-Jcnk
(To learn Offset(), Name Manager & liking chart to Dynamic range as mentioned in the video)

Budget Vs Actual - Dynamic Chart: https://youtu.be/7XnkMcWN93w

Recommended Playlist:
Stock Portfolio Dashboard: https://youtube.com/playlist?list=PLYjYcSjCw_LVwmbPXEEmRwOGzh_M_vLNf

Check the Links:
Channel: https://www.youtube.com/c/LeanExcelSolutions

Website: https://leanexcelsolutions.com

Facebook: https://www.facebook.com/LeanExcelSolutions/

Instagram: https://www.instagram.com/leanexcelsolutions/

Share this Video:
https://youtu.be/bjLIA1vSqGs

@Lean Excel Solutions

#excel
#excelDashboard
#Dashboard
#salesdashboard #pivottable #dynamicdashboard #exceltemplates #leanexcelsolutions

Видео Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales канала Lean Excel Solutions