Capture and Reuse Data
Bring key business data into your spreadsheets for more timely access to the information you need to make good decisions.

• Take advantage of data wherever it exists. Excel 2003 can read data in any customer-defined XML schema without reformatting. You can analyze and manipulate XML data sources using charts, tables, or graphs.

Note: In all Office 2003 Editions, Excel 2003 spreadsheets can be saved in a native XML file format which can be manipulated and searched using any program that can process industry standard XML. With Microsoft Office Professional Edition 2003, companies can also use customized XML formats—or schemas—to enable easier and more advanced information creation, capture, exchange, and reuse.

• Develop your own data solutions. Experienced Excel users can use the new visual XML mapping tool to map a user-specified XML schema to fields in an Excel 2003 spreadsheet.

• Analyze data better. Excel 2003 builds on its commitment to reliable and accurate numerical analysis with enhancements in collinearity detection, calculations of sum of squared deviations, normal distributions, and continuous probability distribution functions.

• Customize functionality with enhanced smart tags. Smart tags in Excel 2003 are more flexible. Associate smart tag actions with a specific section of a spreadsheet and have the smart tag appear only when you hover the mouse over the associated range of cells.

• Interact with business systems. Developers can build document-based solutions that take advantage of the XML support in Excel 2003. For example, they can program task panes to display relevant tasks and information to help automate business processes.

Share Information with Confidence
Work together effectively—internally and with other organizations—and help protect against the misuse of sensitive company information.

• Work together better. Save Excel 2003 spreadsheets to shared workspaces where other team members can get the latest version and save task lists, related files, links, and member lists. Shared workspaces require Microsoft Windows Server™ 2003 running Microsoft Windows® SharePoint™ Services.

• Edit lists in Windows SharePoint Services. Integration with Windows SharePoint Services allows you to compose lists in Excel 2003 spreadsheets and transfer them to Windows SharePoint Services sites for easier editing. You can edit the lists in Excel 2003 or on the Windows SharePoint Services site.

• Control distribution of your work. Help protect company assets by preventing recipients from forwarding, copying, or printing important spreadsheets using information rights management (IRM) functionality. You can grant others permission to view, review, or modify your spreadsheet, and you can set an expiration date, after which others cannot view or change it. IRM functionality requires Windows Server 2003 running Microsoft Windows Rights Management Services (RMS).

Note: With Office Professional Edition 2003, you can use Excel 2003 to create IRM-protected spreadsheets and grant others permission to access and modify your spreadsheets. You can also apply policy templates to IRM-protected spreadsheets you create. With Microsoft Office Standard Edition 2003, Microsoft Office Small Business Edition 2003, and Microsoft Office Student and Teacher Edition 2003 you can read IRM-protected spreadsheets; with permission, you can modify them as well.

Increase Productivity
Be mobile and access information that can help you create the best spreadsheets possible.

• Stay focused on your work. Find facts easily without leaving Excel 2003 by using the new Research task pane. It brings electronic dictionaries, thesauri, and online research sites into Excel 2003 to help you find information and incorporate information into your spreadsheets. Some functionality in the Research task pane requires a connection to the Internet. Learn more about how to do research and reference in Office 2003 Editions.

• Find the help you need. From the Getting Started and Help task panes, you can access Assistance on Microsoft Office Online. It provides help and assistance articles that are updated regularly from requests and issues of other users. Some functionality in these task panes requires a connection to the Internet. Learn more about using Office Online.

• Go mobile. If you own and use a Tablet PC, you can use digital ink markup to annotate Excel 2003 spreadsheets in your own handwriting using a pen input device. You can take notes or send comments to others.