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

pivot tables

ResolvedVersion 2003

Sini has attended:
Excel Intermediate course

Pivot tables

what is a pivot table best used for?

RE: pivot tables

Hi Sini,

Thank you for your question.

A pivot Table is used for analysing data. The Pivot Table uses row headings and column headings and where the two meet or intersect you choose a data field to display.

I hope this answers your question.

Regards

Simon

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.