Excel Services, part of Office SharePoint Server 2007, extends the capabilities of Microsoft Office Excel 2007 by allowing broad sharing of spreadsheets, improved manageability and security, and the ability to reuse spreadsheet models by using a scalable, server-based calculation service and interactive Web-based user interface. With Excel Services, you can:

• Broaden the access and availability of spreadsheets by incorporating interactive spreadsheets into Business Intelligence portals, dashboards, and scorecards.

   

• Secure and protect confidential information and maintain one version of the truth by locking down access at the server.

   

• Reduce development costs, and improve time to market by using Web services to access models and data contained in spreadsheets.

   

• Use Data Connection Libraries to provide an easy way for your users to share, manage, and discover connections to external data repositories without requiring any knowledge of the technical details.

   

Quickly share Office Excel 2007 worksheets by saving them to SharePoint document libraries directly from Office Excel 2007.

Office Excel 2007 spreadsheet displayed using Excel Services.

• Manage reports, spreadsheets, and data connections consistently by using the new Report Center—an out-of-the-box site template and document library optimized for report access and management including a report library, data connection library, and a Business Intelligence dashboard template.

• Communicate goals and status to drive results using the new Web part without writing code. The KPI Web part can display KPIs from Microsoft SQL Server 2005 Analysis Services, Office Excel 2007 spreadsheets, SharePoint lists, or manually entered data.

   

• Easily access the business information you need by creating dynamic, personalized dashboards using integrated filter Web parts. Filters allow dashboards to be personalized by communicating shared parameters among Web parts on a dashboard. The filter Web parts present more relevant information to the user.

Personalized dashboard displayed in a Report Center including the Excel Web Parts.

 KEY:

= Feature Included    

= Improved in Office SharePoint Server 2007    

= New in Office SharePoint Server 2007

Features

SharePoint Portal Server 2003

Office SharePoint Server 2007 Enterprise CAL

Integrated, Flexible Spreadsheet Publishing
Office Excel 2007 provides an integrated publishing experience that lets information workers easily choose what they want to share with others and determine how others can interact with published spreadsheets.

Share, Manage, and Control Spreadsheets
Share business data broadly while maintaining control and helping to protect sensitive information. Provide access to spreadsheet data and analysis through server-calculated, interactive Office Excel spreadsheets from a Web browser. Use these spreadsheets to maintain and efficiently share one centralized version of the truth while helping to protect any sensitive or proprietary information embedded in documents, such as financial models, by limiting access to portions of the spreadsheet and auditing their usage.

Web-Based Business Intelligence Using Excel Services
Excel Services empowers spreadsheet authors to easily and broadly share spreadsheets that use the new Business Intelligence functionality through the browser. Fully interactive, data-bound spreadsheets including charts, tables, and PivotTable views can be created as part of a portal, dashboard, or business scorecard, without requiring any development.

Data Connection Libraries
Data Connection Libraries are centralized SharePoint document libraries that store Office Data Connections (ODC); ODCs describe connections to external data. Centralizing Office Data Connections makes it easier to share, manage, and discover data connections that can be used by any Microsoft Office program.

Business Data Catalog
The Business Data Catalog (BDC) tightly integrates external data into the Office SharePoint Server 2007 user experience, providing access to external data residing in back-end line-of-business applications, and enabling the display of and interaction with external data through a set of business data Web parts.

Business Data Web Parts
Use SharePoint business data Web parts to view lists, entities, and related information retrieved through the Business Data Catalog.

Business Data Actions
With no custom coding, easily create actions that open Web pages, display the user interfaces of line-of-business applications, launch InfoPath forms, and perform other common tasks. Use the convenient links that appear beside business objects returned from the Business Data Catalog.

Integrated Business Intelligence Dashboards
Create rich, interactive Business Intelligence dashboards that assemble and display business information from disparate sources by using built-in Web parts such as dynamic KPIs, Excel spreadsheets, Microsoft SQL Server Reporting Services reports, or a collection of business data connectivity Web parts that can visualize information that resides in back-end line-of-business applications.

Report Center
Use an out-of-the-box site that is optimized for report access and management, including a report library, data connection library, and a dashboard template. These sites, hosted by the new Report Center, provide consistent management of reports, spreadsheets, and data connections.

Key Performance Indicators
KPIs communicate goals and status to drive results. Using the KPI Web part, a user can create a KPI list with a Web part page, without writing code. The KPI Web part can display KPIs from Microsoft SQL Server Analysis Services, Excel spreadsheets, SharePoint lists, or manually entered data.

Filter Web Parts
Filters enable dashboards to be personalized by communicating shared parameters among Web parts on a dashboard. The parameters passed can be automatically applied based on user profiles, SharePoint lists, the BDC, manually entered information, and more.