Office 2011 for Mac for dummies

436 Pages·2011·42.243 MB·English

by  Bob LeVitus

Spine: .8640
Macintosh/Microsoft Office
Making Everything Easier!™
All the tips, tricks, and techniques
to boost your Office productivity
and uncover creative possibilities Open the book and find: OM OMicrosfoft®f ice 2011
i
c
fr
Ready to make your slide shows sing? How about spicing (cid:129) All about what’s new and good o
fs
o
up Word docs? Want to unlock those nuggets hidden in in Office 2011 if
t
your data? This guide quickly shows you how, walking you c® Mac
(cid:129) Tips for working with the Ribbon, e for
through everything you need to know about Office 2011 toolbars, and palettes ®

for Mac. You’ll build spreadsheets, design stunning 2
(cid:129) Ways to enhance Word documents
presentations, create amazing Word files, and manage
with templates and graphics 0
e-mail in no time!
1
(cid:129) How to design slide shows to
(cid:129) Step into basic training — discover how to install Office 2011, create powerful presentations 1
then learn about all the new features available in the latest
(cid:129) Methods for crunching data in f
release
Excel to uncover key information o
(cid:129) Unlock your creative side — incorporate impressive formatting
r
(cid:129) Steps for sending, receiving, and
effects, utilize the best templates, and define your own style so

