Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Low Priority · Version 2003

Reply Fri 27 Jun 2008, 15:50Delegate Chris said...

Chris has attended:
Excel Intermediate course

Excel

what is a pivot table?

For upcoming training course dates see: Pricing & availability

Reply Mon 30 Jun 2008, 16:35Trainer Stephen said...

RE: excel

Hi Chris

Thank you for your question

A pivot table takes data in the form of a simple lists and allows cross referencing of the data in the various columns.

For example if you had a stock list, with columns for (among other things) product name, product colour and items in stock; you could create a pivot table with colours as column headings, product names as row headings and total of each in stock as data items.

Regards

Stephen

Excel articles

· How To Split A Stacked Chart In Excel
· Tell AutoFill What To Do And It Will Oblige
· How to Create Better Excel Spreadsheets: Part One
· How To Manage Your Everyday Spending In Excel
· What Is A Sparkline And How Do They Work?

Please browse our web site to find out more about
excel+courses and other Microsoft training courses.

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips