Get a free Microsoft Excel 2016 course here - https://simonsezit.lpages.co/free-exc... To follow along, you can download the Excel file here - https://www.simonsezit.com/article/le... In this Excel crash course, pivot table tutorial, excel aficionado Deb Ashby shows you: - How to prepare and clean your Excel data for your 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 2016 live class session 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://www.simonsezit.com/courses/mi...