Mr. Excel on Excel Excel 97, Excel 2000, Excel 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 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 that calculate loan payments, writing a program, and VBA techniques.Jelen, Bill is the author of 'Mr. Excel on Excel Excel 97, Excel 2000, Excel 2002' with ISBN 9780972425834 and ISBN 0972425837.