Special Edition Using Microsoft Office 2003, Student-Teacher Edition [NOOK Book]


The Student-Teacher Edition of Microsoft Office 2003 is the best-selling version of the software suite, and Special Edition Using Microsoft Office 2003, Student-Teacher Edition is the first book to tackle it from the perspective of this unique user. The SE Using format will help you explore advanced techniques that can save you time and help automate repetitive tasks. You will be able to increase your productivity in all areas of any one of the Microsoft Office 2003 applications. You'll also learn ways to make ...

See more details below
Special Edition Using Microsoft Office 2003, Student-Teacher Edition

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
BN.com price
(Save 43%)$23.99 List Price


The Student-Teacher Edition of Microsoft Office 2003 is the best-selling version of the software suite, and Special Edition Using Microsoft Office 2003, Student-Teacher Edition is the first book to tackle it from the perspective of this unique user. The SE Using format will help you explore advanced techniques that can save you time and help automate repetitive tasks. You will be able to increase your productivity in all areas of any one of the Microsoft Office 2003 applications. You'll also learn ways to make them work better together, further increasing your productivity. Take a look at Microsoft Office 2003 through the eyes of an expert with Special Edition Using Microsoft Office 2003, Student-Teacher Edition.

Read More Show Less

Product Details

  • ISBN-13: 9780132714570
  • Publisher: Pearson Education
  • Publication date: 2/22/2002
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 936
  • File size: 31 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with more than two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing and Smart Business. Ed had written many of Que's all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me. Ed also is co-author of the best-selling, category-owning Windows XP Inside-Out.

Woody Leonhard publishes Woody's Office Watch and Woody's Windows Watch eZines, which are read by more than 500,000 each week. If there is a journalist feared and respected by the geeks at Microsoft, Woody is the guy. Woody's take no prisoners approach to covering Microsoft products as both endeared him to readers worldwide and caused his name to be taken in vain at many a Microsoft product development meeting. He has won an unprecedented six Computer Press Association Awards for his books, newsletters and magazine articles. He is author of many books, including Special Edition Using Office 2000, Woody Teaches Office 97, Woody Teaches Office 2000 and the best-selling Windows XP All in Once Desk Reference for Dummies (Wiley).

Read More Show Less

Read an Excerpt


In this introduction

  • Who Should Buy This Book
  • How This Book Is Organized
  • Conventions Used in This Book

Microsoft Office has been around, in one version or another, for more than a decade. We—that is, Woody and Ed—have been writing about Office since the very beginning. In books, on the Web, and in magazine articles and e-mail newsletters, we've guided lost souls through the Office labyrinth, held Microsoft's feet to the fire over bugs and security breaches, and passed out praise for the many innovations that the Office development team has delivered through the years.

In previous editions, we focused on the needs of people using Microsoft Office in the office. For those books, we focused on budgets, annual reports, e-mails from the boss, and other staples of dull corporate life.

This edition is different. Microsoft Office Student and Teacher Edition is packaged and sold for people who plan to use it at home. Although its individual parts are identical to those found in the Office version used in corporate settings, the day-to-day tasks you're likely to tackle are a little different. That's why, in this book, we've shifted the focus to explain how you can use Word, Excel, PowerPoint, and Outlook to produce school reports, family newsletters, and projects for civic and social organizations. Of course, if you want to use the same technique to sneak in a little work on the weekend, we won't tell.

The audience may be different, but the depth of our coverage hasn't changed. We still assume you're smart, curious, and able to figure out the truly basic stuff on your own. We show you how to use and customize the common parts of Office 2003—toolbars, task panes, and other interface elements—so that when you learn how to customize one Office program you can transfer the same skills to others.

Office 2003 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 as we researched the third edition of this book, we were pleasantly surprised to see how many longtime Office annoyances have finally been fixed. Office 2003 isn't perfect—not by a long shot—but it is indisputably the most stable, usable, and productive version we've ever worked with.

Some of what you see in Special Edition Using Microsoft Office 2003 will be familiar to you if you've worked with an earlier edition of this book. We've gone through every chapter, sentence by sentence, testing, verifying, updating, revising, and adding a wealth of new information to ensure that this book is accurate and absolutely up to date.

Who Should Buy This Book

