Excel 97 Annoyances

The idea is the same as WORD Annoyances--to provide VBA workarounds to tailor operation to your own tastes. However, not nearly as many workarounds are provided as in the WORD Annoyances book. Also, large sections are copied verbatim. For example, the introductory VBA examples are the same as WORD Annoyances, although there are a few EXCEL specific VBA programs as well. The discussion of worksheet auditing (tracking down mistakes in entries) and organization of worksheets inside a workbook is better than most.

This book is useful in describing many odds and ends of using EXCEL. This book is not an overall introduction, like Running Microsoft EXCEL 97, nor a series of examples, like EXCEL for Scientists and Engineers. Rather, it is a helpful handholder to assist you in setting up the program and operating it to suit yourself. Like its companion volume, WORD 97 Annoyances, the theme of the book is to put VBA to use in customizing the program to your own tastes. However, the main love of the authors is WORD, and there are fewer VBA fixes in this book than in the WORD 97 book. There also are large scale repetitions of whole sections of the WORD book in this book.Nonetheless there are a number of useful examples of using VBA in EXCEL, of setting up menus and rearranging toolbars etc. There also are some good points about spreadsheet organization, checking for spreadsheet errors, and precautions to be taken against crashes, viruses, and misuse of macros.

In 1995 I read a book entitled "The Underground Guide to Excel 5.0" by Lee Hudspeth and T.J. Lee. I read it from cover to cover. Since then I have been searching for more from these guy and I finally found it in "Excel 97 Annoyances." Unlike most computer books, which are rehashes of the user manual, "Excel 97 Annoyances" has "soul." It is a funny, irreverent, critical look at Excel. This is a unique book, full of useful tips and techniques. Read it and you'll have more fun learning about Excel than you ever could have imagined.