Microsoft Excel 2003

Most of the major improvements in Microsoft Excel 2003 involve workgroup functions, but there are a few enhancements that may tempt individual users to upgrade.

The key new Excel enhancement—XML, IRM (information rights management), and SharePoint aside—is its new List feature. This addresses some of the problems traditionally associated with lists—including the fact that the SUM function didn’t work as you might expect on filtered lists. Once you’ve created an Excel 2003 list by clicking on Data | List | Create List, it’s surrounded with a blue border showing clearly where it begins and ends. The last row in the list contains a single asterisk, much as you’d see in an Access table. Entering data in any cell in that row (within the list) inserts a new row in the list.

Every column has the AutoFilter enabled by default, which lets you quickly filter and sort the list. Totaling a column is as easy as clicking the Toggle Total Row button on the new List toolbar and choosing one of a range of functions for each column, such as Sum, Count, Average, Max, or Min. Excel lists can be published to a SharePoint site, keeping the local and server copies in sync if required.

Best online Microsoft MCTS Training, Microsoft MCITP Training at certkingdom.com


There is a new Compare Worksheets feature, which you use by opening two workbooks and then choosing the Compare Side by Side option from the Window menu. Excel stacks the sheets vertically and, like Word, synchronizes them so moving around in one worksheet scrolls the other, letting you compare their contents easily.

A range of statistical functions—VAR, STDEV, STDEVP, DVAR, FORECAST, SLOPE, INTERCEPT, PEARSON, RSQ, STEYX, and others—have been fixed by changing how they are calculated, to reduce the likelihood they will return incorrect answers. In earlier versions, these functions were known to fail, because of the rounding required where large numbers were involved.

Other changes include a new Date Smart Tag, which lets you schedule a meeting or display your Outlook Calendar. And a new Person Name Smart Tag lets you get data from an Outlook contact you’ve recently e-mailed. As with Word, Excel users can remove personal data from a workbook before saving it— although the option is disabled by default. To enable it, choose Tools | Options | Security.