Pivot tables are a powerful tool in Excel for summarizing, analyzing, and exploring large datasets. This guide will walk you through creating your first pivot table step by step to unlock insights from your data.
Ensure your data is organized in a tabular format with column headers. There should be no blank rows or columns within your dataset for the best results.
Click any single cell inside your dataset. Excel will automatically detect the entire data range. Alternatively, you can manually select the range you want to analyze.
Navigate to the Insert tab on the Excel ribbon and click the PivotTable button.
In the 'Create PivotTable' dialog box, confirm that the selected table/range is correct. Choose whether to place the pivot table in a New Worksheet (recommended) or an existing one, then click OK.
Use the PivotTable Fields pane that appears on the right. Drag and drop fields from the list into the four areas below: Filters, Columns, Rows, and Values to summarize your data.
Pro Tips for Using Pivot Tables
Pivot tables don't update automatically. If you change your source data, right-click the pivot table and select Refresh to see the changes.
By default, pivot tables sum numerical data. Right-click a value and go to Summarize Values By to choose other calculations like Count, Average, Max, or Min.
Right-click on a date or number field in the pivot table and select Group to organize data by months, years, or numerical ranges for clearer analysis.
Not sure where to start? Go to Insert > Recommended PivotTables. Excel will suggest several useful layouts based on your data.
Explore other Excel guides and shortcuts