Format Type: PDF, Mobi
Read Online: 943
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 Annoyancessteps 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 Annoyancesis 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.