Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

basic training excel - pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic training excel - Pivot Table

basic training excel - Pivot Table

ResolvedVersion Standard

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.