Office 2008 for Mac All-in-One for Dummies (ISBN - 0470460415)

843 Pages·2008·47.5 MB·English

Geetesh Bajaj, MVP
James Gordon, MVP

6 IN 1

BOOKS
BOOKS

• Introducing Office 2008
• Word 2008
• Excel® 2008
• PowerPoint® 2008
• Entourage® 2008
• Entourage’s Project Center

Office 2008
for Mac

®

Microsoft®

A L L - I N - O N E

Making Everything Easier!™

Open the book and find:

• The tools and features common to
all the Office 2008 apps

• Cool ways to use the Project Center

• Tips on making the most of the
new interface

• How Word streamlines your word
processing

• Ways to get control of Excel

• How to add animation to your
PowerPoint presentations

• Helpful hints for using Entourage
Rules

• Advice about sharing and
collaborating on projects

Geetesh Bajaj is a PowerPoint MVP and heads an online presentation site
at www.indezine.com that provides templates and advice for PowerPoint
users. James Gordon is a Microsoft MVP for Macintosh. He created the
InsertPicture add-in for PowerPoint and provides training on various Office
topics.

Desktop Applications/General

$34.99 US / $41.99 CN / £24.99 UK

ISBN 978-0-470-46041-2

Go to Dummies.com®

for videos, step-by-step examples,
how-to articles, or to shop!

Tap into all the tools
in Office 2008 for Mac —
this book makes it easy!

New to Office 2008? Migrating from Windows to Mac? This
complete reference is just what you need! It shows you
how to use every Office 2008 application so you can start
getting things done right away. Explore the Project Gallery,
learn how the applications work together, excel at Excel,
present with power, manage your life with Entourage, and
more.

• Meet the suite — use the new galleries that help you quickly find
features, formats, wizards, templates, and recently used files

• A gallery of projects — see how the Project Gallery serves as a
hub for finding and opening documents, projects, or documents
within a project

• In a Word — discover the extra functionality of Word’s built-in
Notebook and Publishing layouts

• Excel revealed — explore ledger sheets, learn how Excel can
open Web pages in HTML format, and create your own templates

• Put the power in PowerPoint — use the View, add transitions,
insert music from your iTunes library, and fine-tune timing

• You have an Entourage — get organized with My Day, handle
contacts and e-mail, and manage a database

• Use the Project Center — manage projects of all sizes

Introducing Office
2008

Word 2008

Excel® 2008

PowerPoint® 2008

Entourage® 2008

Entourage’s
Project Center

Office 2008 for Mac
®

A L L - I N - O N E

Microsoft®

Bajaj
Gordon

est spine=1.68”

est spine=1.68”

Start with FREE Cheat Sheets

Cheat Sheets include

• Checklists

• Charts

• Common Instructions

• And Other Good Stuff!

Get Smart at Dummies.com
Dummies.com makes your life easier with 1,000s
of answers on everything from removing wallpaper
to using the latest version of Windows.

Check out our

• Videos

• Illustrated Articles

• Step-by-Step Instructions

Plus, each month you can win valuable prizes by entering
our Dummies.com sweepstakes. *

Want a weekly dose of Dummies? Sign up for Newsletters on

• Digital Photography

• Microsoft Windows & Office

• Personal Finance & Investing

• Health & Wellness

• Computing, iPods & Cell Phones

• eBay

• Internet

• Food, Home & Garden

Find out “HOW” at Dummies.com

*Sweepstakes not currently available in all countries; visit Dummies.com for official rules.

Get More and Do More at Dummies.com®

To access the Cheat Sheet created specifically for this book, go to
www.dummies.com/cheatsheet/office2008formacaio

by Geetesh Bajaj and James Gordon

Office 2008
for Mac®

AL L -I N - O N E

FOR
DUMmIES

‰

Offi ce 2008 for Mac® All-in-One For Dummies®

Published by
Wiley Publishing, Inc.
111 River Street
Hoboken, NJ 07030-5774

www.wiley.com

Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana

Published by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or
by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit-
ted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written
permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the
Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone].
Requests to the Publisher for permission should be addressed to the Permission Department, John Wiley
& Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at http://
www.wiley.com/go/permissions.

Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the
Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything
Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/
or its affi liates in the United States and other countries, and may not be used without written permission.
Mac is a registered trademark of Apple, Inc. All other trademarks are the property of their respective
owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO
REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE
CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT
LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE
CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES
CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE
UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR
OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF
A COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE
AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION
OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF
FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE
INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY
MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK
MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN
IT IS READ.

