The 2007 Microsoft Office System Step by Step

Joyce Cox,

Curtis Frye,

M. Dow Lambert III,

Steve Lambert,

and

Joan Preppernau,

with

Katherine Murray

Microsoft

PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399

© 2007 by Curtis Frye and Online Training Solutions, Inc.

ISBN: 9780735622784

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Control Number: 2006936145

1 2 3 4 5 6 7 8 9 QWT 2 1 0 9 8 7

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax [phone]. Visit our Web site at www.microsoft.com/mspress. Send comments to [e-mail].

Microsoft, Microsoft Press, Access, Aero, Calibri, Encarta, Excel, Groove, InfoPath, Internet Explorer, MSN, OneNote, Outlook, PowerPoint, SharePoint, Verdana, Visio, Windows, Windows Mobile, Windows Server, and Windows Vista are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

• Acquisitions Editor: Juliana Aldous Atkinson

• Developmental Editor: Sandra Haynes

• Project Editor: Lisa Culver-Jones

• Editorial Production: Carol Whitney and Terrie Cundiff of nSight, Inc.

• Indexer: Jack Lewis

Body Part No. X12-48777

About the Authors

Joyce Cox

Joyce has 25 years’ experience in the development of training materials about technical subjects for non-technical audiences, and is the author of dozens of books about Office and Windows technologies. She is the Vice President of Online Training Solutions, Inc. (OTSI). She was President of and principal author for Online Press, where she developed the Quick Course series of computer training books for beginning and intermediate adult learners. She was also the first managing editor of Microsoft Press, an editor for Sybex, and an editor for the University of California. Joyce and her husband Ted live in downtown Bellevue, Washington, and escape as often as they can to their tiny, offline cabin in the Cascade foothills.

Curtis Frye

Curt Frye is a freelance writer and Microsoft Most Valuable Professional for Microsoft Office Excel. He lives in Portland, Oregon, and is the author of eight books from Microsoft Press, including Microsoft Office Excel 2007 Step by Step, Microsoft Office Access 2007 Plain & Simple, Microsoft Office Excel 2007 Plain & Simple, and Microsoft Office Small Business Accounting 2006 Step By Step. He has also written numerous articles for the Microsoft Work Essentials web site. Before beginning his writing career in June 1995, Curt spent four years with The MITRE Corporation as a defense trade analyst and one year as Director of Sales and Marketing for Digital Gateway Systems, an Internet service provider. Curt graduated from Syracuse University in 1990 with an honors degree in political science. When he’s not writing, Curt is a professional improvisational comedian with ComedySportz Portland.

Steve Lambert

Steve has written 18 books, most of which are about Microsoft applications. As President of Online Publishing and Programming Solutions, Inc. (OP²S), he has managed the development of many tools for creating and viewing training material. Steve takes advantage of the Internet and computer technology to work from home-a ten-acre horse ranch on the Olympic Peninsula. When not working on technology products, he and his wife Gale spend their time working on the property, training and riding horses, and picking up horse poop.

M. Dow Lambert III

During 20 years in academia, Dow authored or co-authored 19 social science research publications, developed curriculum and training programs for social services professionals, and managed longitudinal studies of human behavior. In 1995, he moved from academia to the private sector, where he worked for a small company that developed and maintained reservation systems for the travel industry. Here he learned the difference between writing research reports for scientific journals, writing technical specifications for programmers, and writing user guides for the people who actually needed to understand and use the software that his company produced. In his spare time, Dow and his wife Marlene enjoy birding and bird photography.

Katherine Murray

Katherine Murray is the author of many books on technology, with a special emphasis on Microsoft Office. Her most recent book, First Look 2007 Microsoft Office System (Microsoft Press, 2006) is available as a free downloadable PDF on the 2007 Microsoft Office download site. Katherine is also the coauthor of Microsoft Word 2007 Inside Out and MSN Spaces: Share Your Story. Katherine is a regular contributor to a number of Microsoft sites and publishes a blog called BlogOffice, offering tips, updates, news, and resources related to a variety of Microsoft Office versions and events.

Katherine has been fascinated by computers since the early 80s when her husband brought home one of the first IBM PCs to arrive in the city of Indianapolis. She lives in the Midwest with her three children (one of whom is married and lives a mile away with her husband and newborn daughter, Ruby-Katherine’s first grandbaby!) and enjoys many non-technical activities including gardening, cooking, reading, jazz, and playing Trivial Pursuit with the kids.

Joan Lambert Preppernau

Joan is the author of more than a dozen books about Windows and Office, including the popular Microsoft Windows XP Step by Step, and a contributor to the development of the Microsoft certification exams for the 2007 Office system and Windows Vista. Having learned about computers literally at her father’s knee, Joan’s wide-ranging experiences in various facets of the computer industry contribute to her enthusiasm for producing interesting, useful, and reader-friendly training materials. Joan is the President of Online Training Solutions, Inc. (OTSI) and an avid telecommuter. The power of the Internet and an obsession with technology have made it possible for Joan to live and work in New Zealand, Sweden, Denmark, and various locations in the U.S. during the past 15 years. Having finally discovered the delights of a daily dose of sunshine, Joan has recently settled in San Diego, California, with her husband Barry and their daughter Trinity.

Online Training Solutions, Inc. (OTSI)

OTSI specializes in the design, creation, and production of Office and Windows training products for information workers and home computer users. For more information about OTSI, visit www.otsi.com