Learn Excel 2011 for Mac

Creating and Laying Out a PivotTable

You can create a PivotTable either from a database table or from a range of data. If you have a database table already, as in the example, you can create the PivotTable from that. Otherwise, create the database table you'll use, or enter the data in a worksheet as usual without creating a database table.

Once your data is ready, you can create a PivotTable either automatically or manually. Which works best depends on your data and what you're trying to do with it, but often you can save time by creating a PivotTable automatically and then adjusting it as necessary. If an automatic PivotTable turns out not to be what you need, you can create the PivotTable manually from scratch instead.

Creating a PivotTable ...