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
Sales Distribution Dashboard in Excel | Sales d... 20:55 - 118,584 |
Make an Interactive Excel Dashboard in 4 Simple... 19:41 - 72,471 |
How to build an outstanding Excel dashboard 34:16 - 35,992 |
Create interactive excel dashboard in 5 simple ... 40:32 - 796,962 |
Make an Awesome Excel Dashboard in Just 15 Minutes 15:27 - 1,001,536 |
Learning and Development Dashboard in Excel -Pa... 28:26 - 5,037 |
Learning and Development Dashboard in Excel - P... 09:00 - 6,029 |
Power BI & SQL Project | Data Analyst Portfolio... 46:44 - 619,403 |