How to use Analyze Data in Excel Now that you know a bit about the feature, let’s put it to work. Select the entire Table and then click Analyze Data.

To create the PivotTable, click somewhere in the list of data, choose the Insert tab, and click PivotTable. Excel will automatically select the area containing the data, including the headings.