Open the spreadsheet you’d like to use to make a pivot table.

Highlight the data you want included in your pivot table. Be sure to include headings. You can also specify the range during the pivot table wizard.

Choose the source of the data you want to analyze. You have four options: Microsoft Office Excel list or Database, External Data Source, Multiple Consolidation Range or Another Pivot Table report. Normally, you will use the first option.

Choose Pivot Table in the section Type of Report to Create and choose Next.

Input the range or check to be sure the range you selected in Step 2 is still highlighted. Choose Next.

Choose where to store the pivot table. "New worksheet" creates a completely new worksheet within your workbook. "Existing worksheet" creates the pivot table on the worksheet of your choosing.

Change any layout or options you want. In Step 3 of the wizard, you can click the Layout or Options button to change the style of your pivot table and options such as the name and calculations.

Click Finish to create the pivot table.

Drag and drop the heading from the Pivot Table Field List window to the appropriate sections on the blank pivot table. You can remove the fields once you’ve placed them, so you can change as you go.

Right-click the fields on the pivot table to change and add calculations. You can also add and change options by using the pivot table toolbar that appears once a pivot table is created.

Customize the look of your pivot table and sort information as needed. Right-click to refresh data if your spreadsheet changes.