Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales

No video

Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales

Рет қаралды 1,771,461

Lean Excel Solutions

Күн бұрын

Пікірлер: 643

@abrizhussain5357 2 жыл бұрын

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 2 жыл бұрын

Thank you so much:)

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

@NitinSingh-pb3tk 2 ай бұрын

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

@LeanExcelSolutions 2 ай бұрын

Happy to hear that 😊

@iFrankXue 10 күн бұрын

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

@LeanExcelSolutions 10 күн бұрын

Great to hear!

@ezehconfidenceadaeze6189 6 ай бұрын

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

@LeanExcelSolutions 6 ай бұрын

Happy to hear that 😊

@rubenbasco7554 Жыл бұрын

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

@RaviKumar-pr2by Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Thank you so much :)

@mbhupal18 22 күн бұрын

Very well-organized dashboard ! Great work

@LeanExcelSolutions 20 күн бұрын

Thanks a lot!

@blaed011 2 жыл бұрын

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

@LeanExcelSolutions 2 жыл бұрын

Thanks 👍

@saithejeswar5636 4 ай бұрын

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

@LeanExcelSolutions 4 ай бұрын

Great, congratulations 🎉 Happy to hear that

@careeredgeschool 2 жыл бұрын

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

@LeanExcelSolutions 2 жыл бұрын

Thanks

@Shafeek75. 2 жыл бұрын

Wow

@daniyaragaidarov7784 2 жыл бұрын

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

@LeanExcelSolutions 2 жыл бұрын

😊 Great 👍

@sandipanmajumder9419 Жыл бұрын

JUST FANTASTIC !!! MY head is blowing 🤯

@LeanExcelSolutions Жыл бұрын

Thanks a lot!

@muraliiyer7850 2 жыл бұрын

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 2 жыл бұрын

Thank you for suggesting, will take care of that!

@ja3sk3adik55 2 жыл бұрын

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

@LeanExcelSolutions 2 жыл бұрын

Thank you so much :)

@romanulislamsaju9727 5 ай бұрын

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

@LeanExcelSolutions 5 ай бұрын

Thank you so much 😊

@omarfarik2217 2 жыл бұрын

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 2 жыл бұрын

Thank you for your kind words!

@hunkysandytube 3 ай бұрын

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

@LeanExcelSolutions 3 ай бұрын

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

@tonylee5038 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

😂 Got it...!

@jocelpitogo8950 Жыл бұрын

I just placed mine. Learning is Exciting.!

@LeanExcelSolutions Жыл бұрын

Wonderful!

@abhigyanrajendra2008 5 ай бұрын

I Love your Dashboard espicially with background :)

@LeanExcelSolutions 5 ай бұрын

Thank you! 😊

@yusuf220679 2 жыл бұрын

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

@LeanExcelSolutions 2 жыл бұрын

Thank you so much

@sudhakarsudhakar529 Ай бұрын

Worthy watching. Thanks a lot

@LeanExcelSolutions Ай бұрын

Glad to hear that ☺️

@georgeslehner7733 2 жыл бұрын

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 2 жыл бұрын

🙏 Thank you for your kind words! 👍

@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 3 ай бұрын

@@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 😊👍

@MarissieV Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Happy to hear that! Thank you 😊

@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!

@marketingmanager2564 2 жыл бұрын

Very useful content, thank you for sharing Sopheak - Cambodia

@LeanExcelSolutions 2 жыл бұрын

Most welcome, thanks 👍

@hamzavlogs7855 7 ай бұрын

its was amazing very helpful for sharing your knowledge

@LeanExcelSolutions 7 ай бұрын

Glad to hear that 🙂

@krtkmz0728 26 күн бұрын

thank you. you gave me inspiration.

@LeanExcelSolutions 24 күн бұрын

I'm so glad!

@karimsamnani3660 2 жыл бұрын

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

@LeanExcelSolutions 2 жыл бұрын

👍

@apsamila 2 ай бұрын

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

@justcurious5377 Ай бұрын

new subscriber here! thank you for sharing ideas!

@LeanExcelSolutions Ай бұрын

Thank you

@brijeshshah1348 2 ай бұрын

Thanks a lot for the amazing learning experience!!

@LeanExcelSolutions 2 ай бұрын

My pleasure 😊

@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!

@pnkjtanwar Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Most welcome!

@phandongexcel 4 ай бұрын

I like this video ❤❤❤

@LeanExcelSolutions 4 ай бұрын

Thank you 😊

@gulsumtagyeva3541 7 ай бұрын

Thank you for your amazing effort!!! Awesome dashboard

@LeanExcelSolutions 7 ай бұрын

Thank you for the appreciation 😊

@agustianwijaya1 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

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

@sunhowon375 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Really appreciated, thank you!

@santoshkumar-it2gj 8 ай бұрын

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

@LeanExcelSolutions 8 ай бұрын

Glad to hear that 😊

@PoojaDas1993 2 жыл бұрын

Thanks for all this but please try to avoid using this heavy background music

