pivot table

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 Table

Pivot Table

resolvedResolved · Low Priority · Version 2003

Nina has attended:
Excel Introduction course
Excel Intermediate course

Pivot Table

What is the main function of the pivot table?

RE: Pivot Table

Hi Nina,

Thank you for your question.

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

You create a Pivot table by assigning a Page field, row headings and column headings. Where the rows and columns meet or intersect, you assign a data field such as salary information.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips


Server loaded in 0.09 secs.