Excel Crash Course – Learn Pivot Tables in 1 Hour
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
To download the exercise file used and follow along in Excel CLICK HERE
We also recommend you watch this class on Data Cleaning in Excel to help you with your Pivot Tables
Data Cleaning – https://www.simonsezit.com/article/excel-crash-course-data-cleaning-in-excel-in-1-hour/
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
