Quick table formatting and a completely redesigned charting engine that will help you better communicate your analysis in stunning charts.
Excel 2007 helps reduce the time and frustration of learning new software with menus and commands that present the right tools when you need them. The improved Help system provides tooltips and links to relevant information in Microsoft Office system programs or on the Internet when connected. Get started easily by using online tutorials with step-by-step instructions or by using some of the new out-of-the-box templates. Keep your documents and sensitive information safe and secure by detecting and remove unwanted comments, hidden text, or personally identifiable information in your documents using the Document Inspector.
Use the Data Connection Library to import external information, and then explore this data with Office Excel 2007
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.
With the new user interface, you can immediately view the most important cell-editing, formatting, and navigation tools.
Powerful Productivity Tools
Excel 2007's new, results-oriented user interface to make powerful productivity tools easily accessible. It also offers more room for you to work in and delivers faster performance. Based on the job you need to accomplish, whether it is creating a table or writing a formula, Excel 2007 presents the appropriate commands to you within the new user interface.
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.
Excel 2007 helps you create professional-looking charts with dramatic visual effects in just a few clicks, quick table formatting and a completely redesigned charting engine that will help you better communicate your analysis. By using predefined Chart Layouts and Chart Styles, or manually formatting each component, (such as axes, titles, and other chart labels), you'll save time and increase productivity. And to make sure your charts really stand out, take advantage of stunning effects such as 3-D, soft shadowing, and anti-aliasing to help identify key data trends and create more compelling graphical summaries. Page Layout View lets you see exactly how your spreadsheet will print and direct visual feedback where the page will truncate gives you the help you need to properly adjust page margins. For seamless interaction between different software applications, the Excel charting engine is consistent in the 2007 versions of Word and PowerPoint.
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.