Excel 97 Annoyances

By Woody Leonhard, Lee Hudspeth, T.J. Lee
January 1900
Pages: 336
ISBN 10: 1-56592-309-X | ISBN 13: 9781565923096
(Average of 0 Customer Reviews)

This book is OUT OF PRINT.

Description

This book uncovers Excel 97's hard-to-find features and tells how to eliminate the annoyances of data analysis. It shows how to easily retrieve data from the Web, details step-by-step construction of a perfect toolbar, includes tips for working around the most annoying gotchas of auditing, and shows how to use VBA to control Excel in powerful ways.
Full Description

First, the good news: Microsoft Excel is a very powerful and popular spreadsheet program that has been around for quite some time. And this newest version, which ships with Office 97, is very robust and contains some great new features, including a 32,000 character limit per cell, support for the new IntelliMouse (which provides for better spreadsheet navigation), and reliable pivot tables. Now the bad news: Excel is annoying. Often, the reason is that Excel is so feature-rich that it's hard to know how to access or use particular features efficiently. Since an Excel 97 worksheet supports 65,536 rows, how do you easily navigate from cell A1 to cell E6990, for instance? And how can you take advantage of Excel's powerful features when they're buried so deep in the Excel interface that you don't even know they're there? Excel 97 Annoyances steps the reader through all of these and many other annoyances, showing how to eliminate them so the user can accomplish tasks easily and efficiently with Excel in order to get some real work done. Some of the topics covered in the book are:

Construction of a perfect toolbar that reflects the way you work, and not the way Microsoft markets its software
Techniques for taking full advantage of Excel's auditing features to prevent the ultimate annoyance: an incorrect spreadsheet
How to effectively use Excel's Internet features
How to use Excel's data validation features to insure users enter valid data into your spreadsheets

This book also introduces users to Visual Basic for Applications (VBA), illustrates how to use the VBA/Excel Editor, and shows how to use VBA to fight off many annoyances, by modifying Excel to work the way you want it to. Excel 97 Annoyances is aimed at users who prefer to use Excel 97 in the most effective way possible. Spending a small amount of time following the tips in this book to eliminate annoyances will save countless hours when working with Excel.

Featured customer reviews

Excel 97 Annoyances Review, February 20 1999
Submitted by I am teaching spreadsheets and demograph [Respond | View]

This is a great book. I enjoyed reading it. And although I am not a novice in the field of programming and especcially spreadsheets I was able to learn a lot from this book.

Dr. Sergei Scherbov

Excel 97 Annoyances Review, August 01 1998
Submitted by ETA Friends [Respond | View]

full reviews of excellent O'Reilly titles at
http://www.exam-ta.ac.uk/onlinere.htm

Keep up the super work :-)
ETA, A Fountain of Positive Energy

Read all reviews

Media reviews "This is yet another invaluable book in the O'Reilly series, which details ways to make Microsoft products work for you, instead of being ruled by their idiosyncracies or doing battle with uncooperative techies on the phone. The O'Reilly series, this book certainly included, really takes users down to the brass tacks of how to tailor MS software to their own needs, including sections on VBA editing and macros, and excellent advice on how to avoid the common pitfalls of working with Excel. Learn the source of your most common annoyances with Excel, including the seemingly endless 'work files' and garbage it puts out when you are creating a simple spreadsheet, and just how to get rid of such 'extras' without phoning Microsoft or the suicide hotline. The formulas and functions section in the book is a veritable godsend, and even the most non-programming- proficient user can find things to program to her/his own advantage in the clearly written and excellent explanations and advice found here." --J.R. Griffin, Contributing Editor The Missouri Review, jrae@compuserve.com; Book Review from NewMedia Canada

"Microsoft Corp.'s popular Office 97 Suite is so full of infuriating quirks that someone should write a book about it. The job turns out to take more than one volume, and publisher O'Reilly & Associates Inc. has made a lot of headway in the third and fourth titles in its series of 'Windows Annoyances' tutorials.

"Examining near-final drafts of 'Office 97 Annoyances' (due next month for $21.95) and 'Excel 97 Annoyances' (released this month at $21.95), PC Week Labs found both books well-stocked with suggestions that may cut costs of corporate support. The help is needed because, although Office may be the lingua franca of the PC-equipped workplace, it isn't an easy language to learn or to use with elegance or style.

Read all reviews

See larger cover

Got a Question?