How Do You Create a Pivot Table in Excel?

To create a PivotTable in Excel 2010, click Insert at the top of the worksheet, and select the PivotTable icon on the left. To properly generate a PivotTable, you must first organize your data and then design the layout.

  1. Organize the data set

    Organize your data into columns with headings, and make sure there are no empty rows or columns. This layout is required to create a PivotTable in Excel 2010. After organizing your worksheet, click on any cell within the set, and proceed to insert the PivotTable. Excel then automatically determines your table's range, although you can alter it by entering a different cell range. After affirming the range, choose whether you want your table to appear on a new or existing worksheet, and click OK.

  2. Drag fields

    After clicking OK, Excel creates an empty PivotTable report in your specified location. Organize your PivotTable through the field list on the right. Select a field by clicking Check Box, and either drag or right-click the selection into the desired layout field. Adjust the results so that the data is presented in a clear and concise manner. To change how the data is calculated or presented, click the drop-down menus within the value field.

  3. Apply finishing touches

    After organizing your pivot table, click the Design and Options tabs under the PivotTable Tools menu. Explore the options provided under each tab. Select the table’s headings to apply filters for sorting purposes or to rename the fields. Continue to make adjustments until your data is presented in the desired manner.