Alternatively, on the Ribbons Tables tab, go to the Tools group and click Summarize with PivotTable.

If you didnt start with a table or range, you can select a data range or table using the mouse.

The cell will be the upper-leftmost corner of your PivotTable.

Make sure theres enough room so your PivotTable doesnt overlap existing cell ranges.

Theres a little information button at the right end of each field name in the panels at the bottom of the PivotTable Builder.

The properties displayed are for the field name of the button you clicked.

You can choose from Normal, Difference From, Of, Difference From, Running Total In, of Row, of Column, of Total, or Index.

PivotTable Ribbon offers additional formatting options and still more controls for your PivotTable, but it goes beyond the scope of this book.

If you find PivotTables to be useful, then by all means explore the PivotTable Ribbon.

Pivot Tables Excel Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Pivot Tables Excel For Mac