What is a pivot table on Microsoft Excell and how does it work?

Answer 1

Here are a couple of links that may help you:

http://office.microsoft.com/en-us/assistance/HA010346321033.aspx

http://www.lacher.com/toc/tutpiv.htm

Answer 2

your create your spread sheet as normal with the headings along the top and the first column, hit pivot table, you are presented with options and one option will show all your headings avaliable click and drag the ones you want to include and the data is sorted by your choices on a new sheet within the file, the pivot does not update if you change the original spread sheet

Answer 3

I just started working in the statistics department of a bank and this was one of the questions on my interview!

It flips a chart round so the columns become rows and the rows columns.. so if you had:

.........Dave....John
Age...1..........2
Sex...M.........M

A pivot table can be made to change it into:

...........Age....Sex
Dave..1.........M
John...2.........M

They're pretty useful if you've got one set of data in rows and another in columns and you want to compare them.

Try reading the excel help file and creating one. It makes the most sense when you actually make one.

Hope that helps,
froggie

Answer 4

An example is that over a period of few years you can do financial transactions say house building .1.financier's .supply of loan to be cleared and payment to them through as per interest rates .Pyment to builder for house building and lastly monthly payments to the financier overr say 10 or 15 or 20 years payments to him

Answer 5

its a way of organising a lot of data in a spreadsheet into a readable and edittable format....use help to take things further.

At work I don't know what I would do without it

Answer 6

use help for enlightenment.