Pivot Tables

Hi Sandy

Thank you for your question - the process to create a pivot table is very fast in 2007. Click within your table of data then from the Insert Ribbon choose Pivot Table. From the dialogue box that appears make sure the range of cells highlighted by Excel is correct then click OK.

Excel creates a tab with a pivot table based on your data. Use the grid on the right side of your sheet to drag your data fields into the Row/Column/Value areas to analyse your data.

I hope this helps - do let me know if you have any further questions.

Kind regards,
Andrew