e). Excel 2007 provides full support for Microsoft SQL Server 2005 Analysis Services that has the flexibility and new cube functions to build a custom report from an online OLAP database and also connect to external data sources using Data Connection Library.

f). You can build professional looking charts using charting tools and apply visual enhancements such as 3-D, Soft shadowing, and transparency. The redesigned charting engine is consistent with all applications. Page Layout View helps in building a professional style to the spreadsheet and also allows you to incorporate Microsoft art and integrated graphics.

g). Excel services dramatically render an Office Excel 2007 spreadsheet as HTML that enable users to access spreadsheets from SharePoint Server 2007 that gives access to the most current data, and also to navigate, sort, filter, input parameters and interact with PivotTable views, all in any Web browser. The new Microsoft Office Excel XML format provides this efficient exchange of information by reducing their file size and improving interoperability with other data sources. The spreadsheet should be saved in XPS ( XML Paper Specification ) or PDF format for sharing.

h). Enables to track the key performance indicators of your business using browser-based dashboards that can be created from Office Excel 2007 spreadsheets, Excel Web Access, and Office SharePoint Server 2007 and use the Excel Services Web services application programming interface (API) to integrate server calculation of Office Excel 2007 files into other applications.