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

excel

ResolvedVersion 2003

Hari has attended:
Excel Intermediate course
Excel Advanced course

Excel

What is a pivot table?

RE: Excel

Hi Hari,
Thank you for your question;
In answer--- though I can see you will be finding out on the 19th December when you attend the Excel Advanced Course...
A Pivot table is simply a table of data which is created from a larger table and displays a summarisation of the fields.
The Pivot name comes from the ability to view the summarisation from different dimensions, by moving fields and pivoting the data to allow you to view different perspectives in the way the data is displayed and calculated. I hope that has helped ...Pete

Mon 15 Dec 2008: Automatically marked as resolved.

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

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.12 secs.