Excel 2003 enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel 2003 can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes.
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.
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).
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.
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.
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.