In this example, we've selected cell A1 on Sheet2.
Highlight the cell where you'd like to create the pivot table. In this example, the data is found on Sheet1.
To create a pivot table in Excel 2016, you will need to do the following steps:īefore we get started, we first want to show you the data for the pivot table.
If you want to follow along with this tutorial, download the example spreadsheet.ĭownload Example Steps to Create a Pivot Table
