log inhelp

 | 

  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Whenever you search in PBworks or on the Web, Dokkio Sidebar (from the makers of PBworks) will run the same search in your Drive, Dropbox, OneDrive, Gmail, Slack, and browsed web pages. Now you can find what you're looking for wherever it lives. Try Dokkio Sidebar for free.

View
 

pivot table how to

Page history last edited by Diane Evans 12 years, 2 months ago

EXCEL PIVOT TABLE

 

Step 1

Start Excel and open the workbook file where you want to create the pivot table.

Step 2

Format your data as straight lists of values. For example, you might have month, type of product, salesperson, or income.

Step 3

Select the data you want in the pivot table.

Step 4

Open the Data menu and select Pivot Table and Pivot Chart Report.

Step 5

Click the radio button in the first section for "Microsoft Excel list."

Step 6

Decide if you want just a table for your data, or if you also want charts. Then Click Next.

Step 7

Verify that the range of cells you selected is listed in the Range field.

Step 8

Click Next.

Step 9

Decide whether you want the pivot table in a new or existing worksheet, then click Finish.

 

 

 

PivotReport and PivotTable are tools to summarise large amounts of data. See the example below:


 

 

 

 

AAW/dee/pivot table how to/3/13/11 1

Comments (0)

You don't have permission to comment on this page.

Printable version