Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales

[@debaochicho]

It takes 43.52 years for competence of excel in order to produce such a 43 min 52 sec video. Amazing!

[@LeanExcelSolutions]

😲 Good one!

[@mohammedabdullah-j3d]

It's all about your brain. It's all about how fast your brain can catch design and analytical aspects of excel. You can master excel in a year if your brain works like a pentium chip.

[@adeayoadewale-vr5pp]

This is so beautiful. Pure mastery. What stood out for me was the way you used powerpoint. That's ingenious.

[@ezehconfidenceadaeze6189]

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

[@LeanExcelSolutions]

Happy to hear that 😊

[@abrizhussain5357]

Much love from India I am not able to afford tution fees because I am single person and your tutorial is far amazing when i show this to my friend they just shocked great work and always uploads that type videos

[@LeanExcelSolutions]

Thank you so much:)

[@RaviKumar-pr2by]

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

[@LeanExcelSolutions]

Thank you so much :)

[@realCleanK]

Thanks!

[@LeanExcelSolutions]

Thank you so much! :)

[@emamul1987]

@@LeanExcelSolutions Madam i did not understand how did you manage scoll button in pivot table. can you make a video where you teach only to add scroll buton and spine button using pivot table... how did you remove 0 also from chart while seeing data for 1 item...............................

[@pauluskurniawan]

@@LeanExcelSolutions Do i need to edit from scratch? Or can i use directly ?

[@saithejeswar5636]

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

[@LeanExcelSolutions]

Great, congratulations 🎉 Happy to hear that

[@sandipanmajumder9419]

JUST FANTASTIC !!! MY head is blowing 🤯

[@LeanExcelSolutions]

Thanks a lot!

[@ja3sk3adik55]

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

[@LeanExcelSolutions]

Thank you so much :)

[@blaed011]

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

[@LeanExcelSolutions]

Thanks 👍

[@phandongexcel]

I like this video ❤❤❤

[@LeanExcelSolutions]

Thank you 😊

[@thebesttechnical3608]

Thank you so much for this. I have this urge to learn more about Excel!

[@MarissieV]

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

[@LeanExcelSolutions]

Happy to hear that! Thank you 😊

[@daniyaragaidarov7784]

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

[@LeanExcelSolutions]

😊 Great 👍

[@NitinSingh-pb3tk]

A display of masterclass by Lean excel solutions. Thank you for sharing this, It will help me and others. A lot to learn.

[@LeanExcelSolutions]

Happy to hear that 😊

[@rubenbasco7554]

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

[@mbhupal18]

Very well-organized dashboard ! Great work

[@LeanExcelSolutions]

Thanks a lot!

[@romanulislamsaju9727]

You Nailed it! What a Dashboard!?????

[@LeanExcelSolutions]

Thank you so much 😊

[@careeredgeschool]

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

[@LeanExcelSolutions]

Thanks

[@Shafeek75.]

Wow

[@iFrankXue]

Amazing job and stunning Dashboard, I got lots of new skills through your tutorial video, Thank you VERY MUCH! 😊 🌹

[@LeanExcelSolutions]

Great to hear!

[@xavierxon]

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

[@LeanExcelSolutions]

Thank you so much!

[@SDN-gi1nt]

​@@LeanExcelSolutions Hi, No doubt it's a very fantastic dashboard I loved it but as a new learner I found it a little fast and requested you to please make a little slow video and explain the things on where we should go in which ribbon and what to select. I am stopping the video taking it backwards and looking again and again where the curser is going and what you are selecting or writing. Please, it will be very helpful for billions of new learners like me... Thank you for considering my request 😊👍

[@GaffyMerchant]

Thanks alot. I prepared d same dashboard with d help of this video.. 3 cheers for u guys. Plz reduce d back music volume..

[@oliverelias1356]

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

[@LeanExcelSolutions]

Thank you so much for your kind words. Really appreciate!

[@yusuf220679]

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

[@LeanExcelSolutions]

Thank you so much

[@omarfarik2217]

My english is poor but I try to follow you. Your conception is Amazing...but tje presentation is fast for me 😁... From Cameroon thank very much

[@LeanExcelSolutions]

Thank you for your kind words!

[@abhigyanrajendra2008]

I Love your Dashboard espicially with background :)

[@LeanExcelSolutions]

Thank you! 😊

[@jocelpitogo8950]

I just placed mine. Learning is Exciting.!

[@LeanExcelSolutions]

Wonderful!

[@tonylee5038]

Her 45 mins is my 4 hours lol! Thank you!

[@LeanExcelSolutions]

😂 Got it...!

[@avinashagivale5485]

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

[@LeanExcelSolutions]

Your most welcome :)

[@nguyenkimlan9122]

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

[@LeanExcelSolutions]

Thank you for the appreciation!

[@marketingmanager2564]

Very useful content, thank you for sharing Sopheak - Cambodia

[@LeanExcelSolutions]

Most welcome, thanks 👍

[@santoshkumar-it2gj]

Thanks for your effort..... Intresting... Learn alot...

[@LeanExcelSolutions]

Glad to hear that 😊

