Synopsis: 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.
Table of Contents (off-site)
O'Reilly Publishing • ISBN 1-56592-309-X • June 1998
Copyright © 1997 PRIME Consulting Group, Inc.
Portions of Chapter 5 Copyright © 1997 by Pinecliffe International
About the Authors:
Woody Leonhard has written or co-written more than a dozen books, including The Mother of All Windows 98 Books, Woody Leonhard Teaches Microsoft Office, Windows 3.1 Programming for Mere Mortals, The Underground Guide to Word for Windows, and The Hacker's Guide to Word for Windows.
He's a contributing editor and monthly "Help" columnist at PC Computing magazine (circulation 1,000,000+). Along with numerous co-authors, including T.J. Lee and Lee Hudspeth, and various editors, he has earned five Computer Press Association awards, and one from the American Business Press.
Leonhard publishes a free weekly electronic news bulletin on Microsoft Office called WOW (Woody's Office Watch, circulation 50,000+). Leonhard'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.
Lee Hudspeth is a co-founder of PRIME Consulting Group and The Naked PC newsletter. His background is in operations research, programming, financial analysis, and marketing analysis (formerly with Unocal Corporation). He has co-authored several books on Office, including four in O'Reilly's Annoyances series (Outlook, Office 97, Excel 97, and Word 97), The Underground Guide to Microsoft Excel 5, and The Underground Guide to Microsoft Office, OLE and VBA. He is a certified Microsoft trainer in Visual Basic and WordBasic, and co-author of the Microsoft course on application development using WordBasic.
Along with other PRIME Consulting staff, Hudspeth has developed innumerable lines of VB, VBA, and WordBasic code for his firm's Office add-ins (PRIME for Excel and PRIME for Word), going way back to Word 2.0. Hudspeth also writes and delivers Office usage and development custom courses to hordes of interested parties the world over. Along with T.J. Lee, Hudspeth was co-Editor-In-Chief for Woody's Underground Office newsletter, winning the Computer Press Association's 1997 Best Overall Newsletter award. He is a regular contributor to PC Computing magazine and Woody's Office Watch newsletter.
T.J. Lee also a co-founder of PRIME Consulting Group and The Naked PC newsletter, has a background as a certified public accountant and has done computer and management consulting for years. He has co-authored several books on Office, including four in O'Reilly's Annoyances series (Outlook, Office 97, Excel 97, and Word 97), The Underground Guide to Microsoft Excel 5, and The Underground Guide to Microsoft Office, OLE and VBA.
Lee is a certified Microsoft trainer and has written countless courseware packages and manuals, co-authored the Microsoft Education Services course on Developing Applications in Word, and taught and lectured for thousands of developers and end users. Along with Hudspeth, Lee was co-Editor-In-Chief for Woody's Underground Office newsletter, winning the Computer Press Association's 1997 Best Overall Newsletter award. He is a regular contributor to PC Computing magazine and Woody's Office Watch newsletter. Lee is also a key architect of his firm's Office add-ins PRIME for Excel and PRIME for Word.
