• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL



In this chapter

Who Should Buy This Book

How This Book Is Organized

What Is Que's Special Edition WOPR 2000 Pack?

Conventions Used in This Book

Funny how things change in less than a decade. Way back in the early 1990s—an eternity when measured in Internet time—Microsoft decided to bundle its most popular programs in a single package called Office. The individual programs that made up that first Office version had little in common except a few toolbar buttons and top-level menus. It was basically a four-for-one deal, crammed onto a foot-high stack of floppy disks.

Three versions later, Microsoft Office is the best-selling business application in the history of personal computing, with more than 70 million copies sold. In Office 2000, Microsoft has largely delivered on its promise to integrate the different programs that make up Office—toolbars don't just look alike, they use the exact same code, and when you learn how to customize one application you can generally transfer the same skills to other Office programs.

Yes, Office 2000 still has odd inconsistencies, as well as bugs, features that don't work as advertised, and basic interface elements guaranteed to drive expert users crazy. But there are also startling usability improvements, including major improvements in some of the most basic features of Word and Excel, the oldest and most popular Office applications.

The deeper you go into Office 2000, the more you find, including a sophisticated programming language—Visual Basic for Applications—that lets you automate tasks and tie together business processes in ways that are literally limited only by your imagination. Office 2000 also speaks fluent Internet, with superb support for Internet standards—a remarkable achievement when you consider that the World Wide Web didn't even exist when Office debuted less than a decade ago.

Given the remarkable changes in Office through the years, we didn't think it was fair to simply update a previous edition of this book. So what you see in Special Edition Using Microsoft Office 2000 is completely new material, from front to back. You won't find leftover tips and outdated explanations in this volume.

Who Should Buy This Book

If you need an Office 2000 reference book you can rely on—one that won't bore you with the obvious, pull punches when Office comes up short, or turn mealy-mouthed when you hit the really hard parts—you have the right book in your hands.

As with other titles in Que's best-selling Special Edition Using series, this book focuses on the unique needs of business professionals and business users. We assume you're experienced with Windows, the Web, and, for the most part, previous versions of Microsoft Office. We know that Office is an absolutely essential part of your everyday working life. We're also certain you've experienced your fair share of Office bugs and annoyances firsthand. Because we're confident you've already figured out the basics, we've spent our time figuring out how these programs really work. Trust us—Office has plenty of bugs and poorly designed features, and Microsoft doesn't always make it easy to see how you can combine features or customize applications to increase productivity.

What you'll find documented here is the raw Office, in all its glory, seen through the eyes of experts who have been pushing Office to the limit for years and years. We don't gloss over the rough spots. We show you what works and what doesn't—giving real-world examples and advice for the former and, whenever possible, workarounds for the latter.

We built this book from the ground up as the first Office reference category killer. You'll find page after page after page of previously undocumented material—key details, insight, and real-world advice you can't find anywhere else. And it's all arranged so that you can get in, find the answer you need, apply it to your work at hand, and get out, in record time. There's never been a computer reference book like this: dead-on accurate, encyclopedic, but accessible and usable. It may weigh a ton, but if you need the straight scoop on anything related to Office, this is where you should look first.

If you use Office every day, the book should pay for itself in the first hour—maybe in the first ten minutes. As far as we're concerned, the only correct answer to Microsoft's "Where do you want to go today?" is "Home"—you want to get your problem solved and get home on time. We know that. Even if it seems that Microsoft doesn't.

To top it all off—to seal this book's reputation as a category killer and the best value on the market—we've included a fully licensed copy of the award-winning Office add-on "Woody's Office POWER Pack," or WOPR (pronounced "whopper") 2000. Tens of thousands of copies of WOPR have been sold for $49.95. The latest version, WOPR 2000, is available only on Que's Special Edition WOPR 2000 Pack, which you'll find on this book's CD.

We hope you agree that Special Edition Using Microsoft Office 2000 "raises the bar" for Office reference books.

How This Book Is Organized

Special Edition Using Microsoft Office 2000 is organized into 11 parts. Naturally, each of the seven major applications in the Office suite gets its own section. (The eighth application, PhotoDraw, doesn't get its own section—it's covered in the FrontPage section.) Before diving into specific features of Word and Excel, however, we recommend you read through the sections that cover the techniques common to all applications.

Part I, "Common Tasks," covers the essentials of Office, including techniques you can use to transform the Office interface into your own personal productivity center. You'll probably be startled the first time you see Office 2000's radically redesigned Open and Save As dialog boxes. We explain exactly how to use and customize them so that you can find your working files with the fewest possible clicks. This section also covers Office 2000's stellar graphics tools. And if you find the Office Assistant annoying, we show you how to make it disappear, permanently, in Chapter 6.

Previous Office versions included only the most rudimentary Web-page editing tools. This new version is a superb HTML editor. Turn to Part II, "Office and the Web," for in-depth instructions on how you can create, edit, and publish sophisticated Web pages without having to tangle with HTML tags.

Part III, "Using Word," covers the most popular productivity application in Office. We'll walk you through every customization option (including a few you probably never even knew you needed). We'll show you how to supercharge your text-editing and formatting skills, how to manage long documents, and how to automate everyday documents so that they practically write themselves.