[@hamzavlogs7855]

its was amazing very helpful for sharing your knowledge

[@LeanExcelSolutions]

Glad to hear that 🙂

[@gulsumtagyeva3541]

Thank you for your amazing effort!!! Awesome dashboard

[@LeanExcelSolutions]

Thank you for the appreciation 😊

[@muraliiyer7850]

good presentation. one suggestion if you could move the cursor little bit slow so that the viewer can understand what exactly you are doing, hope you will take care of this for future.

[@LeanExcelSolutions]

Thank you for suggesting, will take care of that!

[@karimsamnani3660]

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

[@LeanExcelSolutions]

👍

[@agustianwijaya1]

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

[@LeanExcelSolutions]

Thank you so much! I am so glad...😊

[@pnkjtanwar]

Thanks, need to learn lot of tricks from this videos.

[@LeanExcelSolutions]

Most welcome!

[@krtkmz0728]

thank you. you gave me inspiration.

[@LeanExcelSolutions]

I'm so glad!

[@sudhakarsudhakar529]

Worthy watching. Thanks a lot

[@LeanExcelSolutions]

Glad to hear that ☺️

[@brijeshshah1348]

Thanks a lot for the amazing learning experience!!

[@LeanExcelSolutions]

My pleasure 😊

[@hunkysandytube]

I thought it is possible in Power-Bi that's great innovation

[@LeanExcelSolutions]

Thanks! Indeed! Excel is incredibly capable of creating stunning dashboards with its features and functionality.

[@SetChetra]

Really thanks for your sharing.

[@LeanExcelSolutions]

Most welcome :)

[@lonjezomlongoti4767]

This is great development one way to shape the career bravo

[@LeanExcelSolutions]

👍

[@bvyuyh]

Just speechless 😊

[@LeanExcelSolutions]

Thank you 🙏

[@quotesoftheday3804]

It's really awesome one

[@LeanExcelSolutions]

Thank you 😊

[@Exceltech810]

Nice video, still have a lot to learn from this video

[@LeanExcelSolutions]

Glad to hear that!

[@m23isabel]

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

[@LeanExcelSolutions]

Great! Thanks

[@havynguyen7050]

Thank your for sharing. It's really useful

[@LeanExcelSolutions]

Happy to hear that 🙂

[@HansaniMahawewa]

Thank you so much your video was very useful and all steps are mentioned thank you so much

[@LeanExcelSolutions]

You are most welcome

[@AmandeepSingh-sx1oi]

Awesome one…detailed to start a dashboard 👍👍

[@LeanExcelSolutions]

Thank you 😊

[@joedelnonan5809]

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).

[@LeanExcelSolutions]

Much appreciated 👍

[@wenxinhuang8763]

so amazing video,i learn a lot ,thanks for sharing

[@LeanExcelSolutions]

Thank you very much 😊

[@mohdshahabuddin5176]

thanks... very helpful

[@LeanExcelSolutions]

Glad it helped...!

[@cass3616]

Great tutorial. Thanks so much!

[@LeanExcelSolutions]

Welcome, thank

[@georgeslehner7733]

AMAZING! In the video, and I understand, it's a bit of a fast pace. So I've decided to buy it (excel version) from your site. I get it in second (thru PayPal). This will give me hours and hours to fully understand and apply this technique to a future project. Surely the best spent 5$ in my entire life! Thank you!

[@LeanExcelSolutions]

🙏 Thank you for your kind words! 👍

[@g.muthukumar]

Excellent Work Madam

[@LeanExcelSolutions]

👍

[@heinhtetwin8950]

It's really gorgeous. Thanks for your video.

[@LeanExcelSolutions]

Thank you & most welcome!

[@SRINUIMINLOVE]

Nice work and great presentation..

[@LeanExcelSolutions]

Thank you...!

[@gracelawani4332]

Your dashboards are very fun to watch and really creative. Thanks for the time and effort putting this in for us to see. Curious, is there a reason you did not use data model and then power pivot when creating the relationships between the tables instead of using vlookup? Thanks

[@LeanExcelSolutions]

Thank you so much! I was trying to keep it as simple, and as lots of learners are not very familiar with Power Query and Power Pivot, I used vlookup instead

[@charbontogon2976]

As a new learner, its easy to follow what you did. I curious also for the power query and power pivot. Do you have a separate tutorial for this? Appreciate much.❤

[@LeanExcelSolutions]

Thanks, yeah it is there. You can look for the customer analytics dashboard on the channel.

[@Mad1080]

@@LeanExcelSolutionsKindly share us some sample dashboards, so that we can watch and prepare. Very curious to prepare after seeing your presentation.

[@flavio225]

Where can we download this Dashboard for training ? Please let me know your feed-back

[@tourgreensea5849]

Thank you for your video.

[@LeanExcelSolutions]

You are welcome👍

[@apsamila]

Thanks.. bro.. oya vidiyatama heduwa.. Dynamic type dash board ekak hadana heti ... puluwannam daanna..😍

[@heriheri5985]

Thanks for your sharing, so great n cool! Make me subcribed automatically 👍

