Mr Excel ON EXCEL: Excel 97, 2000, 2002

Designed for accounting and other business professionals, this guide to Microsoft Excel provides information on this feature-rich product that will make users more proficient. Described in detail are the techniques that were introduced since the switch from Lotus to Excel took place in the 1990s. Tips designed to make Excel use more efficient include how to prevent duplicate data entry, deleting unwanted links, importing and refreshing data from the Internet, and adding a running balance column to a pivot table. Other advanced techniques include combining the Vlookup function with a combo box to extract data, comparing lists without using formulas, and adding comments to formulas. Also included are instructions on features such as formulas that calculate loan payments, writing a program, and VBA techniques.