Part IV, "Using Excel," shows you tricks you never realized you could perform with this incredibly versatile tool. Check out the examples in our formatting chapters, for example, to see how you can turn drab rows and columns into eye-catching data graphics. We'll explain how to master any of Excel's 300+ functions, as well as which ones are worth memorizing. If you struggled with PivotTables in previous versions of Office, turn straight to Chapter 25. PivotTables (and their graphics cousins, PivotCharts) will change your life—we promise. And we'll show you how to use Excel to create bulletproof worksheets and data-entry forms that you can confidently distribute to even the most clueless computer user.

Outlook 2000 is a strange beast. After you master its sometimes overwhelming interface, you'll use it to tie together contacts, calendars, tasks, and email. In Part V, "Using Outlook," we'll help you tame the flood of email, banish spam forever, keep your address book up to date, and set up reminders so that you never miss another appointment.

Of all the Office applications, PowerPoint is probably the least appreciated. In Part VI, "Using PowerPoint," we explain how this program really works, and we'll help you create compelling presentations that you can deliver in front of a large audience or a small one—or completely unattended over the Web.

And then there's Access, Microsoft's industrial-strength database management program. In Part VII, "Using Access," we focus on building tables, forms, and reports, and using simple (and not-so-simple) queries to find and filter data. We'll also clue you in on techniques you can use to automate everyday business tasks without having to become a programmer.

Although Publisher hardly rates as a full-fledged member of the Office team—it was added to the package at the last minute and suffers from all sorts of shortcomings knowledgeable Office users shouldn't have to endure—we give it a good shot in Part VIII, "Using Publisher." If you know Office, but don't know Publisher, spending some time in this section will pay big dividends.

FrontPage, on the other hand, makes the grade as a comprehensive, useful tool for Web site designers at almost all levels of expertise. Although its Office pedigree has yet to be established (FrontPage, too, is a brand-new addition to the package), and some components of its user interface confound experienced Office users, every serious Office user with Web aspirations should take the time to learn it. Check out Part IX, "Using FrontPage and PhotoDraw," for FrontPage, and a bit of PhotoDraw as well.

If you've tinkered with Word and Excel macros in previous Office versions, Part X, "Automating Office with Macros and VBA," will take you to the next level. We explain the core concepts of VBA, and we'll help you build up a library of useful macros and mini- programs that you can use to become more productive.

If you need to install Office on one PC or several hundred, we'll run through all your options in one of two appendixes at the back of the book. In the last appendix, we'll show you how to use the valuable utilities you'll find on Que's Special Edition WOPR 2000 Pack (the CD-ROM included with this book), including a bonus you won't find anywhere else: a fully licensed copy of Woody's Office POWER Pack (WOPR) for Office 2000.

What Is Que's Special Edition WOPR 2000 Pack?

WOPR 2000 (pronounced "whopper") is available exclusively through Que books and Macmillan Computer Publishing. WOPR is the #1 Office add-in, providing a custom set of tools to enhance Office 2000. The copy of WOPR 2000 on Que's Special Edition WOPR 2000 Pack CD is fully licensed at no additional cost to you. This isn't shareware, freeware, trialware, demoware, or limited in any other way.

For more information on WOPR, see the tear booklet in the front of this book and Appendix B, "What's on Que's Special Edition WOPR 2000 Pack CD."

Conventions Used in This Book

Special conventions are used to help you get the most from this book and from Office 2000.

Text Conventions

Various typefaces in this book identify terms and other special objects. These special typefaces include the following:

ItalicNew terms or phrases when initially defined. An italic term followed by a page number indicates the page where that term is first defined.
UnderlineMenu and dialog box options with letters that appear underlined onscreen indicate shortcut keys (hotkeys).
MonospaceInformation that you type, Web addresses, or onscreen messages.
UPPERCASETypically used to indicate Excel objects, such as functions and cell references.
Initial CapsMenus, dialog box names, dialog box elements, and commands are capitalized.

Key combinations are represented with a plus sign. For example, if the text calls for you to enter Ctrl+S, you would press the Ctrl key and the S key at the same time.

Secrets of the Office Masters

While using Office, you'll find many features that work well together or others that simply don't work well at all without some poking and prodding. We've used this chapter-ending element to point out some key areas in which you can combine features or find startlingly productive new uses for everyday features.

Special Elements

Throughout this book, you'll find Tips, Notes, Cautions, Sidebars, Cross References, and Troubleshooting Tips. These elements provide a variety of information, ranging from warnings you shouldn't miss to ancillary information that will enrich your Office experience, but isn't required reading.

Ed and Woods's "Signature" Tips

Tip #600 from

Tips are designed to point out features, annoyances, and tricks of the trade that you might otherwise miss. These aren't wimpy, run-of-the-mill tips that you learned the first week you used Office and don't need us to tell you. Watch for our signatures on the tips to indicate some industrial-strength—and in many cases never-before-documented—information.


Notes point out items that you should be aware of, although you can skip these if you're in a hurry. Generally, we've added notes as a way to give you some extra information on a topic without weighting you down.


Pay attention to Cautions! These could save you precious hours in lost work. Don't say we didn't warn you.

Troubleshooting Notes

We designed these elements to call attention to common pitfalls that you're likely to encounter. When you see a Troubleshooting note, you can flip to the Troubleshooting section at the end of the chapter to learn how to solve or avoid a problem.

Cross References

Cross references are designed to point you to other locations in this book (or other books in the Que family) that will provide supplemental or supporting information. Cross references appear as follows:

→ For a full discussion of the wonders of PivotTables, see "How PivotTable and PivotChart Reports Work."

Want to Know More

Sidebars are designed to provide information that is ancillary to the topic being discussed. Read these if you want to learn more about an application or task.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint