Nicht aus der Schweiz? Besuchen Sie lehmanns.de
Excel 97 Annoyances - Woody Leonhard, Lee Hudspeth, T.J. Lee

Excel 97 Annoyances

Buch
336 Seiten
1997
O'Reilly Media (Verlag)
978-1-56592-309-6 (ISBN)
CHF 25,90 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
This text uncovers Excel 97's hard to find features and tells how to eliminate the annoyances of data analysis. It shows how to retreive data from the Web and details the construction of a toolbar.
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.

Woody Leonhard's books include Windows 3.1 Programming for Mere Mortals, The Underground Guide to Word for Windows, The Hacker's Guide to Word for Windows, The Mother of All PC Books, The Mother of All Windows 95 Books, and several others. He was series editor for Addison-Wesley's Underground Guides (11 books) and A-W's Hacker's Guides (4 books). Along with T.J. Lee and Lee Hudspeth he's editor-in-chief of PC Computing's Undocumented Office, a monthly hardcopy newsletter. He's a contributing editor at PC Computing (circulation 1,000,000+), and productivity editor for Office Computing (circulation 400,000), a new monthly magazine from the editors of PC Computing. He also publishes a free weekly electronic news bulletin on Microsoft Office called WOW (Woody's Office Watch), available by sending email to wow@wopr.com. Woody's software company makes WOPR (Woody's Office POWER Pack), the number-one enhancement to Microsoft Office. A self-described "grizzled computer hack, frustrated novelist and Office victim," by day he's a Tibetan human rights activist and co-founder of the Tibetan Children's Fund. Woody lives on top of a mountain in Coal Creek Canyon, Colorado. Lee Hudspeth is a co-founder of PRIME Consulting Group, Inc. (Hermosa Beach, CA), a Microsoft Solution Provider. His background is in operations research, financial analysis, and marketing analysis (formerly with Unocal Corp.). He has coauthored several books on Office, including The Underground Guide to Microsoft Office, OLE, and VBA and The Underground Guide to Excel 5.0 for Windows. He is co-editor-in-chief of the monthly newsletter Woody's Underground Office. He's a Microsoft MVP (Most Valued Professional), coauthor of the Microsoft course on application development using WordBasic, and a certified Microsoft trainer in Visual Basic and WordBasic. Along with other PRIME Consulting staff, Lee has developed innumerable lines of VB, VBA, and WordBasic code for the firm's numerous Office add-ins (PRIME for Excel and PRIME for Word), going way back to Word 2.0. Lee also writes and delivers Office usage and development custom courses to hordes of interested parties the world over. T.J. Lee, also a co-founder of PRIME Consulting Group, has a background as a certified public accountant and has done computer and management consulting for years. He has coauthored several books on Office, including The Underground Guide to Microsoft Excel 5 and The Underground Guide to Microsoft Office, OLE and VBA. T.J. is co-editor-in-chief of the monthly newsletter Woody's Underground Office and a certified Microsoft trainer. He has written countless courseware packages and manuals, coauthored the Microsoft Education Services course on Developing Applications in Word, and taught and lectured for thousands of developers and end users.

Erscheint lt. Verlag 7.10.1997
Reihe/Serie A Nutshell handbook
Zusatzinfo illustrations
Verlagsort Sebastopol
Sprache englisch
Maße 152 x 229 mm
Gewicht 550 g
Einbandart kartoniert
Themenwelt Informatik Office Programme Excel
ISBN-10 1-56592-309-X / 156592309X
ISBN-13 978-1-56592-309-6 / 9781565923096
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
raffinierte Zaubereien für Excel-Kenner

von Ignatz Schels

Buch | Softcover (2024)
Markt + Technik (Verlag)
CHF 34,90