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
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