Advanced Pivot Tables in Excel: 1-hour Excel Pivot Tables Tutorial

[@SimonSezIT]

To get the Excel file used in this video and follow along, go here: www.simonsezit.com/article/advanced-pivottables-1-hour-course/

[@ethiobet-3543]

this link has no any excel file

[@timtao1493]

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.

[@SimonSezIT]

Wow, thank you!

[@zlee11]

Deb, dynamic titles - OMG. awesome.

[@flashflair]

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

[@SimonSezIT]

Welcome to our world, lol!

[@theresaryan4778]

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!

[@olusolam.babalola7268]

God bless the team at Simon SezIT! This is the best resource I have ever stumbled upon on KZbin. Excellent presentation!

[@SimonSezIT]

Wow, thank you! We have a lot more content coming your way :-)

[@ronniewest5652]

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

[@davidshapiro486]

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!

[@SimonSezIT]

Glad it was helpful David!

[@avr9747]

Incredible. One falls short of adjectives,to explain your excellence in teaching.

[@SimonSezIT]

Wow, thank you!

[@donreymo760]

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.

[@TusharPatel-ke3kb]

I have watched two videos on pivot tables by Deb Ashby and she is fab!!! Thank you so much.

[@SimonSezIT]

Glad you like them! Please look out for more content coming soon. We well pass on your comments to Deb !

[@ahammadgalib5810]

Thanks a lot, Simo Sez IT & Deborah Ashby ❤️

[@SimonSezIT]

Our pleasure!

[@Ayuk1]

Excellent training session. Thank you Debs & team

[@SimonSezIT]

Thank you!

[@patrycjagren9255]

Thank you! It is the best advanced pivot tables tutorial I have seen.

[@SimonSezIT]

Thank you Patrycja, I'm delighted you think so!

[@sparetacusmotovlog5360]

This is Great Tutorial about PIvot table with dynamic chart, love to use this in my Report! 2Big thumbs up to this channel!

[@SimonSezIT]

Awesome, thank you!

[@mohamedgado1238]

this was actually very helpful really thanks you very much good job

[@SimonSezIT]

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 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@MyRockMyFortress]

Fantastic video. Thank you!

[@SimonSezIT]

I’m pleased you’ve enjoyed watching!

[@jamesdep8128]

Another incredible class

[@magloiremiantuadi5725]

Great Tutorial, My EXCEL is improving already :)

[@SimonSezIT]

That's great to hear!

[@noordinwamala245]

Excellent presentation

[@SimonSezIT]

Glad you liked it Noodin! :-)

[@felisiandasi8441]

excellent, well done Deb thanks

[@johnbaptistabakarabushaka2365]

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.

[@SimonSezIT]

Thanks for visiting, John Baptist!

[@yaroslav2889]

Was hoped i can find Advanced Tutorial after watching Basic Tutorial, posted year ago. Thank you!

[@SimonSezIT]

Glad it was helpful Yaroslav!

[@samiayasa8821]

Great tutorial in a very good and smooth way, thank you very much, really it was a very good.

[@SimonSezIT]

Glad you enjoyed it Sami!

[@darrylmorgan]

Really Great Tutorial..Thank You Deb :)

[@SimonSezIT]

Glad you liked it!

[@chowa3686]

Thanks for sharing !

[@SimonSezIT]

My pleasure!

[@NasirAli-zi9hn]

best explained tutorial

[@SimonSezIT]

Thanks Nasir, greatly appreciated!

[@andreashermle2716]

This is really a fantastic tutorial, concise and in-depth at the same time. Very good job!!

[@SimonSezIT]

Glad you enjoyed it!

[@inna6141]

That's amazing! Thanks a lot!!!

[@SimonSezIT]

You're welcome 😊 Glad you enjoyed it Inna!

[@leenabhavsar2272]

Its really helpful... Thank you

[@SimonSezIT]

You are welcome :-)

[@aditisethi1364]

You guys have done a gr8 job really helpful tutorials. Please upload some tutorials on VBA and macros as well.

[@KeithGarnett-l6b]

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.

[@hzetzer]

Great Job!

[@SimonSezIT]

Thanks!

[@clavendern]

G Great presentation

[@SimonSezIT]

Many many thanks

[@rksudera]

Superb!

[@SimonSezIT]

Thanks Rajendra🙂

[@aixhwxrya]

51:07 WATCH

[@shahtajp4379]

Can you show different colours of countries in chart

[@zillionz]

Brilliant

[@SimonSezIT]

Glad it was helpful, Derek Bradley!

[@brand1974]

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?

[@brand1974]

would love if you all made a blog post about this. I am using Excel 2013.

[@SimonSezIT]

It's slightly different as the CONCATENATE function works in a different way. We'll put the blog post idea on our list, thanks!

[@brand1974]

@@SimonSezIT Thanks, I would love to see how it works. Great video tutorial by the way. Really learned a lot.

[@carloscova7131]

is there anyway of calculating the number of products listed on the list ?

[@kobi1974]

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?

[@hosseinhosseinpoor4845]

thanks...

[@SimonSezIT]

You're welcome!

[@ΕΛΕΝΗΚΑΡΑΣΙΜΟΥ-τ5μ]

how can i insert slicer on the tool bar?

[@anujdairyhajipur5229]

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)

[@tanweerabbasabbas649]

You are a beauty😘

[@akilmerji8209]

00:00:01

[@mako0845]

The Pivot table, data sheet was very blurry and hard to view!

[@tonytaf107]

A shame I only got excel online and seems that I'm very limited

[@SimonSezIT]

Maybe this is a sign to check out the desktop version!