• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

New! Features > Microsoft Office Excel 2003

Microsoft Office Excel 2003

Microsoft Office Excel 2003 is the spreadsheet program that gives you support for XML and new features that make it easier to analyze and share information.

  • Compare workbooks side by side Comparing workbooks side by side allows you to see the differences between two workbooks more easily, without having to constantly switch back and forth between windows. You can scroll through both workbooks at the same time to identify differences between the two workbooks.

  • Person Names Smart Tag menu Quickly locate contact information such as a person's phone number and complete tasks such as scheduling a meeting using the Person Names Smart Tag menu. The menu is available in Excel wherever a person's name appears.

  • Enhanced statistical functions Use enhanced statistical functions, including enhancements to rounding results and precision, in your workbooks:

    BINOMDIST, CHIINV, CONFIDENCE, CRITBINOM, DSTDEV, DSTDEVP, DVAR, DVARP, FINV, FORECAST, GAMMAINV, GROWTH, HYPGEOMDIST, INTERCEPT, LINEST, LOGEST, LOGINV, LOGNORMDIST, NEGBINOMDIST, NORMDIST, NORMINV, NORMSDIST, NORMSINV, PEARSON, POISSON, RAND,, RSQ, SLOPE, STDEV, STDEVA, STDEVP, STDEVPA, STEYX, TINV, TREND, VAR, VARA, VARP, VARPA, and ZTEST.

  • Research task pane The new Research task pane offers a wide variety of reference information and expanded resources if you have an Internet connection. You can conduct research on topics using an encyclopedia, Web search, or by accessing third-party content.

  • Enhanced list functionality Create lists in your worksheet to group and manage related data. You can create a list on existing data or create a list from an empty range. A new user interface and a corresponding set of functionality are exposed for ranges that are designated as a list. Every column in a list has AutoFilter enabled by default in the header row which allows you to quickly filter or sort your data. A dark blue list border clearly outlines the range of cells that compose your list. A row in the list frame that contains an asterisk is called the insert row. Typing information in this row automatically adds data to the list. A total row can be added to your list. When you click on a cell within the total row, you can pick from a drop-down list of aggregate functions. The size of a list can be modified by dragging the resize handle found on the bottom right corner of the list border.

  • List integration with Windows SharePoint Services Share the information contained within an Excel list by using Windows SharePoint Services. You can create a Windows SharePoint Services list based on your Excel list on a Windows SharePoint Services site by publishing the list. If you choose to link the list to the Windows SharePoint Services site, any changes you make to the list in Excel will be updated on the Windows SharePoint Services site when you synchronize the list.

  • Information Rights Management Create or view content with restricted permission using Information Rights Management (IRM). IRM allows individual authors to specify permission for who can access and use workbooks or e-mail messages, and helps prevent sensitive information from being printed, forwarded, or copied by unauthorized people.

  • XML support Organize and work with workbooks and data in ways that were previously impossible or very difficult. By using your XML schemas, you can now identify and extract specific pieces of business data from ordinary business documents. You can also attach a custom XML schema to any workbook by using the XML Source task pane to map cells to elements of the schema. Once you have mapped the XML elements to your worksheet, you can import and export XML data into and out of the mapped cells.

  • Support for ink devices, such as the Tablet PC Quickly provide input by adding your own handwriting to Office documents on a Tablet PC as you would using a pen and a printout. Additionally, view task panes horizontally to help you do your work on the Tablet PC.

  • Document Workspaces Create a Document Workspace to simplify the process of co-writing, editing, and reviewing workbooks with others in real time. A Document Workspace site is a Windows SharePoint Services site that is centered around one or more documents and is typically created when you use e-mail to send a workbook as a shared attachment.

  • Smart documents Smart documents are programmed to extend the functionality of your workbook by dynamically responding to the context of your actions. Several types of workbooks, especially workbooks that are used as part of a process such as forms and templates, work well as smart documents. Smart documents can help you reuse existing content and can make it easier to share information.They can even interact with other Office programs such as Microsoft Office Outlook, all without leaving the workbook or starting Outlook.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint