Rob has attended:
Excel Advanced course
Pivot Table
How do you create a pivot table to cover a wide range of data variences and then be able to tailor it to change with the company's changing reporting requirements?
RE: Pivot Table
Hi Rob,
Thanks for using the forum,
Pivot tables allow you to look at data in several dimensions; for example, sales by region, sales by sales rep, sales by product. You can link the chart to the data sheet so any changes on the sheet will update the chart. You can also tailor it to show/hide a variety of different aspects of the original spreadsheet. Dragging and dropping different items or fields into the different areas.
To create a Pivot table:
Select a cell in the target table
Click Data / Pivot table and Pivot chart report
Follow the steps in the Wizard
Hope this helps
Tracy