Creating a pivot table
Most people have used a pivot table at some point in their work lives to summarize large amounts of data quickly and easily. As a quick example, I have launched Microsoft Excel and opened the PowerQuery.xlsx
file, which can be downloaded from GitHub:
As you can see, we have a table with some sales data that includes salespeople from different regions and the products that they have sold. Let's use this data to make a pivot table:
- Select/highlight the entire table. After highlighting the table, click on the Insert tab on the ribbon, and then click on Pivot Table.
Tip
You can also highlight the table after you have clicked on Pivot Table. Just click on the arrow button at the end of the Table/Range field and click on it again after your selection is complete.
- The range is automatically filled in for you. Here, you can choose to have this on a new worksheet or use the existing...