Excel 2010: All Its Major Features and Tools


show more Modifying a PivotTable provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Modifying a PivotTable

In this workbook we have a simple PivotTable on Sheet 1 and if you want you can take a peek here down in the Data tab, so you can see the underlying data there, but let's go back here to Sheet 1. First thing we want to do in editing the PivotTable is let's change this sheet name to something useful. Instead of Sheet 1 you can double-click it. Maybe call it PivotTable or call it Summary. Something a little bit more useful and understandable. Now let's go and do some filtering, and you see up here we have these little down arrows for our column and row labels and report filters.

Let's start by filtering the months. Click this down arrow and right now you can see we have all three months showing, but maybe we just want to see January. Perhaps this is the beginning of the year and we want to see how sales are going just for this month, or perhaps data are not complete for the other months. Click OK and now you can see were filtered just by January. Maybe we want to see two mont...

Modifying a PivotTable
Video duration: 6m 57s 6h 21m Beginner

Viewers:

Modifying a PivotTable provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...