How I can Publish Items to Excel Services, Sorting And Filtering, And Create Pivot Table View

Microsoft Excel Tips
40. How to Publish Items to Excel Services
41. How to use Sorting and Filtering
42. How to Create PivotTable View

40. Publishing Items to Excel Services
To publish your Microsoft Office Excel spreadsheets (or single items) to Microsoft Office SharePoint Server 2007:
1. With your spreadsheet open, click the Office button, and then click Publish.
2. Click Excel Services.
3. In the dialog box, select a trusted document library location in Office SharePoint Server 2007, and then click Excel Services Options.
4. Select whether you want to publish the entire spreadsheet, individual worksheets, or only selected items (such as charts, tables, or Microsoft PivotTable dynamic views). Click OK.
Your spreadsheet will be saved to the document library, and only your published items will be visible through the Web browser interface.

41. Sorting and Filtering
New options for sorting and filtering make Microsoft Office Excel 2007 the ideal tool for working with large amounts of complex data. The sorting and filtering menu is sensitive to the type of data you’re working with. To sort and filter:
1. To enable filter and sort options, do one of the following:
a. Format your data range as a table.
b. Select the headings of the columns that you want to sort or filter.
c. On the Ribbon, on the Home tab, in the Editing group, click Sort and Filter.

2. To sort, click the AutoFilter arrow in the column heading, and then select the filter mode (in Office Excel 2007, you can also filter by cell color).

3. To filter, click the AutoFilter arrow in the column heading.
a. Select individual values, and then select the filter mode.
b. Select Number Filters, Text Filters, or Date Filters for more advanced filter options.

42. Creating a PivotTable View
Microsoft PivotTable dynamic views help you change the axis that your data is organized around. To create a PivotTable view:
1. Click anywhere inside the range of data.
2. On the Ribbon, on the Insert tab, click PivotTable.
3. In the PivotTable Field List pane, check the fields that you want to visualize.
4. Rearrange your fields by dragging the row labels, column labels, and values to where you want them.
5. To add a filter, check the desired field, and drag it to the Report Filter box.

Microsoft Office Excel will display the sum of the data in the value field, but you can quickly modify the field to track other totals types, such as average, minimum value, or maximum value:
1. In the Values box, click the arrow next to the value that you want to modify.
2. Select Value Field Settings.
3. Change the setting from Sum to the desired type of calculation.