Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales

✔ Link to download the data file for Practice:

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:
(To learn Offset(), Name Manager & liking chart to Dynamic range as mentioned in the video)

Recommended Playlist:

Check the Links:

Share this Video:

@LeanExcelSolutions

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

[jaskadik]

It seems to me you are very passionate on what you do, thank you for sharing your knowledge!

[oliverelias]

Nice, Thanks for your video. This is the first time I see someone using Pivot and it confused me a little in the beginning but I was able to get very steep you took and the reason you know, I like reasoning why people do what they do. You've just got a new subscriber. Btw, I can see that you're really passionate about what you do and that your willpower is great. I hope you keep doing what you're doing 'cause you rock man. Have a nice day n_n

[xavierxon]

You created a Stunning dashboard. Great learning experience throughout the video. Thanks for sharing this knowledge with us.

[perfectvisit]

This is next level creating dashboards, amazing!
Thank you for sharing

[blaed]

Wow you are so creative. I didn't even know Excel could do that. I was mesmerized watching you build this....

[daniyaragaidarov]

Before this video i considered myself as a not bad excel user)) Thanks a lot, implemented a lot from your dashboard 🥰

[ezehconfidenceadaeze]

I just finished working on this project with the help of your video. Thanks a lot.😊

[rubenbasco]

enjoyed watching it, elevated me to be an excel enthusiast...

[avinashagivale]

Thank you from bottom of the heart for your valuable tutorial.
Thank you again.. 🙏

[joedelnonan]

Thank you very much!
I learned a lot of things because of this. All functions are working well in Office 2021 and I am able to follow all the tweaks that you did without a problem in my MS Office 2021.

It's a beautiful Dashboard. Thanks a lot (y).

[karimsamnani]

This is a wonderful Dashboard in Excel to be prepared in PowerPoint.

[sandipanmajumder]

JUST FANTASTIC !!!
MY head is blowing 🤯

[yusuf]

Amazing works and learnable too, thank you for the video, you wont get it from school.

[saithejeswar]

Thank you for this awesome tutorial and most compelling dashboard, I just finished my project !!! :)

[nguyenkimlan]

Thank you so much. It is very very useful. I love your way of transferring knowledge.

[agustianwijaya]

Your dashboards are very fun to watch and really creative. I love it & Tx

[mbhupal]

Very well-organized dashboard ! Great work

[careeredgeschool]

Well done for me, just watching your vdo I able to create one. Big thank

[misabel]

awesome will try soon hopefully can improve my productivity! thanks for the video

[RaviKumar-prby]

Wow this is first Enterprise Level Dashboard Reporting it's really awesome experience...