A major function of any spreadsheet program is to help you derive meaning from your data. An Excel PivotTable is a great tool for getting perspective on, and analyzing relationships between the columns and rows of your worksheet.

In this lesson you will learn what a pivot table is, and how to create one. You will also learn how to specify and rearrange pivot table data. In the exercise, you will practice creating a pivot table.