Get Four FREE Courses from Simon Sez IT https://www.simonsezit.com/four-free-courses/ To follow along with this how to use pivot tables class, you can download the Excel file here https://www.simonsezit.com/article/learn-pivot-tables/ In this pivot table tutorial in Excel, Microsoft aficionado Deb Ashby shows you: - How to prepare and clean your Excel data for a pivot table - How to use recommended PivotTables and create a pivot table from scratch - How to format, edit and display different results in a pivot table - How to create a chart from a pivot table using Pivot Charts - How to add a slicer to a pivot table and filter your data on the fly This was an Excel crash course delivered by Simon Sez IT. To attend future classes live, sign up to the Simon Sez IT newsletter (scroll to the bottom of the page!) - https://www.simonsezit.com/ For more Excel tutorials and Excel lessons, take a look at our Advanced Excel 2019 course https://bit.ly/2WgDp9a Or, some of our other training on YouTube: Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iMo-GQKwQs5Ccb2IPtlwzW Access for beginner tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3ha9zOSPu9gGqgOilSRCKyK Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gEx7_OYMI-PM_2ofCiVSq9 Visio 2016 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gyO23ivFmXp37MsEEbFf2n Word 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gLcSQaxPMW_vma_z3xiwF1 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 ;-) #simonsezit