Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales

✔ Link to download the data file for Practice: ✔ Download the complete dashboard file from Store: 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: (To learn Offset(), Name Manager & liking chart to Dynamic range as mentioned in the video) Budget Vs Actual - Dynamic Chart: Recommended Playlist: Stock Portfolio Dashboard: Check the Links: Channel: Website: Facebook: Instagram: Share this Video: @LeanExcelSolutions #excel #excelDashboard #Dashboard #salesdashboard #pivottable #dynamicdashboard #exceltemplates #leanexcelsolutions