Mr Excel on Excel Book

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.

About the Author:
Bill Jelen is the principal of the MrExcel.com, a leading Excel website. He provides custom Excel and Access applications for hundreds of clients and is the author of Guerilla Data Analysis Using Microsoft Excel. He lives in Akron, Ohio. Joseph Rubin is a certified public accountant and an independent consultant specializing in the development of applications using Microsoft Excel for the financial industry. He has served as a CFO, controller, and has run a private CPA practice.