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

excel

ResolvedVersion 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:

Use the Ctrl-key for quick navigation in Excel 2010

If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.