For general information on our other products and services, please contact our Customer Care
Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax [phone].

For technical support, please visit www.wiley.com/techsupport.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may
not be available in electronic books.

Library of Congress Control Number: 2009935234

ISBN: 978-0-470-46041-2

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

About the Authors

Geetesh Bajaj has been creating Microsoft Offi ce documents, presentations,
and templates for over a decade now. Geetesh heads Indezine, a presenta-
tion design studio based out of Hyderabad, India, and he also runs the popu-
lar indezine.com Web site. Geetesh is a Microsoft-awarded Most Valuable
Professional (MVP) and author of four other computer books (two of them
published by Wiley).

James Gordon is a lead programmer/analyst at the University at Buffalo
and the State University of New York where he also teaches workshops on
Microsoft Offi ce and other technologies. Microsoft has presented its Most
Valuable Professional (MVP) award to James for his contributions to techni-
cal communities. James has written several programs, including the popular
InsertPicture add-in that runs in PowerPoint for Mac, and is a member and
past-president of ProMac Users Group, Inc.

Dedication

To Steve Jobs and Bill Gates.

Authors’ Acknowledgments

We thank the divine, and other mere mortals with divine abilities.

Special thanks to everyone at Wiley for helping us put this book together.
Acquisitions editor Kyle Looper and project editor Mark Enochs kept every-
thing on track. Thanks go to the editorial team, including copy editors Jen
Riggs and John Edwards, and technical editor James Russell.

Thanks go to our families and friends for allowing us to focus on our writing
without deserting us. We express our appreciation to them all.

Geetesh wishes to thank his offi ce staff who helped him take the time off to
write this book as well as the amazing bunch of other Microsoft MVPs who
are too numerous to be listed here.

Jim wishes to extend special thanks to the University at Buffalo for allowing
leave to work on the book. The University at Buffalo is truly one of the best
places to work or attend.

We thank the Macintosh Business Unit of Microsoft, who created the subject
matter of the book, and Microsoft Corporation for the awesome MVP program,
without which it is unlikely the authors would have been able to meet and
collaborate. And we also thank Apple for creating an enriching OS platform.

Finally, both the authors thank each other!

Publisher’s Acknowledgments

We’re proud of this book; please send us your comments through our online registration form
located at http://dummies.custhelp.com. For other comments, please contact our Customer
Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax [phone].

Some of the people who helped bring this book to market include the following:

Acquisitions, Editorial, and Media
Development

Senior Project Editor: Mark Enochs

Acquisitions Editor: Kyle Looper

Copy Editors: Jennifer Riggs, John Edwards

Technical Editor: James Russell

Senior Editorial Manager: Leah Cameron

Media Development Project Manager:
Laura Moss-Hollister

Media Development Assistant Project Manager:
Jenny Swisher

Media Development Assistant Producers:
Angela Denny, Josh Frank, Shawn Patrick,
and Kit Malone

Editorial Assistant: Amanda Graham

Sr. Editorial Assistant: Cherie Case

Cartoons: Rich Tennant
(www.the5thwave.com)

Composition Services

Project Coordinator: Patrick Redmond

Layout and Graphics: Samantha K. Cherolis,
Joyce Haughey, Christine Williams

Proofreaders: ConText Editorial Services, Inc.,
Caitie Copple

Indexer: BIM Indexing & Proofreading Services

Special Help

Tonya Cupp, Laura Miller, and Beth Taylor.

Publishing and Editorial for Technology Dummies

Richard Swadley, Vice President and Executive Group Publisher

Andy Cummings, Vice President and Publisher

Mary Bednarek, Executive Acquisitions Director

Mary C. Corder, Editorial Director

Publishing for Consumer Dummies

Diane Graves Steele, Vice President and Publisher

Composition Services

Gerry Fahey, Vice President of Production Services

Debbie Stailey, Director of Composition Services

Contents at a Glance

Introduction ................................................................ 1

Book I: Introducing Office 2008 ................................... 7

Chapter 1: Oscillating in the Offi ce 2008 World .............................................................9
Chapter 2: Project Gallery — The Natural Starting Point ...........................................37
Chapter 3: Menus and Toolbars .....................................................................................55
Chapter 4: Busting Out Your Toolbox ...........................................................................69
Chapter 5: Graphing, Drawing, and Making Art ...........................................................91
Chapter 6: Common Tools That Make Your Life Easier ............................................113
Chapter 7: Getting Help! ................................................................................................129

