Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering

Filtering

ResolvedVersion 2007

Tue 29 Jul 2008, 16:43 Delegate Tosin said...

Tosin has attended:
Excel Intermediate course

Filtering

What's the difference between filtering mainly in a worksheet and a pivot table

Tue 5 Aug 2008, 17:59 Trainer Amanda said...

RE: Filtering

Hi Tosin

Thank you for your question and welcome to the forum.

When you filter data in a spreadsheet you can only see the data on a row-by-row basis, and you are not necessarily given any useful information from an analytical perspective if the rows contain some figures.

Constructing a pivot table allows you to view the same data in a 3D format, and analyse any figures in various ways.

We do cover pivot tables as part of our Excel Advanced course, also there are good resources on the Microsoft web site and on www.contextures.com relating to pivot tables if you are interested in learning more.

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Filtering

Filtering

RE: Filtering

Excel articles

Excel tip:

LARGE and SMALL functions and their uses