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!** ►
https://www.simonsezit.com/four-free-courses
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
To get the Excel file used in this video and follow along, go here: https://www.simonsezit.com/article/advanced-pivottables-1-hour-course/
This is a recording of a live training session held for Simon Sez IT members: https://www.simonsezit.com/membership/
To see more, free Advanced Excel tutorials, take a look at this 4.5 hour YouTube course: https://youtu.be/gjfjn8Lwa28
Other, free Microsoft 2019 playlists from Simon Sez IT:
Microsoft Project 2019 course playlist: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jo_PtA6h6LNhvMbWNtJsXL
Microsoft Excel 2019 Beginners playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg
Microsoft Excel 2019 Advanced playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9
**GET FOUR FREE COURSES!** ►
https://www.simonsezit.com/four-free-courses
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a “thumbs up” and subscribe
to the channel 😉
