How to Format Data for a PivotTable in Excel 2010


show more Formatting data for use in a PivotTable 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 ...

Formatting data for use in a PivotTable

PivotTables enable you to summarize and reorganize your data dynamically. But you can't summarize just any data set. In most cases, your data needs to be laid out as a data list. So then the question becomes what do I mean by a data list? In this case, a data list is something that you might think of as a table. with distinct columns of data and each one of those columns having a header. In this data list my column headers are Year, Quarter, Month, Company, and Revenue. And then within the list, we have a series of rows, each of which contains a value for each of those headers.

In the first row for example, we have the Year 2009, Quarter 1, Month of January, the Company is FirmA, and then we have the Revenue for that Month. To be able to use the data inside of a PivotTable we need to make sure there are no blank rows. So if I scroll down in this list, you'll see that from A1 to E49 that there are no blank rows. It's okay to have blank cells. That'll just be included in th...

Formatting data for use in a PivotTable
Video duration: 4m 31s 3h 43m Intermediate

Viewers:

Formatting data for use in a PivotTable 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 ...