Q. I’m a heavy user of Excel and I’ve been debating whether to upgrade to the 2002 (XP) version. What are your thoughts?
A. If you were a
casual user of Excel, I’d say don’t bother. But if you’re indeed
an advanced user, I suggest it’s worth the investment. Here are
some of the new features in Excel 2002 that you’ll find very
handy.
The bar displays a very useful collection of tools. Placing a cursor on an icon brings up the tool’s name: Error Checking, Trace Precedents, Remove Precedent Arrows, Trace Dependents, Remove Dependent Arrows, Remove All Arrows, Trace Error, Add Comment, Circle Invalid Data, Clear Validation Circles, Show Watch Window, Evaluate Formula. The new powerful ones include:
To quickly jump to a watched cell, double-click on its entry in the Watch Window.
When you click on the Evaluate button, the dialog displays and evaluates each segment of the formula.
|