How To Pivot A Pivottable Report In Excel For Mac


show more Pivoting a PivotTable report provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Pivoting a PivotTable report

The real power of a PivotTable comes out when you want to rearrange your data dynamically. A task that would take several minutes, at least, if done by hand, takes just a few seconds when you want to summarize your data in a PivotTable. In a PivotTable, the row and column headers provide the basic structure. So, for example, here in the PivotTable, you'll see that I have my company, FirmA and FirmB, my two companies, and then I also have my months, January through December. When you look over in the PivotTable Builder, you'll see that that structure is reflected here.

So, for example, I have the Company field, which provides the values here: FirmA and FirmB, have the Month, providing the values for the Row Labels, and then we have the Values, which is sum of Revenue here in the middle. Changing the position of the row and column headers in a PivotTable Builder changes their organization within the PivotTable. So let's say, for example, that I wanted to arrange my data first ...

Pivoting a PivotTable report
Video duration: 3m 18s 6h 32m Beginner

Viewers:

Pivoting a PivotTable report provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...