You can insert a Pivot Table in a new or existing Excel workbook. You might want to consider positioning your cursor down a few rows from the top. This will give you space for a header or company information in case you share the worksheet or print it out.
- Open a new or existing Excel 2010 workbook and click on the cell where you want the top left corner of the Pivot Table to be.
- Click on the Insert tab and click on the PivotTable drop down in the Tables section. Choose PivotTable. This will launch the Create PivotTable dialog form.