J Jason Woolsey Mar 13, 2009 #1 What are the point of Pivot Tables? I was asked about it at work, and I have no idea what they are and how useful they are?
What are the point of Pivot Tables? I was asked about it at work, and I have no idea what they are and how useful they are?
A Alan Mar 13, 2009 #2 Very useful, you could have a look here to make a start, http://www.ozgrid.com/Excel/excel-pivot-tables.htm Regards, Alan.
Very useful, you could have a look here to make a start, http://www.ozgrid.com/Excel/excel-pivot-tables.htm Regards, Alan.
R Roger Govier Mar 13, 2009 #3 Hi Jason They are the hidden gem in Excel. A fantastically easy way of analysing all sorts of data. For more help take a look at http://www.datapigtechnologies.com/ExcelMain.htm and http://www.edferrero.com/Excel Tutorials/PivotTableTutorial2003/tabbed/89/Default.aspx and http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/tiptech.html scroll to section on pivot tables
Hi Jason They are the hidden gem in Excel. A fantastically easy way of analysing all sorts of data. For more help take a look at http://www.datapigtechnologies.com/ExcelMain.htm and http://www.edferrero.com/Excel Tutorials/PivotTableTutorial2003/tabbed/89/Default.aspx and http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/tiptech.html scroll to section on pivot tables