Managing table columns


show more Managing table columns provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Managing table columns

After you bring your data into PowerPivot you can manage the data within both the PowerPivot datasheet and also within your PivotTables. In this movie I will show you how to work with PowerPivot columns of data. So to display the data that I have in this worksheet, I will click the PowerPivot tab and then open the PowerPivot window by clicking the PowerPivot Window button in the Launch section of this tab on the Ribbon, and when I do my data appears in PowerPivot, and to indicate how much data we're working with, at the bottom left corner you can see that we are currently looking at Row 1 of 964,260.

In PowerPivot as in Excel you can manipulate the columns inside of the PowerPivot window. So let's say for example that you want to hide a particular column and in this case we will just say that we want to hide the Product column, to do that you can right-click the column header and then click Hide Columns and then select whether you want to hide the column from the PowerPivot win...

Managing table columns
Video duration: 4m 1s 3h 43m Intermediate

Viewers:

Managing table columns provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

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