Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks. Bestselling author Greg Harvey includes information on customizing Excel's menus and toolbars; modifying Excel's editing settings; using add-ins, AutoCorrect, AutoFill, AutoFormat, and data validation; copying and moving data between worksheets; encrypting workbook files; creating external database queries; converting worksheet data and charts into Web pages; and much more.
* Written by Greg Harvey, one of the bestselling technology authors of all time, whose books have combined sales of more than four million copies
* A unique, two-column format makes it easy for readers to grasp and apply each technique-and begin working more efficiently
Few things are more disappointing to me as a software trainer than to see people who have just enough basic knowledge to work in a sophisticated program such as Excel waste inordinate amounts of time doing their work “the hard way” because they don’t really know how to go about harnessing the program’s features. This book is a vehicle for taking that next step into efficient use of Microsoft Excel, a program about which I have written a great deal and am naturally very partial. It is my sincere hope that it helps you become not only more competent in Excel but also much more confident in your ability to use rather than be used by it.