Excel 97 Annoyances - Brossura

Leonhard, Woody; Hudspeth, Lee; Lee, Timothy-James

Brossura

ISBN 10: 156592309X ISBN 13: 9781565923096

Casa editrice: Oreilly & Associates Inc, 1997

Riassunto

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.

Su questo libro

Product Description:

Book by Lee Hudspeth TimothyJames Lee Woody Leonhard

Su questa edizione

• Editore: Oreilly & Associates Inc
• Data di pubblicazione: 1997
• ISBN 10: 156592309X
• ISBN 13: 9781565923096
• Rilegatura: Copertina flessibile
• Numero edizione: 1
• Numero di pagine: 320