Microsoft® Office 2000 Secrets® [Paperback]

Steve Cummings (Author)

Book Description

ISBN-10: 0764532626 | ISBN-13: 978-0764532627 | Publication Date: June 1, 1999

Microsoft^® Office 2000 Secrets^® "Any book can teach you how to use Office. This one shows you how to make it sing." — PC Magazine If you really want to know what Office 2000 can do, this is the book for you. From the desktop to the Web, Microsoft Office 2000 Secrets reveals some surprising, never-before-documented tips and techniques that will instantly help you increase your productivity. Whether it's the full-speed formatting skills of Word or the programming powers of VBA, this unique book uncovers it all! Harness the Real Power of Office 2000

• Customize your keyboard, menus, shortcut bar, and other toolbars
• Discover hidden techniques for managing, securing, and sharing documents
• Learn expert page layout and data analysis techniques
• Master Office 2000's new Web collaboration features
• Build interactive Web pages using standard word processing, spreadsheet, database, and presentation tools
• Create custom ActiveX controls
• Write powerful stand-alone Office applications using VBA

All the macros from the book on CD-ROM, plus:

• Power Utility Pak
• Check Writer
• Infocourier
• ClipMate
• WinZip
• Paint Shop Pro

Shareware programs are fully functional, free trial versions of copyrighted programs. If you like particular programs, register with their authors for a nominal fee and receive licenses, enhanced versions, and technical support. Freeware programs are free, copyrighted games, applications, and utilities. You can copy them to as many PCs as you like — free — but they have no technical support.

Editorial Reviews

Amazon.com Review

Microsoft Office 2000 Secrets does two things. First, it reveals a number of semi-obscure facts and procedures that enable you to accomplish tasks quickly in the Office 2000 programs. Second, the author presents a tutorial in Visual Basic for Applications (VBA) with various macros he's written in the language. Between the tips, the programming lessons, and the problem-solving macros, Cummings has created a valuable resource for the Office 2000 power user.

This book really shines with its VBA tutorials. Even if you have no programming experience at all and have found yourself baffled by the code that the Office macro recorder generates, you'll be able to follow this book's lead. You'll learn to recognize specific Office elements in your code, create custom dialog boxes, and take advantage of logical structures like If ... Then statements and For ... Next loops.

You'll find some prewritten macros in Microsoft Office 2000 Secrets (and on the companion CD-ROM). Some are academic, but others automate useful tasks like stripping extra carriage returns and linefeeds out of imported text files, copying a selected block of text to a new file, and inserting the current date as text rather than as a field. Note however that most of the macros work only with Word. Check out O'Reilly's Annoyances books if you like what you see here. --David Wall

About the Author

About the Author Steve Cummings has been writing about computers since the early 1980s. A former database columnist for PC World, he is the author of over a dozen computer books on topics ranging from mobile computing to Visual Basic for Applications, plus hundreds of articles for PC Week, PC/Computing, Macworld, Keyboard, and other magazines.

Product Details

• Paperback: 1247 pages
• Publisher: Wiley (June 1, 1999)
• Language: English
• ISBN-10: 0764532626
• ISBN-13: 978-0764532627
• Product Dimensions: 9.1 x 7.3 x 2.2 inches
• Shipping Weight: 4.8 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #5,014,141 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

4.0 out of 5 stars A Great Treasure Chest, May 15, 2000

By 

Daniel Lamarche "D. Lamarche" (Melbourne, VIC, Australia) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® Office 2000 Secrets® (Paperback)

I love reading this book. I've picked-up many small tricks in Word and FrontPage. Mr. Cummings makes good use of humor in his text, which makes a dry subject easier to digest. All standard Office 2000 applications are covered and some useful macros can be found ready to type. My favorite is the ZoomToggle macro, which toggles the Zoom factor in a Word document with the previous one.

I have only one reserve, the section about learning VBA. The 217-page section devoted to learning VBA in Office doesn't really attain the goal. Too bad there aren't many serious, real-life snippets of useful code ready to use. If you want to learn VBA, do not rely on this section.

On the other hand, if you're not into programming Office, if you're comfortable with the basics and want to become a power user, you will find many, many useful tip and secrets for all the main Office applications you use specially Word, Excel, PowerPoint and Outlook.

6 of 8 people found the following review helpful:

4.0 out of 5 stars Nearly the perfect Office Book for Interm./Advandced Users, December 30, 1999

By 

Michael Hellmich (Germany) - See all my reviews

This review is from: Microsoft® Office 2000 Secrets® (Paperback)

I personally liked this book a lot. The layout and the way how things are explained are just perfect. I myself gave Office courses in big companies, but was never bored reading this book and got really a lot of new ideas.

The idea to provide short background information in abook why to do things in a certain way and not in an other is basically such a simple idea , but only this the author - in my opinion - knew ho to use it perfectly.

The TOC and the Index of this book are also excellent.

I didn`t rate this book with 5 stars, because I would expect a few more examples and creative solutions to a few common office tasks for the highest rate. For example I didn`t find anything about Dashboard usage or the Web-Folder use in Outlook 2000 in combination with tasks which have to be completed by anyone of a workgroup. But still its a very good book.

I got this book and the "Using Office 2000" book by Woody Leonhard and use them as follows: First I look in the Office 2000 Sercets since it is nicer and easier to read, if I can`t find it here I try to find it in Using Office 2000.

The perfect book would be to have this layout etc. and have some additional creative solutions e.g. from Using Office 2000 added. Maybe (Hopefully) one day both authors can work together on such a book.