List functionality
|
Create lists in your worksheet to group and act upon related data, manage and analyze data, or share list data with others through integration with Microsoft Windows SharePoint Services.
|
Organizing Data
|
Performing Calculations on Filtered Data
|
Improved statistical functions
|
Aspects of many statistical functions, including rounding results, and precision have been enhanced.
|
Performing Calculations on Data
|
Creating Formulas to Calculate Values
|
XML support
|
Industry-standard XML support streamlines the process of accessing and capturing information between PCs and back-end systems, unlocking information, and allowing for the creation of integrated business solutions across the organization and between business partners.
|
Publishing on the Web and Using XML
|
Converting an Excel Workbook to XML
|
XML support
|
Industry-standard XML support streamlines the process of accessing and capturing information between PCs and back-end systems, unlocking information, and allowing for the creation of integrated business solutions across the organization and between business partners.
|
Publishing on the Web and Using XML
|
Using XML Data Capabilities and Retrieving Web Data
|
Smart documents
|
Smart documents are documents that are programmed to extend the functionality of your workbook by dynamically responding to the context of your actions. Several types of workbooks, such as forms and templates, work well as smart documents. Smart documents work especially well for workbooks that are part of a process.
|
Publishing on the Web and Using XML
|
Using XML Data Capabilities and Retrieving Web Data
|
Compare workbooks side by side
|
See the differences between two workbooks more easily, without having to merge all changes into one workbook, by using the Compare Side by Side feature. You can scroll through both workbooks at the same time to identify differences between the two workbooks.
|
Collaborating in Excel
|
Sharing and Comparing Workbooks
|
Document Workspaces
|
Use Document Workspaces to simplify the process of co-authoring, editing, and reviewing documents with others in real-time. A Document Workspace site is a Microsoft Windows SharePoint Services site that is centered around one or more documents.
|
Collaborating in Excel
|
Sharing and Comparing Workbooks
|
Information Rights Management
|
Microsoft Office 2003 offers a new feature, Information Rights Management (IRM), which helps you prevent sensitive information from getting into the hands of the wrong people, whether by accident or carelessness.
|
Collaborating in Excel
|
Protecting Workbooks and Worksheets
|