Microsoft Office Tutorials and References
In Depth Information
Interacting with Excel Services Workbook
The Excel workbook that is published on SharePoint retains many of the interactive data-exploration capabilities
of Excel. The user does not need to have Excel 2013 installed on her machine to interact with the workbook on the
browser. Let’s check out some of these features by following these steps:
1.
Navigate to the SharePoint document library, and open the Excel workbook.
2.
Click on the expand option (plus sign) on the “Bikes” from row number 4. You will see the
list of items under “Bikes”. You can collapse it back using the same button (minus sign).
3.
Click on the “Reseller” option from the Sales Channel slicer and “Northeast” from the Region
slicer. You will notice the table and chart getting filtered based on the slicer selection.
4.
Click on any one of the Sales Amount values from the table to bring up the Field List on
the right side. From the Field List, you can drag and drop fields into the Rows, Columns,
Values, and Filter sections.
5.
Right-click on the Sales Amount value for Bikes and FY 2006. Then click on the “Quick
Explore” option from the context menu to drill down to other dimensions (Figure 5-40 ).
More details on this feature can be found at http://office.microsoft.com/en-us/
excel-help/drill-into-pivottable-data-HA102840029.aspx .
Figure 5-40. Show the new features of Excel 2013, Quick Explore and Field list options on the browser
6.
Click on the drop-down button next to the Row Labels or Column Labels to perform basic
filtering and sorting of the table data.
 
Search JabSto ::




Custom Search