excel pivot tables

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 / Pivot tables

Excel / Pivot tables

resolvedResolved · Low Priority · Version 2007

Fenian has attended:
Excel Introduction course
Excel Intermediate course

Excel / Pivot tables

what are pivot tables used for?

RE: Excel / Pivot tables

Hi Fenian,

Thank your for your post, welcome to the forum;

In answer to your question, a Pivot Table is an interactive worksheet table that can summarise large amounts of data using the views and permutations that you choose. It is called a Pivot Table because you can rotate its row and column headings around the core data to give you different views of the source data. As the source data changes you can update the pivot table, a pivot table can be used as a source for a pivot chart.

regards Pete


 

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.