Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Portal Interno DEPR
Sign In

DOE

:

Help (new window)

Top Link Bar

  • DOECurrently selected

Quick Launch

  • Dashboards
  • Data Connections
  • Libraries
  • PerformancePoint Content
DOE > Pages > excelservicessample
 

Excel Web Access - Excel Services Sample Workbook

 
 
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
Share
Share
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.