Excellentable User Guide Pivot Tables Creating a Pivot Table Creating a Pivot Table Step 1 Select the Data you wish to turn into a Pivot Table Step 2 Go to Insert > Pivot Table Step 3 Select whether you want to open the Pivot Table in your current Sheet, or a new Sheet Step 4 Move your Pivot Table fields to your desired Filters, Columns, Rows, and Values Step 5 After adding the fields, your Pivot Table will be created ×