Now, its time to use your table to generate a pivot table (or several) so that you can analyze and see patterns in your data. To do so, head to Insert > PivotTable and select From Table/Range.

What you'll want to ensure you do is that when you create a new PivotTable, you create it in a new worksheet, so it's separated from the main table. The cool thing about this is you can then clone ...