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

@LeanExcelSolutions

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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.