1. Industry
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:


was emailed to:

Thanks for sharing About.com with others!

You can opt-out at any time. Please refer to our privacy policy for contact information.

How to Configure Excel 2010 Pivot Table for Business Intelligence


2 of 15

Insert Pivot Table
Photo © Microsoft

Position your cursor exactly where you want your pivot table and click on Insert | Pivot Table.

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.
Related Video
Create Excel Pivot Tables
  1. About.com
  2. Industry
  3. New Tech
  4. Training and Job Resources
  5. Tech Training
  6. Microsoft Excel 2010 - How to Configure Excel 2010 Pivot Table for Business Intelligence

©2014 About.com. All rights reserved.