you can design visually stunning Word documents managing your Outlook e-mail M
(cid:129) Dive into the world of numbers — get up to speed on Excel and (cid:129) Secrets to boost your productivity
a
start crunching those figures in order to effectively analyze and
(cid:129) Advice on customizing Office 2011
present your data c
for your needs
®
(cid:129) Make your presentations stand out — create slide shows that
captivate your audience, using the new and improved tools
available in PowerPoint
Learn to:
(cid:129) Get organized and stay connected — find out how to better
manage your e-mail, keep track of your appointments, save (cid:129) Create great documents, communicate
your contacts, and much more Go to Dummies.com® your ideas, and add visual interest
for videos, step-by-step examples, with Styles
how-to articles, or to shop!
(cid:129) Punch up your presentations with
charts, graphics, and narration
(cid:129) Build spreadsheets, crunch numbers,
and format charts
$24.99 US / $29.99 CN / £17.99 UK (cid:129) Configure e-mail settings, manage your
Bob LeVitus, aka Dr. Mac, is a leading authority on the iPad, iPhone, and ISBN 978-0-470-87869-9 contacts, and organize your calendar
Mac OS X. One of the Mac community’s most trusted gurus for almost
twenty years, he has written or co-written more than 55 books. Bob is
also a columnist for the Houston Chronicle and The Mac Observer.
Bob “Dr. Mac” LeVitus
LeVitus Author of Mac OS® X Snow Leopard™ For Dummies
Spine: .8640
Get More and Do More at Dummies.com
®
Start with FREE Cheat Sheets
Cheat Sheets include
(cid:129) Checklists
(cid:129) Charts Apps
(cid:129) Common Instructions Mobile
(cid:129) And Other Good Stuff!
To access the Cheat Sheet created specifically for this book, go to
www.dummies.com/cheatsheet/office2011formac
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
(cid:129) Videos
(cid:129) Illustrated Articles
There’s a Dummies App for This and That
(cid:129) Step-by-Step Instructions
Plus, each month you can win valuable prizes by entering
our Dummies.com sweepstakes. * With more than 200 million books in print and over 1,600 unique
titles, Dummies is a global leader in how-to information. Now
Want a weekly dose of Dummies? Sign up for Newsletters on
you can get the same great Dummies information in an App. With
(cid:129) Digital Photography
topics such as Wine, Spanish, Digital Photography, Certification,
(cid:129) Microsoft Windows & Office
and more, you’ll have instant access to the topics you need to
(cid:129) Personal Finance & Investing
(cid:129) Health & Wellness know in a format you can trust.
(cid:129) Computing, iPods & Cell Phones
(cid:129) eBay To get information on all our Dummies apps, visit the following:
(cid:129) Internet
www.Dummies.com/go/mobile from your computer.
(cid:129) Food, Home & Garden
www.Dummies.com/go/iphone/apps from your phone.
Find out “HOW” at Dummies.com
*Sweepstakes not currently available in all countries; visit Dummies.com for official rules.
Microsoft®
Of f ice 2011
for Mac
®
FOR
DUMmIES
‰
0011__99778800447700887788669999--ffffiirrss..iinndddd ii 11//1144//1111 99::3355 AAMM
0011__99778800447700887788669999--ffffiirrss..iinndddd iiii 11//1144//1111 99::3355 AAMM
Microsoft®
Of f ice 2011
for Mac
®
FOR
DUMmIES
‰
by Bob “Dr. Mac” LeVitus
0011__99778800447700887788669999--ffffiirrss..iinndddd iiiiii 11//1144//1111 99::3355 AAMM
Offi ce 2011 for Mac® For Dummies®
Published by
Wiley Publishing, Inc.
111 River Street
Hoboken, NJ 07030-5774
www.wiley.com
Copyright © 2011 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 Permissions 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.
Microsoft is a registered trademark of Microsoft Corporation. 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 WITH-
OUT 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 ORGANIZA-
TION 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. FULFILLMENT OF EACH COUPON OFFER IS THE SOLE RESPONSIBILITY OF THE OFFEROR.
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: 2011920765
ISBN: 978-0-470-87869-9
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
0011__99778800447700887788669999--ffffiirrss..iinndddd iivv 11//1144//1111 99::3355 AAMM
About the Author
Bob LeVitus, often referred to as “Dr. Mac,” has written nearly 60 popular
computer books, including iPhone For Dummies, iPad For Dummies, Incredible
iPad Apps For Dummies, and Incredible iPhone Apps For Dummies for Wiley
Publishing, Inc.; Stupid Mac Tricks and Dr. Macintosh for Addison-Wesley; and
The Little iTunes Book and The Little iDVD Book for Peachpit Press. His books
have sold more than a million copies worldwide.
Bob has penned the popular Dr. Mac column for the Houston Chronicle for
the past ten years and has been published in dozens of computer magazines
over the past 16 years. His achievements have been documented in major
media around the world. (Yes, that was him juggling a keyboard in USA Today
a few years back!)
Bob is known for his expertise, trademark humorous style, and ability to
translate techie jargon into usable and fun advice for regular folks. Bob is
also a prolifi c public speaker, presenting more than 100 Macworld Expo
training sessions in the U.S. and abroad, keynote addresses in three coun-
tries, and Macintosh training seminars in many U.S. cities. (He also won the
Macworld Expo MacJeopardy World Championship three times before retir-
ing his crown.)
Bob is considered one of the world’s leading authorities on Mac OS. From
1989 to 1997, he was a contributing editor/columnist for MacUser magazine,
writing the Help Folder, Beating the System, Personal Best, and Game Room
columns at various times.
In his copious spare time, Bob heads up a team of expert technical consul-
tants who do nothing but provide technical help and training to Mac users,
via telephone, e-mail, and/or our unique Internet-enabled remote control soft-
ware, which allows them to see and control your Mac no matter where in the
world you may be.
If you’re having problems with your Mac, you ought to give them a try. You’ll
fi nd them at www.boblevitus.com or 408-627-7577.
Prior to giving his life over to computers, LeVitus spent years at Kresser/
Craig/ D.I.K. (a Los Angeles advertising agency and marketing consultancy)
and its subsidiary, L & J Research. He holds a BS in Marketing from California
State University.
0011__99778800447700887788669999--ffffiirrss..iinndddd vv 11//1144//1111 99::3355 AAMM
0011__99778800447700887788669999--ffffiirrss..iinndddd vvii 11//1144//1111 99::3355 AAMM
Dedication
This book is dedicated to my wife, Lisa, who taught me almost everything
I know about almost everything I know except technology. And to my awe-
some kids, Allison and Jacob, who love Apple technology almost as much as I
love them (my kids, not my Macs, iPhones, iPads, etc.).
Author’s Acknowledgments
Special thanks to the tireless teams at Microsoft and Edelman P.R. (you know
who you are), who worked overtime to help me turn this book around in
record time: I couldn’t have done it without you.
Thanks also to super-agent Carole McClendon, for deal-making and moral
support, yet again. You’ve been my agent for over 21 years and you’re still
the best.
Big-time thanks to the gang at Wiley — all of the editors, production, graph-
ics, marketing, sales, and other personnel who worked tirelessly to make this
book a success. You guys totally rock!
I’d also like to extend extra special thanks to Mark Chambers, for revising a
number of chapters when I was juggling three books in production at once.
Thanks to my family and friends, for putting up with me during my all-too
lengthy absences during this book’s gestation.
And last, but certainly not least, thanks to you, gentle reader, for buying this
book.
0011__99778800447700887788669999--ffffiirrss..iinndddd vviiii 11//1144//1111 99::3355 AAMM
Publisher’s Acknowledgments
We’re proud of this book; please send us your comments at http://dummies.custhelp.com. For
other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, out-
side 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 Composition Services
Media Development
Project Coordinator: Patrick Redmond
Project Editor: Pat O’Brien
Layout and Graphics: Joyce Haughey,
Acquisitions Editor: Bob Woerner S. D. Jumper
Copy Editor: Becky Whitney Proofreaders: Laura Bowman,
Rebecca Denoncour, John Greenough
Technical Editor: Dennis Cohen
Indexer: Glassman Indexing Services
Editorial Manager: Kevin Kirschner
Media Development Project Manager:
Laura Moss-Hollister
Media Development Assistant Project
Manager: Jenny Swisher
Media Development Associate Producers:
Josh Frank, Marilyn Hummel,
Douglas Kuhn, and Shawn Patrick
Editorial Assistant: Amanda Graham
Sr. Editorial Assistant: Cherie Case
Cartoons: Rich Tennant
(www.the5thwave.com)
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
Debbie Stailey, Director of Composition Services
0011__99778800447700887788669999--ffffiirrss..iinndddd vviiiiii 11//1144//1111 99::3355 AAMM