Toptube Video Search Engine



Title:Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales
Duration:43:53
Viewed:1,580,822
Published:06-11-2021
Source:Youtube

✔ 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



SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :