Creating a PivotTable report


show more Creating a PivotTable report provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Creating a PivotTable report

Pivot Tables are powerful and flexible Excel analysis tools. A Pivot Table lets you rearrange, sort and filter a dataset on the fly, so you can analyze it from several different perspectives with a minimum of effort. In this lesson, I will show you how to create a Pivot Table from a data list that's stored in the same workbook. To create a Pivot Table, click any cell in the data list from which you want to create the Pivot Table and then on the Data menu, click PivotTable Report to display the PivotTable Wizard. In this case, the currently selected option that I want to create the Pivot Table from an Excel list or database is correct, so I can click Next.

The next Wizard screen identifies the data that Excel thinks that I want to include in the Pivot Table. In this case, that is the range from A1 to E49, which I know is correct, so I can click next. On the last page of the PivotTable Wizard, you can choose whether to put the Pivot Table on a new sheet or on an existing sheet. I prefer to...

Creating a PivotTable report
Video duration: 2m 31s 1h 7m Intermediate

Viewers:

Creating a PivotTable report provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

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