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

Рет қаралды 112,800

4 жыл бұрын

✅ Download the free course exercise files to follow along
➡️ www.simonsezit.com/article/ad...
In this 1-hour class, we take you through some Advanced Pivot Tables in Excel tips and tricks.
The PivotTable is one of the most popular, and powerful functions Excel offers. In this advanced session, we take a look at how to get the most from this super function. We start with a quick recap on how to create a pivot table before moving onto some of a pivot tables advanced features.
Once again, this Excel Pivot Tables advanced tutorial was hosted by the excellent Deborah Ashby for Simon Sez IT.
🔥GET FOUR FREE COURSES! ➡️ www.simonsezit.com/four-free-...
In this Advanced PivotTables class we look at:
- A quick PivotTables recap
- Formatting values and customer pivot table styles
- Sorting and filtering pivot data
- Creating and formatting Pivot Charts
- Summarize values and show values as
- How to create a dynamic Pivot Chart label
- Working with slicers
- Wording with calculated fields
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 81

@SimonSezIT 4 жыл бұрын

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

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

Deb, dynamic titles - OMG. awesome.

@olusolam.babalola7268 4 ай бұрын

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

@SimonSezIT 4 ай бұрын

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

@donreymo760 2 жыл бұрын

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.

@avr9747 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

Wow, thank you!

@davidshapiro486 3 жыл бұрын

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

Glad it was helpful David!

@flashflair 3 жыл бұрын

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

Welcome to our world, lol!

@theresaryan1960 2 жыл бұрын

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!

@ahammadgalib5810 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

Our pleasure!

@TusharPatel-ke3kb 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

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

@Ayuk1 3 жыл бұрын

Excellent training session. Thank you Debs & team

@SimonSezIT 2 жыл бұрын

Thank you!

@patrycjagren9255 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

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

@jamesdep8128 2 жыл бұрын

Another incredible class

@felisiandasi8441 2 жыл бұрын

excellent, well done Deb thanks

@qww760 3 жыл бұрын

Fantastic video. Thank you!

@SimonSezIT 3 жыл бұрын

I’m pleased you’ve enjoyed watching!

@darrylmorgan 4 жыл бұрын

Really Great Tutorial..Thank You Deb :)

@SimonSezIT 4 жыл бұрын

Glad you liked it!

@magloiremiantuadi5725 4 жыл бұрын

Great Tutorial, My EXCEL is improving already :)

@SimonSezIT 4 жыл бұрын

That's great to hear!

@sparetacusmotovlog5360 2 жыл бұрын

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

@SimonSezIT 2 жыл бұрын

Awesome, thank you!

@aditisethi1364 2 жыл бұрын

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

@yaroslav2889 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

Glad it was helpful Yaroslav!

@mohamedgado1238 8 ай бұрын

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

@SimonSezIT 8 ай бұрын

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

@samiayasa8821 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

Glad you enjoyed it Sami!

@chowa3686 3 жыл бұрын

Thanks for sharing !

@SimonSezIT 3 жыл бұрын

My pleasure!

@inna6141 3 жыл бұрын

That's amazing! Thanks a lot!!!

@SimonSezIT 3 жыл бұрын

You're welcome 😊 Glad you enjoyed it Inna!

@johnbaptistabakarabushaka2365 2 жыл бұрын

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

Thanks for visiting, John Baptist!

@noordinwamala245 2 жыл бұрын

Excellent presentation

@SimonSezIT 2 жыл бұрын

Glad you liked it Noodin! :-)

@leenabhavsar2272 4 жыл бұрын

Its really helpful... Thank you

@SimonSezIT 4 жыл бұрын

You are welcome :-)

@hzetzer 3 жыл бұрын

Great Job!

@SimonSezIT 3 жыл бұрын

Thanks!

@rksudera 3 жыл бұрын

Superb!

@SimonSezIT 3 жыл бұрын

Thanks Rajendra🙂

@NasirAli-zi9hn 2 жыл бұрын

best explained tutorial

@SimonSezIT 2 жыл бұрын

Thanks Nasir, greatly appreciated!

@clavendern 2 жыл бұрын

G Great presentation

@SimonSezIT 2 жыл бұрын

Many many thanks

@user-tr4ws1gk2d Жыл бұрын

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.

@zillionz 2 жыл бұрын

Brilliant

@SimonSezIT 2 жыл бұрын

Glad it was helpful, Derek Bradley!

@andreashermle2716 3 жыл бұрын

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

@SimonSezIT 3 жыл бұрын

Glad you enjoyed it!

@hosseinhosseinpoor4845 3 жыл бұрын

thanks...

@SimonSezIT 3 жыл бұрын

You're welcome!

@kobi1974 3 жыл бұрын

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?

@tanweerabbasabbas649 11 ай бұрын

You are a beauty😘

@shahtajp4379 8 ай бұрын

Can you show different colours of countries in chart

@aixhwxrya Ай бұрын

51:07 WATCH

@carloscova7131 3 жыл бұрын

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

@brand1974 4 жыл бұрын

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

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

@SimonSezIT 4 жыл бұрын

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

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

@user-fu3qy5np6e 3 жыл бұрын

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)