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

Valerie has attended:
Excel Intermediate course
Excel Advanced course

Excel

What is a pivot table?

RE: Excel

Hi Valerie

Thanks for your question

A pivot table allows you to manipulate data stored in a list form by cross referencing data in different columns.

For example, if you have a table containing information about sales, with columns for salesperson, customer and value; you could create a pivot table that listed salesperson name as column headings, cutomers as row headings and total sales by particular sales persons to particular customers as values

Hope this is useful

Regards

Stephen


 

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips


Server loaded in 0.08 secs.