Microsoft Office Excel Home and Student 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.

Create Better Spreadsheets
Excel 2007 takes advantage of a 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, Office Excel 2007 presents the appropriate commands to you in a clear cut manner.

The Tools You Need For the Results You Want
Excel 2007 gives you the option of displaying a spreadsheet dynamically as HTML for easier online access, and Excel Services Users can also navigate, sort, filter, input parameters, and interact with PivotTable views--all within a Web browser. You can also publish spreadsheets to Office SharePoint Server 2007 and set controls over which users can view and modify spreadsheets on the server. Need to share research data? Build a custom report from an online analytical processing (OLAP) database and connect to external sources of data more easily using the Data Connection Library.

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.

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

Professional-Looking Charts
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 2007.

Improve 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 by using the flexibility of Excel 2007.

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
Excel 2007 makes sharing spreadsheets and information easier than ever before, thanks to integration with Excel Services and the new Microsoft Office Excel XML Format. Excel Services renders an Excel spreadsheet as HTML so others can access the information within a Web browser. This option is particularly ideal for study groups or computer-integrated courses where students work together to complete assignments. You can also enjoy the flexibility of saving files as XPS or PDF for easier sharing with the installation of an add-in.

Effectively Manage Sensitive Information
Excel 2007 and Excel Services enable you to manage and control spreadsheets on a server to help protect important personal information. Publish spreadsheets to Office SharePoint Server 2007 to help ensure that you, and everyone in your study group, are working with the most current information. This also helps prevent the spread of multiple versions of the same file. For added peace of mind, you can protect confidential academic information while helping to ensure people can view the data they need with report management features.