How to create a pivot table in excel 2010

How do you create a pivot table in Excel 2010?

Click the PivotTable button in the Tables group on the Insert tab. Click the top portion of the button; if you click the arrow, click PivotTable in the drop-down menu. Excel opens the Create PivotTable dialog box and selects all the table data, as indicated by a marquee around the cell range.

Does Excel 2010 have pivot table?

To create a pivot table in Excel 2010, you will need to do the following steps: A Create PivotTable window should appear. Select the range of data for the pivot table and click on the OK button. In this example, we’ve chosen cells A1 to D13 in Sheet1 as indicated by Sheet1!$

How do I find pivot table tools in Excel 2010?

On the Ribbon, under the PivotTable Tools tab, click the Analyze tab (in Excel 2010, click the Options tab). In the Data group, click the top section of the Change Data Source command. The Change PivotTable Data Source dialog box opens, and you can see the the source table or range in the Table/Range box.

Why is column not appearing in pivot table?

Method #1: Show the Pivot Table Field List with the Right-click Menu. Probably the fastest way to get it back is to use the right-click menu. Right-click any cell in the pivot table and select Show Field List from the menu. This will make the field list visible again and restore it’s normal behavior.

Why is field not showing up in pivot table?

Click any cell in the pivot table layout. The PivotTable Field List pane should appear at the right of the Excel window, when a pivot cell is selected. If the PivotTable Field List pane does not appear click the Analyze tab on the Excel Ribbon, and then click the Field List command.

Where did my pivot table field list go?

Why is pivot table not working?

The pivot table error, “field name is not valid”, usually appears because one or more of the heading cells in the source data is blank. To create a pivot table, you need a heading for each column. Check for hidden columns in the source data range, and add headings if they’re missing.

How do I show a pivot table?

On the Options or Analyze tab (depending on the Excel version you are using) on the ribbon, in the PivotTable group, click Options. In the PivotTable Options dialog box, click the Data tab. Under PivotTable Data, clear or select the Enable show details check box to disable or enable this option.

What is pivoting in Excel?

A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.

How do you show actual value in pivot table?

Show different calculations in PivotTable value fields
  1. To add two or more of the same value fields to the PivotTable so that you can display different calculations in addition to the actual value of a specific field, do the following:
  2. In the PivotTable, right-click the value field, and then click Show Values As.
  3. Click the calculation option that you want to use.