How to create pivot tables in Excel 2007?

62
rate or flag this page

By BlaqBuddafly


This is the way to create it using Word 2003.

This one is relatively simple. Go into the data menu and select Pivot Table and Pivot Chart Report:

  • This will bring you to the Pivot Table Wizard. There it will ask you where the data is located (make your selection) and what type of report you want to create (a Pivot Table or Chart select pivot table).

Select Next:

  • It will now ask you where the data is that you want to use (you can select a range of data in the current workbook or you can use the browse button to select a different data sheet)

Select Next:

  • It asks where you want to put your Pivot Table in a new or exsisting worksheet (your choice based on how you want it to look. If you choose to place it in the current sheet you must select the cell range where you'd like it to be placed)

Select Finish:

  • Your Pivot Table will be created either within your current worksheet or in a new document. Here you will be able to edit the Pivot Table's format, data or create a Pivot Chart.

I hope this helps!!

Print   —   Rate it:  up  down  flag this hub

Comments

RSS for comments on this Hub

No comments yet.

Submit a Comment

Members and Guests

Sign in or sign up and post using a hubpages account.


optional


  • No HTML is allowed in comments, but URLs will be hyperlinked
  • Comments are not for promoting your hubs or other sites

working