Optimizing business information with Office Excel 2007.
a). Excel 2007 delivers a new, results-oriented interface, PivotTable and Pivot Chart views that are easy to create, enhanced formula authoring with Formula Auto Complete feature, rich data visualization and a much faster way to create charts and tables.
b). Enables user to Import, Organize and explore massive data sets within significantly expanded spreadsheets, each containing 1 million rows by 16000 columns
c). Tables can be created, formatted, expanded and referred within formulaes. Table headings are kept in view when scrolling data over large tables.
d). Visualization schemes enables to discover patterns and highlight trends with gradients, thresholds, and performance indicator icons. Conditional formatting can be applied more easily.
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.
Data Connection Library