basic training excel - 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