Just showed my boss what we can do for dashboards, booked marked the video for when we decide what's going to go in the dashboards and subscribed. We think you rock!
I was the one who hate this spreadsheet for years...but man, you got me! You've convinced me and changed my vision how good this amazing Excel could do for us! For me, is far the best Excel tutorial in UA-cam! I will subscribe immediately on your channel!
Hey Filipe, thanks for your inspiring words and Pivot Tables will change your life and the way that you report data! You may also get a promotion after presenting this to your boss! Cheers, John
wow, every time I looked into a new video , i find more info and new stuff being taught, but this is by far a very nice way of expalining and a calm cool voice and no rush to teach, a pleasant way of teaching and above all I learned from this tutorial. Thumbs up for you Sir, and a big Thank you. I will be going through your other videos as well. So again Tusen Takk
+Wasim Bader Hey Wasim, thank you very much for the kind comments and feedback, I really appreciate it :) I am glad that you liked the videos and feel free to share them with your friends & colleagues. Thanks, John
one of the best excel tutorial on youtube, they also provide more than 230 workbook for practice along with 10 hours excel class video, awesome work by JOHN,, KEEP IT Up,, guys if facing diffculties to get excel workbook or goodies, so after following the instruction by clicking the link ,, make sure that thw file will be on promotion folder of gmail which will be on heading of gmail,, thank u,,
I hope so as well. It's such a marketable skill. Check out our website as well if you would like to enroll in one of our courses. www.myexcelonline.com
Hi John.. thanks for this quick tutorial on creating a simple dashboard from Pivot Tables and Pivot Charts. Picked up some nice formatting and style tips from your setup. Thanks for sharing. Thumbs up!
Thanks Alex and Im sure that this easy to create Excel Dashboard will make you stand out from the crowd! Feel free to share with your friends & colleagues :) Thanks, John
This is an excellent tutorial. I found it very helpful with the steps. You are a great teacher as you seem to understand exactly what I am struggling with. I cant than you enough!
John, I must congratulate you to understand real pain areas of Executives in preparing reports for the Business Leaders. This is a great online tutorial I have seen in recent times & applied in first go :)
rishab jain You are welcome Rishab! I will have more videos posted throughout the coming weeks so keep an eye out on these. Feel free to share the above video to your friends and colleagues :) Thanks, John
You are welcome Ayokunle and I hope that you learned the power of Excel and Pivot Tables. Feel free to share with your friends & colleagues. Cheers, John
Kelsee McVey I am glad you enjoyed the tutorial and I appreciate your kind words Kelsee. Be sure to watch my other tutorials on my UA-cam channel. Thanks, John
Fischer12345 Fischer, You can have your data in another Excel workbook or an external data source like Microsoft Access and your Pivot Tables will still work. All you need to do is to make sure to Refresh your Pivot Table when you open it to update it with the changes made in the other workbook/Access database. I have a tutorial here: 1drv.ms/1Fime1N I hope this helps. Thanks, John
WOW! Just what I've been looking for. Tried to teach myself using "Help"" but as usual it wasn't very helpful! Will let you know how my presentation goes!!! Awesome...
Thanks for this. I have created pivot tables and graphs from various sheet. How do I get percentage difference between each of them. Eg: A graph - this is for task to show time taken in different scenarios. The pivot graph has this for different version run. i.e blue is for V1 time taken in task1 under scenario1 and red is for V2 time taken in task1 under scenario1. I need comparison (percentage difference) between V1 and V2 time taken. Please let me know how to achieve this ?
Hello, Im Alberto Ribeiro From Brasil . My English is not very good, But I can't let to say congratulations your job is very good. thanks for share with us. And sorry for my bad english.
Hello Joey, Your data can be imported from external data sources and placed in a Data sheet within your Excel workbook. When you create your Dashboard, this is created in a new Sheet. Whenever you press Refresh All, the Data sheet gets updated (importing the latest external data) and then the Dashboard sheet gets updated automatically. I go through this in detail in the Xtreme Pivot Table course: myexcelonline.thinkific.com/courses/xtreme-excel-pivot-table-online-course Cheers, John
Hi Tanner, Yes you can customize the Slicers to your liking & can get very creative as well. Have a look at the following link which has a video tutorial and workbook that is part of my course: 1drv.ms/1HZBWCc Let me know if this help you out. Cheers, John
Just showed my boss what we can do for dashboards, booked marked the video for when we decide what's going to go in the dashboards and subscribed. We think you rock!
+Margi Reid I am glad that I could help your company understand how easy it is to analyze and present data with a few clicks.
Cheers,
John
I was the one who hate this spreadsheet for years...but man, you got me! You've convinced me and changed my vision how good this amazing Excel could do for us! For me, is far the best Excel tutorial in UA-cam! I will subscribe immediately on your channel!
Hey Filipe, thanks for your inspiring words and Pivot Tables will change your life and the way that you report data! You may also get a promotion after presenting this to your boss!
Cheers,
John
Awesome.You have explained everything by the simple way.Highly appreciated
Glad you enjoyed it
Wow! Really useful tutorial! Thank you a lot!
You are welcome
Exciting stuff explained in a simple and short video. Looking forward for more such tutorials. Thanks!
We have plenty more of these tutorials on our Channel Playlist!
wow, every time I looked into a new video , i find more info and new stuff being taught, but this is by far a very nice way of expalining and a calm cool voice and no rush to teach, a pleasant way of teaching and above all I learned from this tutorial. Thumbs up for you Sir, and a big Thank you. I will be going through your other videos as well. So again Tusen Takk
+Wasim Bader Hey Wasim, thank you very much for the kind comments and feedback, I really appreciate it :)
I am glad that you liked the videos and feel free to share them with your friends & colleagues.
Thanks,
John
one of the best excel tutorial on youtube, they also provide more than 230 workbook for practice along with 10 hours excel class video, awesome work by JOHN,, KEEP IT Up,,
guys if facing diffculties to get excel workbook or goodies, so after following the instruction by clicking the link ,, make sure that thw file will be on promotion folder of gmail which will be on heading of gmail,, thank u,,
Glad it was helpful!
Great learning sir. I hope my excel improves after watching this.
I hope so as well. It's such a marketable skill. Check out our website as well if you would like to enroll in one of our courses. www.myexcelonline.com
Hi John.. thanks for this quick tutorial on creating a simple dashboard from Pivot Tables and Pivot Charts. Picked up some nice formatting and style tips from your setup. Thanks for sharing. Thumbs up!
I'm glad you enjoyed this Excel Pivot Table Dashboard tutorial Wayne :)
I have learnt so much from you. You are my go-to person now for excel learning.
Thanks for your kind words and they mean a lot to me. Happy to be the person to make you better at Excel 😀
You make it simple and intresting.
Thanks for the video.
Im glad you enjoyed our Excel Dashboard tutorial Dipti!
Very clear and concise must give this a bash on Monday
Im glad you enjoyed this great Excel Pivot Table video that I created GarlicD! Feel free to share this with your friends & colleagues!
Thanks,
John
Fabulous lecture :-) Very easy to follow along, easy to understand the explanations and last but not least, very nice dashboard!
Thanks Alex and Im sure that this easy to create Excel Dashboard will make you stand out from the crowd!
Feel free to share with your friends & colleagues :)
Thanks,
John
Fabulous presentation.Even a beginner to excel can understand with ease.Please share more videos.
+Priyank Agrawal You are welcome Priyank.
Cheers,
John
This is one of the better instructional vids I've seen, great job.
Maurisse Johnson Hey Maurisse, I am glad you eenjoyed the tutorial! Feel free to share this with your colleagues.
Thanks,
John
This is an excellent tutorial. I found it very helpful with the steps. You are a great teacher as you seem to understand exactly what I am struggling with. I cant than you enough!
+Hi OCTANE Cheers buddy, thank you for the great feedback and I am glad that you found this tutorial helpful. Keep on Excelling!
Thansk,
John
Excellent Presentation !
+mungringla I am glad you liked the video Mungringla :) Feel free to share with your friends.
Thanks,
John
Informative and useful video.Very well demostrated with the good spread sheet.
Keep up the good work.
Very much appreciate
mansur mohammed hanif Cheers Mansur, I am glad you found it useful!
This is a fantastic piece of skill. Thanks a lot
I am glad you enjoyed this tutorial Jackson, Slicers are awesome!
Great tutorial. I will definitely be implementing Pivot Table Dashboard into my next presentation.
Awesome news Tanisha! I am sure that you will knock your boss of his/her chair with your cool dashboard!
Cheers,
John
Thanks a lot for the demo. It's simple and very easy to understand. Thanks again.
+Satya Mahesh Glad you liked the tutorial Satya :)
Cheers,
John
This is a game changer....awesome job
+Gary Ford, Jr. Slicers are definitely a game changer :)
John
Awesome tutorial. Thanks!
You are welcome Kyle and I hope this Excel Dashboard can give you lots of ideas of what is possible!
Cheers,
John
Excellent Tutorial... I will be viewing your others as well... great work. Steve
Steve Hearn I am glad you enjoyed the tutorial Steve!
Informative & Simple, Highly appreciated John
abz massani I am glad you liked this tutorial abz. Feel free to share with your colleagues and friends.
Thanks,
John
Absolutely brilliant. This will surely help in impressing the bosses. Thanks a lot for sharing
hema sheela I hope your boss gives you a pay rise after this :)
John, I must congratulate you to understand real pain areas of Executives in preparing reports for the Business Leaders. This is a great online tutorial I have seen in recent times & applied in first go :)
You are welcome Ajit and you can also check out my other videos which you will also find very valuable!
Wow Great Tutorial Nice to learn this topic
Thanks MyExcelOnline
+Ajay Kumar You are welcome Ajay!
Thanks,
John
great tutorial!
Leví Barbosa Thank you Levi :)
Thank you very much. Great lecture
ONUR KAFALI You are welcome Onur! Feel free to share this video with your friends and colleagues.
All the best.
John
I think this is brilliant, this is exactly what people wants to know.
Very nice stuff.
+Harshal Patil Thanks Harshal, please feel free to share with your friends ;)
Thanks,
John
Very helpful concise presentation.
Many thanks!
You are welcome Muuip :)
Thanks,
John
Very well done. Thanks!
+Erica Dyson Thank you very much Erica, I am glad you enjoyed the lesson :)
Thanks,
John
very useful knowledge, thank you
You are welcome Rahmat :)
Simply Superb, very impressive.
Arunkumar Kesavan I am glad you enjoyed the tutorial! Feel free to share with your colleagues and friends.
Thanks,
John
This is fantastic!
+Cecelia Martins Thank you Cecelia, I appreciate it :)
John
Great video! Thanks !
+Armin Nieswand You are welcome Armin :)
Wonderful video Sir
You are welcome Maqsood! Feel free to pass on this tutorial to your friends & colleagues so they too can learn the power!
Thanks,
John
sure Sir
Thank You for the inputs.
Rajarshi Bahu You are welcome!
Very well explaned. Thanks a lot! :)
+ATQ You are welcome ATQ!
Cheers,
John
Good sharing👍👍
Thanks! Glad you like it enough to pass it along!
Thank you a lot. I learned a lot.
You are welcome 🙏
Thank you so much for the video. Wish to get more such insightful information in the future as well.
rishab jain You are welcome Rishab! I will have more videos posted throughout the coming weeks so keep an eye out on these. Feel free to share the above video to your friends and colleagues :)
Thanks,
John
thank you! helpful so much
Im glad you liked this Excel Dashboard!
Brilliant! Wow great tutorial. Thanks...
You are welcome Diana. If you loved this video then you will be blown away by the online Pivot Table course!
Thanks,
John
This is super helpful! Thanks a ton - you're the best.
+Ankita Mehrotra Glad you liked the video Ankita :) Feel free to share with your friends & colleagues.
Thanks,
John
Wowww... Such a beautiful use of Slicers. Thank u for sharing
You are welcome Meena, glad to help!
If I can ask for any help related to Excel query, where can I post it dear MyExcelOnline
YOu can post it within the course discussions here: myexcelonline.thinkific.com/courses/xtreme-excel-pivot-table-online-course
Cheers,
John
Thank u John.. Appreciate ur early response
Great work man. Just what I was looking for.
You are welcome Ricardo!
Cheers,
John
Can u share the excel workbook please, so we can pratice it our own.
Sure: myexcelonline.lpages.co/youtube-dashboards-in-15-minutes-workbook-downloads/
Thanks for sharing this!
You are welcome Ayokunle and I hope that you learned the power of Excel and Pivot Tables.
Feel free to share with your friends & colleagues.
Cheers,
John
Hiii John...your tutorial very helpful, thanks so much
+suroto fadhilah You are welcome Suroto, glad that I could help you :)
Thanks,
John
excellent one!
+Indrayan Bhattacharya Glad you liked it Indrayan :)
Cheers,
John
I am so amazed by this. So easy. Thank you for this video!
You are welcome Lima, Dashboards are awesome :)
Very nice, thank you so much
You are welcome Hamza, feel free to share the knowledge with your friends & colleagues :)
Thanks,
John
Thank you very much !!! it helps me A LOT!!
You are welcome Fuad :)
Cheers,
John
Thank you, thank you, thank you... Awesome video Sir. Much appreciated
You are most welcome Rex :)
Cheers,
John
Thank you so much informative indeed
Im glad you liked this Excel Dashboard video Sukanta!
VERY GOOD INFORMATION ! tHANK YOU
You are welcome :)
Wonderful it has help me so much. Thanks.
You are welcome Deng! I am glad that this tutorial has helped you out :)
Cheers,
John
Nice Job !!! thanks for share!
You are welcome Armando and glad that this Excel tutorial has helped you out!
Cheers,
John
Love it. Exactly what I was looking for. Thanks!
I am glad you enjoyed this tutorial :)
It is a great VDO Training. Thank you very much It helps me upgrade my job.
wasana rienthong You are welcome Wasana :) Glad to have increased your Excel skills!
Awesome, very gud informative....
Hemanth Kumar Thank you Hemanth!
Thanks a lot for your great tutor.
You are welcome Nguyen, I'm more than happy to share my Excel knowledge!
Very good, thanks
+Eric Zhu You are welcome Eric :)
Thanks,
John
Thank you very helpful
+Gorugantu Subrahmanyam You are welcome :)
Cheers,
John
this very good stuff, thanks for all the hardwork.
You are welcome Saket, feel free to share this with your friends & colleagues!
Cheers,
John
Thanks for the great tutorial!
+John B You are welcome John!
Cheers,
John
brilliant stuff !!
+ashwini kapoor Cheers Ashwini :)
That was great.. Thumps Up
Thanks Tanvir, I'm glad you liked this video :)
Cheers,
John
This is the best tutorial I've found. Thank you so much!
Kelsee McVey I am glad you enjoyed the tutorial and I appreciate your kind words Kelsee.
Be sure to watch my other tutorials on my UA-cam channel.
Thanks,
John
Hi bro, thanks for your lesson, it will very helpful for my presentation, once again thanks
+thomas grea You are most welcome!
That's awesome, thanks so much!!!
You are welcome Roxanne & glad to help you get better at Excel Pivot Tables!
Cheers,
John
Thanks a lot for this. even afther all these years this helped me so muich. My boss is verry impressed with me thanks!
Great to hear! Please share this video with all your contacts :)
great job
You are welcome Solomane & glad to help you get better at Excel Pivot Tables!
Cheers,
John
very clear tutorial. very precise ! Your awesome! I can kick my boss ass for this!
You should be a boss after you create a Dashboard like this!
Awesome thanks!
+Dephine Wolfe Glad you liked the tutorial Dephine :)
Cheers,
John
For info, Mac 2011 doesn't support slicers which is very disappointing, I was so looking forward to trying this out. :-(
+Dephine Wolfe You will need Mac 2016 which comes with Slicers. Worth the investment :)
Thanks A Lot!!
You are welcome Esan :)
Excelent !!!!!!!!!!!!!!!!!!!!!!!! Thanks a lot !
+Mario Escudero You are welcome Mario :)
This is amazing! How cool!
I am glad you enjoyed this tutorial :) Slicers & Pivot Charts rock!
Thanks so much
You are welcome Usama!
Thanks,
John
Great Tutorial!! It was exactly what I needed to know. Thank you for sharing your knowledge!
Jill Kotara I am glad you enjoyed this tutorial Jill and hope you use it at work to stand out!
Cheers,
John
Wow, that looks really nice!
Fischer12345 I am glad you enjoyed the tutorial Fischer!
Learn Excel Pivot Tables Yes I really did. Is it also possible to link the data to other worksheets so it can be updated?
Fischer12345 Fischer,
You can have your data in another Excel workbook or an external data source like Microsoft Access and your Pivot Tables will still work. All you need to do is to make sure to Refresh your Pivot Table when you open it to update it with the changes made in the other workbook/Access database.
I have a tutorial here: 1drv.ms/1Fime1N
I hope this helps.
Thanks,
John
Learn Excel Pivot Tables Excellent, thank you also for posting the tutorial.
WOW! Just what I've been looking for. Tried to teach myself using "Help"" but as usual it wasn't very helpful! Will let you know how my presentation goes!!! Awesome...
+liaperth Good luck and I am sure you will succeed!
Cheers,
John
Thank you
You are welcome and I'm glad you enjoyed our Excel Dashboard tutorial!
So great
+Abulwahab Al-anesi Thanks :)
This is great
+EQFingers Glad you enjoyed the tutorial :)
Cheers,
John
Thank you so much!
You are welcome Theresa, feel free to share this with your friends & colleagues!
Cheers,
John
Thanks for this. I have created pivot tables and graphs from various sheet. How do I get percentage difference between each of them. Eg: A graph - this is for task to show time taken in different scenarios. The pivot graph has this for different version run. i.e blue is for V1 time taken in task1 under scenario1 and red is for V2 time taken in task1 under scenario1. I need comparison (percentage difference) between V1 and V2 time taken. Please let me know how to achieve this ?
+Aarti Rao Can you please send me your sample workbook at john@myexcelonline.com and I will have a look at this for you.
Thanks,
John
Hello, Im Alberto Ribeiro From Brasil .
My English is not very good,
But I can't let to say congratulations your job is very good.
thanks for share with us.
And sorry for my bad english.
+alberto valentim Thank you Alberto for your kind words :) Your English is very good!
Cheers,
John
Great tutorial. What if I have external data. Can it be imported without building the Dashboard from the start again?
Hello Joey, Your data can be imported from external data sources and placed in a Data sheet within your Excel workbook.
When you create your Dashboard, this is created in a new Sheet.
Whenever you press Refresh All, the Data sheet gets updated (importing the latest external data) and then the Dashboard sheet gets updated automatically.
I go through this in detail in the Xtreme Pivot Table course: myexcelonline.thinkific.com/courses/xtreme-excel-pivot-table-online-course
Cheers,
John
thanks
+Vikram Dhimmar You are welcome Vikram :)
Awesome :)
Rajesh Sharma I am glad you enjoyed the tutorial Rajesh :)
Cheers,
John
Excellent video John. Did you use Camtasia to record same?
+Carlton Seymour Hey Carlton, Yes I use Camtasia to record these videos.
Cheers,
John
How have I not used slicers? Oh man time to redo some things. Thanks!!! Great info.
+Paul Burton Slicers are the best thing since "Sliced" bread :)
Great thanks.
+Naresh Sen You are welcome Naresh :)
John
Easy, simple tutorial, great!!! by any chance can we download the workbook on the video, the current link is not working. Thanks!
+JOSE LUIS Suarez Thanks for letting me know about this issue Jose. I have fixed it and you can now download the workbooks :)
Cheers,
John
Mantap. Thank you
Roni Tahir You are welcome Roni :)
Awesome
+Pratik Mujumdar Glad you liked it Pratik. Feel free to share it with your friends and colleagues :)
:)
+Pratik Mujumdar Glad you liked it Pratik :)
This is excellent. Thank you. Is there a way to change the formatting of the slicers beyond the pre-formatted options?
Hi Tanner,
Yes you can customize the Slicers to your liking & can get very creative as well. Have a look at the following link which has a video tutorial and workbook that is part of my course: 1drv.ms/1HZBWCc
Let me know if this help you out.
Cheers,
John