pivot tables

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

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

Pivot Tables

resolvedResolved · Medium Priority · Version 2007

Ann has attended:
Excel Intermediate course

Pivot Tables

What are they?

RE: Pivot Tables

Hello Ann

Thank you for your question and welcome to the forum.

A pivot table is used to display data normally stored in columns (i.e. an Excel list or database), in a table or matrix format. It makes the data more flexible as it can be displayed in multiple ways.

For a bit of further information on pivot tables, please see
http://peltiertech.com/Excel/Pivots/pivottables.htm

Kind regards
Amanda

Tue 24 Feb 2009: Automatically marked as resolved.


 

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips


Server loaded in 0.09 secs.