How to Make a Pivot Table in Excel 2007

By Techwalla Computers Editor

Microsoft Excel makes computations and data organization easier. Ease of use and efficiency are hallmarks of this software. One utility that exemplifies this are pivot tables. Pivot tables make the use and the display of copious amounts of data a snap. Read on to learn how to make a pivot table in Excel 2007.

Step 1

Open the Microsoft Excel spreadsheet program. Click "Start" on the main operating system menu. Then choose "Programs" and from the program menu select "Microsoft Excel."

Step 2

Choose a cell in a Microsoft Excel spreadsheet. Make certain the call range has a column heading. From the main tab menu, select the "Insert" tab, then in the table menu click on "Pivot Table."

Step 3

Select the data range to be analyzed. A user can either select a range of data in the current spreadsheet or choose data from an external source. Also, determine if the pivot will appear in the current worksheet or in a new worksheet.

Step 4

Create the pivot table in Microsoft Excel. With the correct data source selected and each of the columns has a heading, click "OK." The pivot table will appear either on a new or existing worksheet. Now check the data columns to display in the pivot table.

Step 5

Make sure the data in the pivot table displays correctly. Sometimes the pivot table will have formatting issue if the original table had labeling or data problems. Check the drag field boxes if there are errors in appearance or formatting. Experiment with the pivot table data by dragging the data into different fields until the pivot table display is correct.