A PivotTable is an interactive table that makes it simple to summarize and analyze large amounts of data in different ways. Watch this series of videos to learn how.
After completing this video, you'll be able to:
Prepare sheet data so that Excel
can create a PivotTable.
automatically create a PivotTable for you.
Find and use the PivotTable Builder and other PivotTable tools.
Change how the PivotTable summarizes your data.
Format and update the PivotTable.
Excel for Mac 2011
skills, including how to open a workbook, and select cells, columns, and rows.
Video lessons are designed to be viewed in order. Download and use this practice file for hands-on experience while watching the video.
PivotTables.xlsx (50 K)
If you liked this training, you might want to try the following: