pivot table

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table

Pivot Table

resolvedResolved · Low Priority · Version Standard

Lars has attended:
Excel Advanced course

Pivot Table

what are they?

RE: Pivot Table

Hi Lars

Thank you for your question

A pivot table is a powerful tool for analysing database style information in multiple dimensions.

First the data must be in the form of a list, with column headings and no row headings. It is then possible to use a pivot table to analyse relationships between the different data items

For example if you have a database with the following column headings

SalesPerson
Customer
Date
Sale Value
Customer Type

You could use a pivot table to show how much was sold by each sales person, to each customer on a monthly basis.

Hope this helps

Regards

Stephen


 

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.08 secs.