excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Leigh has attended:
Excel Intermediate course

Excel

What is a pivot table

RE: Excel

Hi Leigh,

Thank you for your post and welcome to the forum, I hope you enjoyed your course today.

In answer to your question: A pivot table is a summarisation of data which can be manipulated and viewed from different angles, if you have a large database and wish to summarise it; extracting either Totals, Averages, Highest or Lowest values etc, you could use a Pivot Table. To create a Pivot table follow the menu command Data, Pivot Table and Pivot Chart Report, follow the Wizard's commands/suggestions to arrive at a grid which then allows you to place your field headings in the appropriate places. Your Pivot table will then be created.

I hope that has helped, regards Pete


 

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips


Server loaded in 0.09 secs.