If you need an Office 2003 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 students, teachers, and anyone using Office 2003 at home. We assume you're experienced with Windows, the Web, and, for the most part, previous versions of Microsoft Office. If you're like most people, you've probably only scratched the surface of the capabilities in Office and you'd like to learn a lot more without taking a graduate course on the software. 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 still has 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.

We figure you're smart enough to experiment with basic features and to read the online help when you want to know how an Office program is supposed to work. That's why you won't find beginner-level instructions in this book. Instead, you'll find what isn't in the official documentation—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. This book may weigh a ton, but if you need the straight scoop on anything related to Office, this is where you should look first.

How This Book Is Organized

Special Edition Using Microsoft Office 2003 is organized into six parts. Naturally, each of the major applications in the Office suite gets its own section. Before diving into specific features of Outlook, Word, Excel, and the rest, however, we recommend you read through the sections that cover the techniques common to all applications.

Part I, "Common Tasks and Features," covers the essentials of Office, including techniques you can use to transform the Office interface into your own personal productivity center. For instance, we show you how to customize the Office Open and Save As dialog boxes so that you can find your working files with the fewest possible clicks. This section also covers Office 2003's stellar graphics and document-scanning tools. Clippit, the annoying Office Assistant, has been downgraded to bit-player status in this version; if the pesky paper clip somehow survived the upgrade process on your computer, we show you how to make it disappear, permanently, in Chapter 1.

With each succeeding version, Outlook 2003 gets a sweeping makeover, and this one is no exception. Its roster of new features includes a revamped (but still sometimes overwhelming) interface you can use to tie together contacts, calendars, tasks, and e-mail. In Part II, "Using Outlook," we help you tame the flood of e-mail, banish spam forever with Outlook's new and surprisingly effective junk-mail filter, keep your address book up to date, and set up reminders so that you never miss another appointment.

Part III, "Using Word," covers the oldest and most polished productivity application in Office. We walk you through every customization option (including a few you probably never even knew you needed). We also 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 to see how you can turn drab rows and columns into eye-catching data graphics. We explain how to master any of Excel's 300+ functions, as well as which ones are worth memorizing. We'll show you how to use PivotTables (and their graphic cousins, PivotCharts) to give you a completely different view of data. Do you have a list of names, addresses, or other information? We also show you how to use the effective new list editing tools to sort, filter, and organize lists like an expert.

Of all the Office applications, PowerPoint is probably the least appreciated. In Part V, "Using PowerPoint," we explain how this program really works, and we 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.

In Part VI, "Advanced Tasks and Features," we focus on ways to extend the capabilities of Office. We explain how to automate Office with macros written in Visual Basic for Applications (VBA). We also explain how you can create, edit, and publish sophisticated web pages without having to tangle with HTML tags. And in the final chapter, we introduce a few features that you'll need to know if you use Office on a portable computer, especially a Tablet PC.

Conventions Used in This Book

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

Text Conventions

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




New terms or phrases when initially defined. An italic term followed by a page number indicates the page where that term is first defined.


Information that you type, Web addresses, or onscreen messages.


Typically used to indicate Excel objects, such as functions and cell references.

Initial Caps

Menus, 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 Woody's "Signature" Tips

Tip - 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.


Note - 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 weighing you down.


Caution - 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.

© Copyright Pearson Education. All rights reserved.

Read More Show Less

Table of Contents

1 Getting started with Office 2003 9
2 Making Office work your way 29
3 Keeping track of your files and settings 61
4 Entering, editing, and formatting text 87
5 Using pictures and drawings 113
6 Using Office programs together 145
7 Getting started with Outlook 165
8 Keeping your email under control 209
9 Stopping viruses, spam, and other security threats 257
10 Organizing your contacts list 275
11 Managing appointments, meetings, and tasks 295
12 Getting started with Word 325
13 Creating great-looking documents 367
14 Tables, sections, and other advanced formatting options 403
15 Mastering styles and templates 447
16 Letters, mail merge, and smart documents 471
17 Getting started with Excel 515
18 Making great-looking worksheets 559
19 Using formulas and functions 593
20 Working with lists and PivotTables 629
21 Turning data into charts 669
22 Getting started with PowerPoint 699
23 Building your presentation 723
24 Adding sizzle to a presentation 759
25 Delivering a presentation with style 783
26 Using macros to automate Office tasks 801
27 Using Office to create Web pages 833
28 Using Office on a tablet PC 853
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)