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 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...............................
@@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 😊👍
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
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.
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
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
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.❤
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
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!
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."
I Stuck on the Video at 18:57 Second when you used offset and then applied Rank formula, In your Formula bar showing Rank(Y3#,Y3#)? I applied rank formula and then i Selected the Month Slicer but when i select the Feb values are showing error in the range selected. Please Help.
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?
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.
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!
@@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
@@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
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.
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!
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.
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?
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).
Thanks for sharing this video, The Formula Offset doesn't work in office 2019. Can i have a solution to this problem or equivalent to this formula??? Thanks agin
It takes 43.52 years for competence of excel in order to produce such a 43 min 52 sec video. Amazing!
😲 Good one!
This is so beautiful. Pure mastery.
What stood out for me was the way you used powerpoint. That's ingenious.
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
Thank you so much:)
I just finished working on this project with the help of your video. Thanks a lot.😊
Happy to hear that 😊
Wow this is first Enterprise Level Dashboard Reporting it's really awesome experience...
Thank you so much :)
JUST FANTASTIC !!!
MY head is blowing 🤯
Thanks a lot!
It seems to me you are very passionate on what you do, thank you for sharing your knowledge!
Thank you so much :)
Thank you for this awesome tutorial and most compelling dashboard, I just finished my project !!! :)
Great, congratulations 🎉
Happy to hear that
Wow you are so creative. I didn't even know Excel could do that. I was mesmerized watching you build this....
Thanks 👍
You Nailed it! What a Dashboard!?????
Thank you so much 😊
Thanks!
Thank you so much! :)
@@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...............................
@@LeanExcelSolutions Do i need to edit from scratch? Or can i use directly ?
Well done for me, just watching your vdo I able to create one. Big thank
Thanks
Wow
Very well-organized dashboard ! Great work
Thanks a lot!
Thanks alot. I prepared d same dashboard with d help of this video.. 3 cheers for u guys. Plz reduce d back music volume..
This is next level creating dashboards, amazing!
Thank you for sharing
Happy to hear that!
Thank you 😊
You created a Stunning dashboard. Great learning experience throughout the video. Thanks for sharing this knowledge with us.
Thank you so much!
@@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 😊👍
enjoyed watching it, elevated me to be an excel enthusiast...
Before this video i considered myself as a not bad excel user)) Thanks a lot, implemented a lot from your dashboard 🥰
😊 Great 👍
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
Thank you for your kind words!
A display of masterclass by Lean excel solutions. Thank you for sharing this, It will help me and others. A lot to learn.
Happy to hear that 😊
Amazing works and learnable too, thank you for the video, you wont get it from school.
Thank you so much
I just placed mine. Learning is Exciting.!
Wonderful!
Her 45 mins is my 4 hours lol! Thank you!
😂 Got it...!
Amazing job and stunning Dashboard, I got lots of new skills through your tutorial video, Thank you VERY MUCH! 😊 🌹
Great to hear!
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
Thank you so much for your kind words. Really appreciate!
I Love your Dashboard espicially with background :)
Thank you! 😊
This is a wonderful Dashboard in Excel to be prepared in PowerPoint.
👍
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.
Thank you for suggesting, will take care of that!
Thank you from bottom of the heart for your valuable tutorial.
Thank you again.. 🙏
Your most welcome :)
I thought it is possible in Power-Bi
that's great innovation
Thanks!
Indeed! Excel is incredibly capable of creating stunning dashboards with its features and functionality.
its was amazing very helpful for sharing your knowledge
Glad to hear that 🙂
Thank you so much. It is very very useful. I love your way of transferring knowledge.
Thank you for the appreciation!
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
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
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.❤
Thanks,
yeah it is there. You can look for the customer analytics dashboard on the channel.
@@LeanExcelSolutionsKindly share us some sample dashboards, so that we can watch and prepare. Very curious to prepare after seeing your presentation.
Where can we download this Dashboard for training ? Please let me know your feed-back
Worthy watching. Thanks a lot
Glad to hear that ☺️
Thank you for your amazing effort!!! Awesome dashboard
Thank you for the appreciation 😊
Thanks, need to learn lot of tricks from this videos.
Most welcome!
Very useful content, thank you for sharing
Sopheak - Cambodia
Most welcome, thanks 👍
Your dashboards are very fun to watch and really creative. I love it & Tx
Thank you so much! I am so glad...😊
Thanks for your effort..... Intresting... Learn alot...
Glad to hear that 😊
Nice video, still have a lot to learn from this video
Glad to hear that!
thank you. you gave me inspiration.
I'm so glad!
Thanks.. bro.. oya vidiyatama heduwa.. Dynamic type dash board ekak hadana heti ... puluwannam daanna..😍
I like this video ❤❤❤
Thank you 😊
Thanks a lot for the amazing learning experience!!
My pleasure 😊
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!
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
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!
🙏 Thank you for your kind words! 👍
Really thanks for your sharing.
Most welcome :)
awesome will try soon hopefully can improve my productivity! thanks for the video
Great!
Thanks
This is great development one way to shape the career bravo
👍
Great Video, Its really fun to watch your videos. I was just curious about how can I add developer tab into my excel 2016?
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."
@@LeanExcelSolutions Thank you 😊
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
Hi, Thank you for reaching out. I checked it. The file is ok, having all required columns.
Thank you so much your video was very useful and all steps are mentioned thank you so much
You are most welcome
How you do this? just incredible
Awesome one…detailed to start a dashboard 👍👍
Thank you 😊
Can't believe it is poaaible without VBA.
It's awesome!
Really appreciated, thank you!
I Stuck on the Video at 18:57 Second when you used offset and then applied Rank formula, In your Formula bar showing Rank(Y3#,Y3#)? I applied rank formula and then i Selected the Month Slicer but when i select the Feb values are showing error in the range selected. Please Help.
Thank your for sharing. It's really useful
Happy to hear that 🙂
It's really awesome one
Thank you 😊
Excellent Work Madam
👍
Great tutorial. Thanks so much!
Welcome, thank
Just speechless 😊
Thank you 🙏
It's really gorgeous. Thanks for your video.
Thank you & most welcome!
Nice work and great presentation..
Thank you...!
so amazing video,i learn a lot ,thanks for sharing
Thank you very much 😊
This video is for who knows already about dashboards, not for the beginners.
Yes, that's right, I explained it assuming viewers have at least intermediate skills in designing dashboards of this type.
Any video for the beginners?
Thanks for all this but please try to avoid using this heavy background music
Thanks!
Yes sure, it was mistake.
August way to explain !!!!
@@LeanExcelSolutions ur video is very useful infct i share ur channel with my friends
Thank you so much!
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?
Yes, you can The dataset link is in the description.
such an insightful video, but the file practice is not available to be downloaded, can you please recheck the provided link? thank you in advance
Hi, thanks for the feedback.
After you comment, I checked it & realise the website is down. We will resolve the issue soon.
Thank you for your video.
You are welcome👍
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.
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!
@@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
@@LeanExcelSolutions I tried using this "=RANK(Y3, Y3:Y1000)" instead of "=RANK(Y3#, Y3#)" 'm getting error #Value!
@@vetrip7153I have got it thanks
@@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
Very helpful video, thank you
Glad to hear that!
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
Yes you are right 👍
Actually it was a mistake while explaining
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
It is created using office 365 excel version!
I use Office 2021 and there are no issues with any functions and formulas that she used. Everything is working well.
Can I use excel 2016 for this
You can, but with some modifications mostly in dynamic formulas
W😮W This is Amazing!🔥
Thank you 👍
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.
Amazing work!
Thanks..!😊
Can you explain to me about "=Rank(Y3#,Y3#)" how's it work?
thanks for making this video, it helps me a lot ❤️❤️
Thanks 👍, Happy to hear that 😊
thanks... very helpful
Glad it helped...!
it all went above the head
Stunning dashboard. Thanks 👍
🙏 You're Welcome! 😊
One of best video
Thank you 😊
Great work
Thank you 😊
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.
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!
@@LeanExcelSolutions thank you. Am I ask which version you were using? I used MS Excel 2019.
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.
Fantastic give u 101%
Thanks 😊
Do u teach online interactive mode
No actually, not yet
This is amazing, nicely used of offset function.
Thank you so much!
Can you make a video where were can create a dashboard for academic analysis like trainees scores, performance stats etc? good job btw thank you
Thanks for the idea!
while creating tree map chart, you said that it will not update with the slicers but it is getting updated.
🤔I think, I said that the tree map can not be inserted with Pivot table.
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?
Very helpful video
Subscribed 👍
Thanks and welcome
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).
Much appreciated 👍
Thanks for sharing this video, The Formula Offset doesn't work in office 2019.
Can i have a solution to this problem or equivalent to this formula???
Thanks agin
Thanks for your sharing, so great n cool! Make me subcribed automatically 👍
Thank you very much 😊
Thank you so much!
It's my pleasure!
Hi, Have you make a tutorial for making excel dashboars that we can update the data (add more colum) monthly?
CAN ANYBODY PLEASE HELP ME IN UNDERSTANDING 18:46 (RANK FORMULA), WHAT FORMULA WAS RETURN THERE
I love it, and I will try. Hopefully I can make a beautiful dashboard like this
Sure, you will 😃
Thank you!
Welcome!
Can you please make a video on how to save and share in both pdf and excel format? As the dimensions matters!