Deb, u r the star. I learnt literally everything about Excel by binge watching your video… you show excel skills with tremendous clarity. I really learnt. Thank you so much.
Thanks for showing us how to use text join to get the tick at the end, that was so impressive, I am learning so much from you. Best teacher I have ever had !!!!!!!!
Excellent presentation by Deb Ashby. I appreciate how you speak slowly and show clearly all the steps necessary to perform the actions, plus the additional helpful hints. Thank you!
I signed up for a Power BI course and it's in 2 days. They mentioned only today that Pivot tables were a prerequisite so I absolutely loved this video. I literally clapped when you finished the dynamic chart. Before 2020 this would've been the most boring thing ever. Now I'm clapping at a dynamic pivot chart demo. Working from home solo joys can be found in the little things. :)
You reflect my sentiments exactly! I even clapped as well, after the surprise was thrust on me! A very well done presentation! ^5 and thank you to the creators for the nudge I needed!
Most fantastic tutorial I've seen in some time for teaching various advanced aspects of Excel...this tutorial has made my dealing with Excel so much more amazing.
When moving around the Ribbon you need to highlight it or simply slow down so one can follow without having to stop rewind, which often goes to far back and it becomes so frustrating. Otherwise it is very good I have learnt heaps, thank you.
Very amazing watching this video actually learn a lot on how to clean data, create pivot table, find and replacing abbreviations, fixing Upper case or printed lettered names.
Hey, thanks a bunch for watching and finding our video helpful! We really appreciate your support. 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Thank you so much for this video. Where can I find the alternative for textjoin when using concatenate and substitute? Can you please share the link from your blog?
So to make the Dynamic Chart label if you're using an older version of excel, you use the CONCATENATE formula instead of the TEXTJOIN? Are the steps the exact same as the TEXTJOIN?
I HAVE A PIVOT TABLE. IN THIS TABLE IN THE TOP ROW & COLUMN 1 IS THE DATE RANGE AND I WANT TO USE THIS DATE RANGE COMMAND WITH VBA USER FORM. WHEN IN USER FORM I CHANGE THE DATE AND CLICK ON SHOW IN USER FORM THEN PIVOT TABLE TOP ROW & COLUMN 1 IS THE DATE RANGE IS AUTOMATIC CHANGE AND UPDATE WITH DATE DATA. IF IS IT POSSIBLE ??? PLEASE RESPONSE ME. AND MAKE A VIDEO ON IT. THANKS (AMARENDRA KUMAR)
To get the Excel file used in this video and follow along, go here: www.simonsezit.com/article/advanced-pivottables-1-hour-course/
this link has no any excel file
Deb, u r the star. I learnt literally everything about Excel by binge watching your video… you show excel skills with tremendous clarity. I really learnt. Thank you so much.
Wow, thank you!
Thanks for showing us how to use text join to get the tick at the end, that was so impressive, I am learning so much from you. Best teacher I have ever had !!!!!!!!
God bless the team at Simon SezIT! This is the best resource I have ever stumbled upon on TH-cam. Excellent presentation!
Wow, thank you! We have a lot more content coming your way :-)
Incredible.
One falls short of adjectives,to explain your excellence in teaching.
Wow, thank you!
Excellent presentation by Deb Ashby. I appreciate how you speak slowly and show clearly all the steps necessary to perform the actions, plus the additional helpful hints. Thank you!
Glad it was helpful David!
Deb, dynamic titles - OMG. awesome.
I signed up for a Power BI course and it's in 2 days. They mentioned only today that Pivot tables were a prerequisite so I absolutely loved this video. I literally clapped when you finished the dynamic chart. Before 2020 this would've been the most boring thing ever. Now I'm clapping at a dynamic pivot chart demo. Working from home solo joys can be found in the little things. :)
Welcome to our world, lol!
You reflect my sentiments exactly! I even clapped as well, after the surprise was thrust on me! A very well done presentation!
^5 and thank you to the creators for the nudge I needed!
Most fantastic tutorial I've seen in some time for teaching various advanced aspects of Excel...this tutorial has made my dealing with Excel so much more amazing.
I have watched two videos on pivot tables by Deb Ashby and she is fab!!! Thank you so much.
Glad you like them! Please look out for more content coming soon. We well pass on your comments to Deb !
Thanks a lot, Simo Sez IT & Deborah Ashby ❤️
Our pleasure!
Thank you! It is the best advanced pivot tables tutorial I have seen.
Thank you Patrycja, I'm delighted you think so!
This is Great Tutorial about PIvot table with dynamic chart, love to use this in my Report! 2Big thumbs up to this channel!
Awesome, thank you!
Excellent training session. Thank you Debs & team
Thank you!
When moving around the Ribbon you need to highlight it or simply slow down so one can follow without having to stop rewind, which often goes to far back and it becomes so frustrating. Otherwise it is very good I have learnt heaps, thank you.
Very amazing watching this video actually learn a lot on how to clean data, create pivot table, find and replacing abbreviations, fixing Upper case or printed lettered names.
Thanks for visiting, John Baptist!
this was actually very helpful really thanks you very much good job
Hey, thanks a bunch for watching and finding our video helpful! We really appreciate your support.
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Was hoped i can find Advanced Tutorial after watching Basic Tutorial, posted year ago. Thank you!
Glad it was helpful Yaroslav!
Fantastic video. Thank you!
I’m pleased you’ve enjoyed watching!
Another incredible class
Great Tutorial, My EXCEL is improving already :)
That's great to hear!
Excellent presentation
Glad you liked it Noodin! :-)
excellent, well done Deb
thanks
Great tutorial in a very good and smooth way, thank you very much, really it was a very good.
Glad you enjoyed it Sami!
You guys have done a gr8 job really helpful tutorials. Please upload some tutorials on VBA and macros as well.
Really Great Tutorial..Thank You Deb :)
Glad you liked it!
Thanks for sharing !
My pleasure!
This is really a fantastic tutorial, concise and in-depth at the same time. Very good job!!
Glad you enjoyed it!
best explained tutorial
Thanks Nasir, greatly appreciated!
That's amazing! Thanks a lot!!!
You're welcome 😊 Glad you enjoyed it Inna!
Great Job!
Thanks!
Its really helpful... Thank you
You are welcome :-)
G
Great presentation
Many many thanks
Superb!
Thanks Rajendra🙂
Brilliant
Glad it was helpful, Derek Bradley!
Can you show different colours of countries in chart
Thank you so much for this video. Where can I find the alternative for textjoin when using concatenate and substitute?
Can you please share the link from your blog?
So to make the Dynamic Chart label if you're using an older version of excel, you use the CONCATENATE formula instead of the TEXTJOIN? Are the steps the exact same as the TEXTJOIN?
would love if you all made a blog post about this. I am using Excel 2013.
It's slightly different as the CONCATENATE function works in a different way. We'll put the blog post idea on our list, thanks!
@@SimonSezIT Thanks, I would love to see how it works. Great video tutorial by the way. Really learned a lot.
is there anyway of calculating the number of products listed on the list ?
thanks...
You're welcome!
I HAVE A PIVOT TABLE. IN THIS TABLE IN THE TOP ROW & COLUMN 1 IS THE DATE RANGE AND I WANT TO USE THIS DATE RANGE COMMAND WITH VBA USER FORM. WHEN IN USER FORM I CHANGE THE DATE AND CLICK ON SHOW IN USER FORM THEN PIVOT TABLE TOP ROW & COLUMN 1 IS THE DATE RANGE IS AUTOMATIC CHANGE AND UPDATE WITH DATE DATA. IF IS IT POSSIBLE ??? PLEASE RESPONSE ME. AND MAKE A VIDEO ON IT. THANKS (AMARENDRA KUMAR)
You are a beauty😘
how can i insert slicer on the tool bar?
The Pivot table, data sheet was very blurry and hard to view!
51:07 WATCH
00:00:01
A shame I only got excel online and seems that I'm very limited
Maybe this is a sign to check out the desktop version!