[@LeanExcelSolutions]

Thank you very much 😊

[@pelumiadeyemi3480]

Very helpful video, thank you

[@LeanExcelSolutions]

Glad to hear that!

[@alahakoon6120]

W😮W This is Amazing!🔥

[@LeanExcelSolutions]

Thank you 👍

[@sahiljosan5062]

Very helpful video Subscribed 👍

[@LeanExcelSolutions]

Thanks and welcome

[@rohitadlakha2838]

Fantastic give u 101%

[@LeanExcelSolutions]

Thanks 😊

[@rohitadlakha2838]

Do u teach online interactive mode

[@LeanExcelSolutions]

No actually, not yet

[@kumaras6912]

Stunning dashboard. Thanks 👍

[@LeanExcelSolutions]

🙏 You're Welcome! 😊

[@mydocs1795]

One of best video

[@LeanExcelSolutions]

Thank you 😊

[@seanain1]

Thank You

[@LeanExcelSolutions]

My pleasure!

[@zoozooymail]

Amazing work!

[@LeanExcelSolutions]

Thanks..!😊

[@planetsaurus4622]

thanks for making this video, it helps me a lot ❤️❤️

[@LeanExcelSolutions]

Thanks 👍, Happy to hear that 😊

[@adnanmasood5344]

Great work

[@LeanExcelSolutions]

Thank you 😊

[@jun051786]

Thank you so much!

[@LeanExcelSolutions]

It's my pleasure!

[@ahmedlotfy8347]

Perfecto thank you very much

[@LeanExcelSolutions]

Most welcome,🙏

[@sunhowon375]

Can't believe it is poaaible without VBA. It's awesome!

[@LeanExcelSolutions]

Really appreciated, thank you!

[@devenderkumar1220]

This is amazing, nicely used of offset function.

[@LeanExcelSolutions]

Thank you so much!

[@benmohamedhichem1988]

Great job, good lesson thank you 🙂

[@LeanExcelSolutions]

Much appreciated

[@DashLiu]

Wonderful ! Thank you very much for this video, i really learned a lot : )

[@LeanExcelSolutions]

Happy to hear that! Thank you.

[@thetrailer8328]

thank youu, it is help out to my problem

[@LeanExcelSolutions]

Great

[@jorgecoronadohurtado2274]

Great video, thank you

[@LeanExcelSolutions]

Most welcome!

[@realCleanK]

Thank you!

[@LeanExcelSolutions]

Welcome!

[@SyedVkax]

Great Video, Its really fun to watch your videos. I was just curious about how can I add developer tab into my excel 2016?

[@LeanExcelSolutions]

Thank you for your kind words! It is a pleasure to hear that you enjoyed the video. To add the Developer tab in Excel 2016, go to the "File" tab, select "Options," choose "Customize Ribbon," and check the box next to "Developer."

[@SyedVkax]

@@LeanExcelSolutions Thank you 😊

[@michaelmatsumura422]

Thanks for the video. I can’t get the scroll bar to work (20:40). I use Office 365. Any help will be greatly appreciated!

[@amanvarma8032]

it all went above the head

[@annaisatse8958]

Hi i t thank you for this video Good job to be continous

[@LeanExcelSolutions]

Thank you!

[@vaibhavsrivastava7945]

Very Good mam very nice dashboard

[@LeanExcelSolutions]

Thank you so much :)

[@yasirshakoor1023]

Very Creativity and learn more for you

[@LeanExcelSolutions]

Thank you so much 😀

[@yasirshakoor1023]

@@LeanExcelSolutions Welcome

[@yasirshakoor1023]

@@LeanExcelSolutions Have you any chat room or group for helping related excel from you or other

[@francishubertovasquez2139]

That pivot table data and files segregation into that 4 box at the right side reminds me of the 4 's of the Earth areas.

[@jamesjai100]

Excellent Info..

[@LeanExcelSolutions]

Thank you so much😊

[@andrisyam5620]

I love it, and I will try. Hopefully I can make a beautiful dashboard like this

[@LeanExcelSolutions]

Sure, you will 😃

[@fawmelemele]

very good

[@LeanExcelSolutions]

Thanks 🙏

[@imrandaud478]

Beautiful

[@LeanExcelSolutions]

Thank you! Cheers!

[@iliesboukhatem7803]

a great video! thank you so mush

[@LeanExcelSolutions]

much appreciated 👍

[@sajedabegum2204]

How you do this? just incredible

[@black_Mamba2507]

I followed the instruction to the second, only thing that is nit working is the offset function, hows it working for you as you enter the formula, it automatically gets updated for the cells below...please advise 😢

[@LeanExcelSolutions]

Those formulas are dynamic array formulas available in the office 365 version.

[@kazirahim4764]

Great skills

[@LeanExcelSolutions]

Thanks

[@elhaidizaka7193]

great thank u

[@LeanExcelSolutions]

Most welcome!

[@Austinlenardvas]

Thank you.

[@LeanExcelSolutions]

Welcome

[@primeoflight6674]

Appreciated ❤

[@LeanExcelSolutions]

Thank you