How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool

Select the data in your table or list as a cell range in the worksheet.

When selecting the data in your table, don’t forget to include the column headings.