Book II: Word 2008 ................................................. 143

Chapter 1: Getting to Know Word’s Interface .............................................................145
Chapter 2: An Open and Shut Case ..............................................................................167
Chapter 3: Working with Text, Words, and Paragraphs ............................................185
Chapter 4: Reviewing and Proofi ng with Word ..........................................................223
Chapter 5: Making Great Tables and Charts ...............................................................241
Chapter 6: Saving Time in Word ...................................................................................271
Chapter 7: Advanced Word Stuff ..................................................................................311
Chapter 8: Printing for Posterity ..................................................................................341

Book III: Excel 2008 ................................................ 355

Chapter 1: Working Every Day in Excel .......................................................................357
Chapter 2: Operating Inside the Workbook ................................................................379
Chapter 3: Formatting and Collaborating in Excel ....................................................401
Chapter 4: Controlling Excel .........................................................................................429
Chapter 5: Heavenly Charting ......................................................................................441
Chapter 6: Becoming Versatile with Excel ..................................................................457
Chapter 7: Being Intelligent with Data.........................................................................477
Chapter 8: Printing from Excel .....................................................................................491

Book IV: PowerPoint 2008 ....................................... 503

Chapter 1: Revealing PowerPoint ................................................................................505
Chapter 2: Open Sesame and Shut Sesame ................................................................515
Chapter 3: Working with the Whole Show ..................................................................523
Chapter 4: Mastering the Masters ...............................................................................539
Chapter 5: Proofi ng the Presentation ..........................................................................549
Chapter 6: Adding Text, Pictures, Tables, and Charts...............................................555
Chapter 7: Applying Animation ....................................................................................569
Chapter 8: Presenting Sounds and Movies .................................................................577
Chapter 9: Printing and Sharing Presentations ..........................................................595

Book V: Entourage 2008 .......................................... 609

Chapter 1: Introducing Entourage: Seven Applications in One ................................611
Chapter 2: Welcome to the Setup Assistant ...............................................................621
Chapter 3: Mastering Mail .............................................................................................643
Chapter 4: Your Mail Rules and Newsgroups .............................................................667
Chapter 5: Personalizing Your PIM ..............................................................................683
Chapter 6: Crafting Your Calendar ...............................................................................697
Chapter 7: Keeping Track of Your Day ........................................................................715

Book VI: Entourage’s Project Center .......................... 725

Chapter 1: Creating New Projects ................................................................................727
Chapter 2: Overviewing and Sharing Projects ...........................................................739
Chapter 3: Keeping on Schedule ..................................................................................755
Chapter 4: Managing More Project Details .................................................................765

Index ...................................................................... 777

Table of Contents

Introduction ................................................................. 1

About This Book ..............................................................................................1
How to Use This Book .....................................................................................3
How This Book Is Organized ..........................................................................3
Book I: Introducing Offi ce 2008 ............................................................3
Book II: Word 2008 .................................................................................3
Book III: Excel 2008 ................................................................................3
Book IV: PowerPoint 2008 .....................................................................4
Book V: Entourage 2008 ........................................................................4
Book VI: Entourage’s Project Center ...................................................4
Bonus Chapters ......................................................................................4
Conventions Used in This Book .....................................................................4
Stuff you type .........................................................................................4
Menu commands ....................................................................................5
Key combinations ..................................................................................5
Right-click versus Control-click ...........................................................5
Display messages ...................................................................................5
Icons Used in This Book .................................................................................5
Where to Go from Here ...................................................................................6

Book I: Introducing Office 2008 .................................... 7

Chapter 1: Oscillating in the Offi ce 2008 World . . . . . . . . . . . . . . . . . . . .9

Getting Familiar with Offi ce 2008 .................................................................10
Getting started in Project Gallery ......................................................10
Helping Word veterans make the transition .....................................14
Looking for Visual Basic for Applications (VBA) .............................15
De-mystifying Excel..............................................................................15
Slide shows with PowerPoint .............................................................17
Making your day with Entourage .......................................................19
Mingling instantly with Messenger ....................................................21
Lighting the future with Silverlight ....................................................21
What’s New Offi ce-Wide for 2008? ...............................................................23
Elation from Elements Gallery ............................................................23
Getting smart with SmartArt Graphics .............................................24
Discovering new Offi ce-wide themes ................................................24
Comparing Offi ce 2008 for Mac with Offi ce for Windows .........................25
Picking the products ...........................................................................25
Understanding fi le format compatibility ...........................................27