ABSTRACT

This chapter describes the more useful modifications and additions to the latest versions of Excel. There are now several versions current in the different issues of Microsoft Office: Office 97, Office 2000, Office ME and Office XP, plus Macintosh versions 1998, 2001 and 10.0, and the following facilities are not found in all versions. Some facilities are just re-arrangements of menu items, but others are significant and useful additions. The on-screen Help Menu Microsoft Excel Help is a valuable facility which is well worth exploring. Several new toolbars are now available as standard, of which the Pivot Table, Visual Basic and Web are possibly the most useful. Multiple-level category labels when the category data on your worksheet is hierarchical, Excel automatically maintains this hierarchy in one's chart by including each level in the category axis labels. The Euro convert function will convert pounds sterling to Euros and vice versa.