@LeanExcelSolutions 2 жыл бұрын

Thanks! Yes sure, it was mistake.

@oa-level-mathematics 2 жыл бұрын

August way to explain !!!!

@PoojaDas1993 2 жыл бұрын

@@LeanExcelSolutions ur video is very useful infct i share ur channel with my friends

@LeanExcelSolutions 2 жыл бұрын

Thank you so much!

@Exceltech810 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Glad to hear that!

@francishubertovasquez2139 2 ай бұрын

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.

@SetChetra 9 ай бұрын

Really thanks for your sharing.

@LeanExcelSolutions 9 ай бұрын

Most welcome :)

@lonjezomlongoti4767 Жыл бұрын

This is great development one way to shape the career bravo

@LeanExcelSolutions Жыл бұрын

👍

@shahidahmed2190 Жыл бұрын

This video is for who knows already about dashboards, not for the beginners.

@LeanExcelSolutions Жыл бұрын

Yes, that's right, I explained it assuming viewers have at least intermediate skills in designing dashboards of this type.

@shahidahmed2190 Жыл бұрын

Any video for the beginners?

@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 11 ай бұрын

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 11 ай бұрын

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

@Mad1080 10 ай бұрын

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

@flavio225 7 ай бұрын

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

@m23isabel 2 жыл бұрын

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

@LeanExcelSolutions 2 жыл бұрын

Great! Thanks

@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 👍

@g.muthukumar 2 жыл бұрын

Excellent Work Madam

@LeanExcelSolutions 2 жыл бұрын

👍

@AmandeepSingh-sx1oi Жыл бұрын

Awesome one…detailed to start a dashboard 👍👍

@LeanExcelSolutions Жыл бұрын

Thank you 😊

@HansaniMahawewa Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

You are most welcome

@mohdshahabuddin5176 2 ай бұрын

thanks... very helpful

@LeanExcelSolutions 2 ай бұрын

Glad it helped...!

@kimjacoby1443 2 жыл бұрын

Thank you for your video. I really like the content, but find the background music too loud and distracting.

@LeanExcelSolutions 2 жыл бұрын

Yes it is. Sorry about that

@rahulrajora2271 Жыл бұрын

Hey this dashboard is mind blowing but i'm not able to get that scroll bar linking with that offset function that how does the values are being changing with every scroll down and the corresponding values are changing simultaneously. i tried plenty of times but it's not showing like there in your tutorial. Could you please help me

@ugochiji4429 Жыл бұрын

Seems the dashboard was created using excel 2021. Using excel 2019 and the rank function is not dynamic with the slicers. Nice video. Learnt a lot

@LeanExcelSolutions Жыл бұрын

It is created using office 365 excel version!

@joedelnonan5809 Жыл бұрын

I use Office 2021 and there are no issues with any functions and formulas that she used. Everything is working well.

@PreciousAfricanStoryz Жыл бұрын

Can I use excel 2016 for this

@LeanExcelSolutions Жыл бұрын

You can, but with some modifications mostly in dynamic formulas

@planetsaurus4622 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Thanks 👍, Happy to hear that 😊

@bvyuyh 11 ай бұрын

Just speechless 😊

@LeanExcelSolutions 11 ай бұрын

Thank you 🙏

@cass3616 2 жыл бұрын

Great tutorial. Thanks so much!

@LeanExcelSolutions 2 жыл бұрын

Welcome, thank

@user-om6tz9us7z 7 ай бұрын

Ticket create date : 05/01/2024 09:30 AM, Ticket closing date: 07/01/2024 12:30 PM, I want the total duration but after 09 pm to 09 am i dont want to count the hours, whats the excel formula. please help.

@Excel_Bee 2 ай бұрын

Did you get the formula?

@wenxinhuang8763 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Thank you very much 😊

@heinhtetwin8950 Жыл бұрын

It's really gorgeous. Thanks for your video.

@LeanExcelSolutions Жыл бұрын

Thank you & most welcome!

@SyedVkax 9 ай бұрын

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 9 ай бұрын

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 9 ай бұрын

@@LeanExcelSolutions Thank you 😊

@rohitadlakha2838 8 ай бұрын

Fantastic give u 101%

@LeanExcelSolutions 8 ай бұрын

Thanks 😊

@rohitadlakha2838 8 ай бұрын

Do u teach online interactive mode

@LeanExcelSolutions 8 ай бұрын

No actually, not yet

@mydocs1795 2 жыл бұрын

One of best video

@LeanExcelSolutions 2 жыл бұрын

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!

@havynguyen7050 8 ай бұрын

Thank your for sharing. It's really useful

@LeanExcelSolutions 8 ай бұрын

Happy to hear that 🙂

@amanvarma8032 2 жыл бұрын

it all went above the head

@tourgreensea5849 2 жыл бұрын

Thank you for your video.

@LeanExcelSolutions 2 жыл бұрын

You are welcome👍

@zoozooymail 2 жыл бұрын

Amazing work!

@LeanExcelSolutions 2 жыл бұрын

