excel

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

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

Excel

resolvedResolved · Low Priority · Version 2003

Helen has attended:
Excel Intermediate course
Excel Advanced course

Excel

What is a pivot table?

RE: Excel

Hi Helen,

Thank you for your question.

A pivot table is used to analyse data from an excel list or an external source such as an Access database.

You assign a Page field (Main filter), row and column headings and where the two intersect you assign a data field.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips


Server loaded in 0.08 secs.