GCFLearnFree.org

This has really aided my job search and created ample opportunities.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2007
  • Creating Pivot Tables

Excel 2007

Single page view print copy

Creating Pivot Tables

PivotTable reports

Watch the video! (10:41 min)

Download the example to work along with the video.

Why are they named PivotTables?

You may be wondering why it is called a PivotTable. Basically, PivotTables allow you to pivot, or move, data so you can produce answers to questions. Once you create a PivotTable, you can very easily see what effect pivoting the data has on the spreadsheet information.

To create a PivotTable report (Part I):

  • Select the cells in your spreadsheet that you want to use in the PivotTable report.
  • Select the Insert tab.
  • Click the PivotTable command.
  • Click PivotTable again. Excel selects cells in the actual spreadsheet, and the Create PivotTable dialog box opens.
    • Select a table or range is already selected, and the Table/Range field shows the range of the selected data. New Worksheet is also selected by default as the place where the report will be placed.
Pivot Table Dialog Box

 

  • Click Existing Worksheet, then select a worksheet if you do not want the PivotTable to appear in a new worksheet.
  • Click OK.
previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.