Microsoft Office Excel 2007

Quick table formatting and a completely redesigned charting engine that will help you better communicate your analysis in stunning charts. View larger.

Use the Data Connection Library to import external information, and then explore this data with Office Excel 2007 View larger.

Office Excel 2007 helps you analyze information by improving PivotTable view creation and conditional formatting and providing full support for SQL Server 2005 Analysis Services. View larger.

With the new user interface, you can immediately view the most important cell-editing, formatting, and navigation tools. View larger.

Versatile Options For Optimum Results
Excel 2007 gives you the option of displaying a spreadsheet dynamically as HTML for easier online access, and Excel Services users can navigate, sort, filter, input parameters, and interact with PivotTable views--all within a Web browser. You can also publish business-critical spreadsheets to Office SharePoint Server 2007 and set controls over which users can view and modify spreadsheets on the server. If you want to build a custom report from an online analytical processing (OLAP) database, the Data Connection Library makes it a snap to connect to external sources of data.

Increased Spreadsheet Row and Column Capacity
Excel 2007 offers an increased spreadsheet row and column capacity of one million rows by 16,000 columns that enables you to import and work with massive amounts of data and achieve faster calculation performance with support for dual or multicore processors. Quickly format cells and tables exactly as you want them by using Cell Styles and Table Styles galleries. Tables also include AutoFilters while column headers stay in view when you scroll through the data, so you can keep better manage data. For added convenience, AutoFilters populate and expand any table automatically.

Formula Authoring Options
To help streamline the formula authoring process, Excel 2007 offers a resizable formula bar and context-based Formula AutoComplete. You can also refer to named ranges and tables within formulas and functions.

Office Excel 2007 and Excel Services provide the means to share and interact with spreadsheets in a Web browser. View larger.

Improved Spreadsheet Analysis
New data analysis and visualization tools help you analyze information, spot trends, and access your company information more easily. Use conditional formatting with rich data visualization schemes to discover and illustrate important trends, and highlight exceptions in your data with colored gradients (heat maps), data bars, and icons. When it comes to sorting and filtering, two of the most important types of basic analysis that you can do with data, Excel 2007 offers new tools, such as multiselect in AutoFilters, sort or filter by color, and quick filters for specific data types. You can also create a PivotTable or PivotChart view more easily by using data fields to reorient data quickly to summarize and find the answers you need--simply drag the fields to where you want them to display. Additionally, full support for Microsoft SQL Server 2005 Analysis Services enables you to query your most current business data.

New Excel XML Format
Reduce the file sizes of spreadsheets and improve their interoperability with other data sources by using the new Excel XML Format. This option enables a more efficient exchange of information and helps keep your business running smoothly.

Share Spreadsheets and Business Information
Excel 2007 makes sharing spreadsheets and business information easier than ever before, thanks to integration with Excel Services and the new Excel XML Format. Excel Services renders an Excel spreadsheet as HTML so others can access the information within a Web browser. Other options include creating business dashboards from spreadsheets to share within a portal, and tracking the key performance indicators of your business using browser-based dashboards that can be created from Excel spreadsheets, Excel Web Access, and Office SharePoint Server 2007. You can also enjoy the flexibility of saving files as XPS or PDF (with the installation of an add-in) for easier sharing.

Effectively Manage Sensitive Information
Excel 2007 and Excel Services enable you to manage and control spreadsheets on a server to help protect important business information and ensure that people are working with the most current data. Centrally manage sensitive information by publishing spreadsheets to SharePoint Server 2007. This both helps ensure that the members of your organization are working with the most current business information and prevents the spread of multiple versions of the same file. For added peace of mind, you can protect confidential business information while helping to ensure people can view the data they need with report management features. Using Office SharePoint Server 2007, your organization's IT staff can set up and manage Data Connection Libraries that enable people to more safely connect to external data sources without assistance. For added flexibility, you can also use the Excel Services Web services application programming interface (API) to integrate server calculation of Excel files into other applications.