Author Topic: Pivot Tables - Excel  (Read 1390 times)

mc55

  • Hectare
  • *****
  • Posts: 1,199
  • Bernard at the cinema ! (Sheffield, S Yorks)
Pivot Tables - Excel
« on: May 16, 2007, 17:30:30 »
I have a large table of data that I want to analyse - stuff like gender, age, length of service, location etc and I'm thinking of setting up a pivot table in excel - you know, table & graphs showing how many females under 40 in the USA etc out of a total population, that type of stuff.

Does anyone have experience of this sort of thing ? 

I'm limited package wise to word, excel and powerpoint

glow777

  • Hectare
  • *****
  • Posts: 971
  • up in the hills in Buxton
Re: Pivot Tables - Excel
« Reply #1 on: June 14, 2007, 07:44:18 »
sorry just read this

although I dont use exel much you'll probably not find a better application for analysing data in pivot tables. They take a bit to get your head around but are easy to use once mastered. Lots of online help

eg
http://www.homeandlearn.co.uk/ME/mes9p4.html
http://www.cpearson.com/excel/pivots.htm

etc ots on google

 

SimplePortal 2.3.5 © 2008-2012, SimplePortal