If youre PivotTable aficionado, you will be in seventh heaven with the new PivotTable capabilities in Office 2011 for Mac.

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.

Click the information button to display the PivotTable Field dialog.

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 Table Builder In New 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 Table Builder In New Excel For Mac