Excel 2003

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 spreadsheet.
• Analyze data better. Excel 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 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 spreadsheets and transfer them to Windows SharePoint Services sites for easier editing. You can edit the lists in Excel 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).
  

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 by using the new Research task pane. It brings electronic dictionaries, thesauruses, and online research sites into Excel to help you find information and incorporate information into your spreadsheets. Some functionality in the Research task pane requires a connection to the Internet.
• Find the help you need. From the Getting Started and Help task panes, you can access Microsoft Office Online Assistance on the Microsoft Office Online Web site. 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.
• 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.