pivot table

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

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

Pivot Table

resolvedResolved · Low Priority · Version 2003

Valine has attended:
Excel Introduction course

Pivot Table

what are the advantages of a pivot table

RE: Pivot Table

Go to data, then pivot table and chart and follow the wizard. You must have your data already on the sheet first. If for example you have a sheet of sales data and each row has a country to show where the sale happened, you can put it into a pivot table to give a group summary on sales per country. It will show all country data, or you can pick a particular country and it will automatically give you a sum of the sales value or the number of sales depending on the otpion you set.


 

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips


Server loaded in 0.09 secs.