Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Navigate Up
This page location is:
  • Faculty of Nursing CMU Web Portal.
    • BI Test
      • Pages
        • excelservicessample
Sign In
BI Test

BI Test

:

Help (new window)
  • BI TestCurrently selected
  • Dashboards
  • Data Connections
  • Libraries
    • doc
  • PerformancePoint Content
  •  All Site Content
BI Test > Pages > excelservicessample
 

Excel Web Access - Excel Services Sample Workbook

 
Microsoft Excel Web App
UndoRedo
File
  • HomeTab 1 of 2.
  • InsertTab 2 of 2.
Minimize the Ribbon
  • PastePaste
    Paste    CutCutCopyCopy    Clipboard
  • FontFont SizeBoldItalicUnderlineDouble UnderlineBorders Fill Color Font Color Font
  • Top AlignMiddle AlignBottom AlignAlign Text LeftCenterAlign Text RightWrap TextWrap
    Text    Alignment
  • Number FormatNumber
    Format Number Format    Increase DecimalDecrease Decimal    Number
  • Sort & Filter ​​ as TableSort & Filter
    as Table    Table OptionsTable
    Options Table Options    Tables
  • InsertInsert
    Insert    DeleteDelete
    Delete    Cells
  • DataData
    Data    FindFind    Data
  • Open in ExcelOpen in
    Excel    Office
File
Open in Excel
Open in Excel
Data
Data
Find
Find
View:
Formula Bar
Parameters
The following parameters are used in this workbook:
Progress
Loading...
 
 
  		 
 

Getting Started with Excel Services

 
Excel® Services in Microsoft® SharePoint® Server 2010 makes it simple to use, share, secure and manage your Microsoft® Excel® 2010 workbooks (.xlsx, .xslb).  Using the #1 end-user Business Intelligence tool, users can take their rich reports and models and publish them to the web to create dynamic dashboards, sharing their insights with the rest of the organization while maintaining a single version of the workbook.  Excel Services enables users to:
  • Share whole or parts of the workbook allowing others to interact with the underlying data (sort, filter, pivot, enter parameters)
  • Explore and analyze information, such as when connected to external data sources or stand alone in the workbook.
  • Perform what-if analysis and explore scenarios by entering values in the workbook that are calculated in real-time.
  • Connect to other Web Parts in SharePoint Server, such as Filter Web Parts or List View Web Part as part of a dashboard or from another Web Part Page.