Thanks..!😊

@SRINUIMINLOVE Жыл бұрын

Nice work and great presentation..

@LeanExcelSolutions Жыл бұрын

Thank you...!

@user-ku1bv6xs9q 6 ай бұрын

thank u for this awesome dash board wanna ask u question isn't profit% equals (total profit/ total sales value)%? please help me with this

@LeanExcelSolutions 6 ай бұрын

Yes you are right 👍 Actually it was a mistake while explaining

@adnanmasood5344 6 ай бұрын

Great work

@LeanExcelSolutions 6 ай бұрын

Thank you 😊

@heriheri5985 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Thank you very much 😊

@devenderkumar1220 Жыл бұрын

This is amazing, nicely used of offset function.

@LeanExcelSolutions Жыл бұрын

Thank you so much!

@pelumiadeyemi3480 Жыл бұрын

Very helpful video, thank you

@LeanExcelSolutions Жыл бұрын

Glad to hear that!

@seanain1 2 жыл бұрын

Thank You

@LeanExcelSolutions 2 жыл бұрын

My pleasure!

@andrisyam5620 Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Sure, you will 😃

@francishubertovasquez2139 2 ай бұрын

Was that graphical representations of data's and files were like building structures reflectable everywhere by networks like cosmic going vertical energy structures ? How can they know where's the up and down in space ? We're they making strings or spiritual achievement reports?

@DashLiu Жыл бұрын

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

@LeanExcelSolutions Жыл бұрын

Happy to hear that! Thank you.

@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

@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 :)

@sudarshanjadhav1676 2 жыл бұрын

Thank you so much!

@LeanExcelSolutions 2 жыл бұрын

You're welcome!

@kazeemmusbau7202 2 жыл бұрын

Thank you this amazing tutorial, Please i try to download the data file but some columns were missing, columns like date, Quantity in input data sheet

@LeanExcelSolutions 2 жыл бұрын

Hi, Thank you for reaching out. I checked it. The file is ok, having all required columns.

@asopok 11 ай бұрын

Interesting video. Thanks a lot, I've learnt enough from this video. Am I permitted to work on this dataset and add to my portfolio? If yet, how do I reference the dataset?

@LeanExcelSolutions 10 ай бұрын

Yes, you can The dataset link is in the description.

@pintojustino3972 Жыл бұрын

It's an incredible explanation. My question is about creating the RANK formula. When I make the Product and UOM pivot table, the values overlap and I can't have the table with one row. Can you help me please.

@LeanExcelSolutions Жыл бұрын

Thank you for your appreciation. It is not clear to me if this will solve the rank function error, but I believe that it will 1. Choose the classic PivotTable layout by right-clicking within the pivot, clicking on Pivot Options, and then selecting Display & check the Classic PivotTable Layout option 2. Use "=RANK(Y3, Y3:Y1000)" instead of "=RANK(Y3#, Y3#)" if you are not using office 365 I hope this will be helpful to you. Thanks!

@emamul1987 Жыл бұрын

@@LeanExcelSolutions Dear madam i tried alot to make that scroll bar but never get successeed..... the option you r going through the same i go but it shows error in value. can i send you data via email so that you can check please.. kindly note it is official data, its just a learning data, most this i understand only scroll bar option is not working by me however i copy u completetly,, pleaae help me

@vetrip7153 Жыл бұрын

@@LeanExcelSolutions I tried using this "=RANK(Y3, Y3:Y1000)" instead of "=RANK(Y3#, Y3#)" 'm getting error #Value!

@lokeshmoolya5569 9 ай бұрын

@@vetrip7153I have got it thanks

@lokeshmoolya5569 9 ай бұрын

@@LeanExcelSolutionsI facing an error in offset function as I was trying to filter to check if it is working fine I am facing error of value can you pls help me with this

@thetrailer8328 Жыл бұрын

thank youu, it is help out to my problem

@LeanExcelSolutions Жыл бұрын

Great

@benmohamedhichem1988 Жыл бұрын

Great job, good lesson thank you 🙂

@LeanExcelSolutions Жыл бұрын

Much appreciated

@quannguyyen2451 Жыл бұрын

Can you explain to me about "=Rank(Y3#,Y3#)" how's it work?

@usmankhalid9370 2 жыл бұрын

Excellent tutorial. I have prepared a similar dashboard, but without product RANK. I'm unable to use this formula. I'm getting error. Can you please help.

@LeanExcelSolutions 2 жыл бұрын

Please try =RANK(Y3, Y3:Y45) this formula for better understanding, only it will not be dynamic, if the product range changes, it will required you to adjust the RANK formula range too accordingly. I used =RANK(Y3#, Y3#) to make it dynamic. I hope this will help!

@usmankhalid9370 2 жыл бұрын

@@LeanExcelSolutions thank you. Am I ask which version you were using? I used MS Excel 2019.

@LeanExcelSolutions 2 жыл бұрын

I am using office 365. That's why it was showing error to you, because # formula will not work in your case, so use the recommended formula in my earlier comment.