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

✅ Download the free course exercise files to follow along

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.

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

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[timtao]

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.

[olusolam.babalola]

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

[donreymo]

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.

[davidshapiro]

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!

[ronniewest]

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

[avr]

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

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

[TusharPatel-kekb]

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

[Ayuk]

Excellent training session. Thank you Debs & team

[patrycjagren]

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

[johnbaptistabakarabushaka]

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.

[ahammadgalib]

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

[samiayasa]

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

[darrylmorgan]

Really Great Tutorial..Thank You Deb :)

[aditisethi]

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

[magloiremiantuadi]

Great Tutorial, My EXCEL is improving already :)

[mohamedgado]

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

[yaroslav]

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

[kobi]

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?

[sparetacusmotovlog]

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