Sams Teach Yourself Microsoft Office 2007 All in One

669 Pages·2007·35.75 MB·English

by  Greg Perry

Contents at a Glance
Jump in ywhere!an Find the task or technique you want to learn from this list (for example,
Center a Heading ver oMultiple Columns ). Note the number in the tab ( , in this case). And 74
then just flip through the book until you find that same number on the side of one of the pages.
Each short lesson lists any techniques that might be good to know as background ( (cid:1) ouBefore Y
Begin ) as well as other lessons that may be related or that might give you more information
( (cid:2) See Also ). Have fun!
ART IP: INTRODUCING CHAPTER 4: Adding Lists, 45 ve Saa Document in a
ables,Tand Graphics 107 erent ormatDiffF
MICROSOFT OFFICE 2007
CHAPTER 1: Start Here 3 20 Add a Bulleted List 46 About Mail Merge
21 Add a Numbered List 47 Write orm FLetters with Mail
Merge
22 able Create of a ContentsT
ART IPI: WRITING WITH 48 Print an Address on an
OWRD 23 Create an Index velope Enor a Label
24 ablesord About TW 49 ordArAdd Wt to a Document
CHAPTER 2: sLearord(cid:144)ning W
25 Create ablea Quick T
Basics 31
26 ableCreate a T ART IPII: OWRKING WITH
1 ord Set OptionsW 27 ablesManage T EXCEL OWRKSHEETS
2 Create a w NeDocument 28 Create a ver ageCoP CHAPTER 6: Getting to
3 Open an Existing Document 29 Insert Graphics into a Know Excel 203
4 ext into ype a TTDocument Document
5 extEdit T 30 w ordDrawith W 50 orkbooksorAbout Wksheets Wand
6 ve MoAround a Document 31 Add a Chart oror ksheetW 51 Set Excel Options
7 Find extand Replace T to a Document 52 Create a orw kbookNeW
8 sCheck Spelling a and Document(cid:144)Grammar CHAPTER 5: sord(cid:144)Using W 53 Open an orExisting ksheetW
Advanced eaturesF 147
9 Print a Document 54 Enter Data into ora ksheetW
32 Look Up a Definition 55 About ving MoAround Excel
CHAPTER 3: ourMaking Y 33 ranslate ord a or TWPhrase 56 About Excel ormulasF
ords Look WGood 69
34 Insert a Symbol 57 Use Sum to Add Rows and
10 About the Rulers 35 Count ourords the in WY Columns
11 About aragraph PBreaks Document 58 y Copand ve orMomulasF
absand T 36 Use Drop Caps 59 Insert and Delete Rows and
12 Apply Character ormattingF 37 Use utoCorrect Ato veImpro Columns
13 Apply aragraph ormattingPF ypingour TY 60 Edit Cell Data
14 Set Up age ormattingPF 38 About Hyphenation 61 Print ora ksheetW
15 Create a Multicolumn 39 Add atermara kW CHAPTER 7: orking Wwith
wsletterNe 40 About Building Blocks Excel Data 243
16 About Styles,Themes,and 41 our Documentormat utoFAY
emplatesT 62 Find and Replace Data
42 About Headers and ootersF
17 Use a Style 43 Add a Header or ooterF 63 About Excel Ranges
18 Use a Theme 44 Add a ootnote For an 64 Create a Range
19 emplateUse a T Endnote 65 Fill Cells with uto AFill Data
66 About Excel Functions
67 Enter Excel Functions
Contents at a Glance
68 s Function Use WizardExcel(cid:144) ART IPV: IMPRESSING 115 run a TPresentation into
69 erence RefData Outside This AUDIENCES WITH eb agesOnline PW
roksheetW PWOERPOINT 116 About Giving Presentations
70 rok Wwith Dates and Times
CHAPTER 11: Learning About
71 About Excel Limits ointerPowP 349 ART VP: ORGANIZING
WITH OUTLOOK
CHAPTER 8: romattingF 95 About Presentation Creation
roksheets Wwith Excel 273 ointerPin woP CHAPTER 14: Introducing
Outlook 431
72 reeze Row Fand Column 96 oint erPOptionsSet woP
Headers 97 Open an Existing 117 s CapabilitiesAbout Outlook(cid:144)
73 romat FCells Presentation 118 Master the Outlook Screen
74 Center a Heading vero 98 Give a Presentation 119 Set Outlook Options
Multiple Columns 99 Print a Presentation 120 Set Up an Email Account
75 Set Up age romattingPF 121 Create an Email Message
CHAPTER 12: Adding Flair
76 Attach a Comment to a Cell our Presentationsto Y 371 122 Check or w fNeMail
77 Conditionally romat FData 123 o ard and Reply orwEmailFT
100 ext into Enter aT
78 About Excel Styles,Themes, Presentation 124 Organize Email
emplatesand T
101 Find extand Replace T 125 ourselfAbout Protecting Y
79 Use an Excel Style Against Junk and Malicious
80 Use an Excel Theme 102 extAnimate T Emails
81 Use emplatean Excel T 103 tnioemplatesPre wwoeiveRTP 126 Create an Email Signature
127 o-Do Create Lista T
CHAPTER 9: Creating 104 oint youts erPLaandUse woP
roAdvanced ksheetsW 303 Themes CHAPTER 15: Making Contact
105 sChange a Presentation(cid:144) 475
82 Add a Chart to roa ksheetW
Background
83 Insert Graphics into a 128 Add a Contact
roksheetW CHAPTER 13: Making More 129 Print a Contacts List
84 roProtect ksheet WData Impressive Presentations 393 130 Create an Email Distribution
85 Combine Multiple Cells into 106 Insert a Chart into a List
One Presentation 131 Locate a Contact on a Map
86 alid Ensure Data VEntry 107 Insert Graphics into a 132 Search or fContacts and
87 Import and Export Presentation Other Outlook Data
roksheet WData 108 Add a Presentation Header
CHAPTER 16: Living with
88 About roAdvanced ksheetW or ooterF Outlook 497
Printing 109 Add Sound and Video to a
Presentation 133 vigate NaTimes and Dates
CHAPTER 10: Using Excel as
110 Add Special ects Effto a 134 Set Up an Appointment
a Simple Database 329
Presentation 135 Use RSS eedsF
89 About Excel Databases 111 Add a ransitionSlide T 136 Create and Share Electronic
90 Create an Excel Database 112 e Makan utomaticA Business Cards
91 Import Data into an Excel Presentation 137 ourself a Write NoteY
Database 113 Add Notes to a Presentation
92 Sort Excel Database Data 114 Create Presentation
93 ant Fou to ilter WSeeData Y Handouts Continues ewing on ollopagf
94 otals andable TCompute T
Subtotals
Contents at a Glance
Continued from eprevious pag CHAPTER 20: Combining
Office and the Internet 581
ART VPI: ENHANCING
155 About Office and Online
OUR YOWRK WITH OTHER Access
OFFICE TURFEESA
156 Insert eb a HyperWlink
CHAPTER 17: Making Notes into a Document
with OneNote 519 157 Insert Live Stock Prices
into an roExcel ksheetW
138 About OneNote
158 Create eb age a PW
139 s Guidew vieReOneNote(cid:144)
ordwith W
140 Create a w NeNotebook,
159 Create eb age a PW
Section,and agesP
with Excel
141 ext NotesAdd T
160 Create eb age a PwithW
142 Add wings Drato Notes tnioPrewoP
143 Add y AnData to Notes 161 Send Email ord,from W
Excel,oint,erPwoPand
CHAPTER 18: Automatic OneNote
Office 541
144 About Office Macros
145 Create a Macro
146 About Visual Basic rof
Applications
147 Customize the Quick Access
oolbarT
148 Share Office Files with Other
Applications
149 s XML About FOffice(cid:144)ile
rotamF
CHAPTER 19: Sharing Data
Among Office Applications
563
150 Use Drag and Drop to
ve MoData
151 Link to Office Data
152 Create an Office Data
rohStuct
153 verCont ord a DocumentW
ointto erPa woP
Presentation
154 Use OneNote to Enhance
Other Office Programs
eacheachTT
ourourselfselfYY
Microsoft
fi
Office
2007
llA
One in
erGreg rPy
800 East 96th eet,StrIndianapolis,Indiana,46240 USA
ii
Sams eTach ouYrself MicrosoftfiOffice 2007 Associate Publisher
All in One Greg Wiegand
Copyright ' 2007 by Sams Publishing Acquisitions Editor
All rights reserved. No part of this book shall be reproduced, stored in atesLoretta Y
a retrieval system, or transmitted by any means, electronic, mechani-
cal, photocopying, recording, or otherwise, without written permission velopment DeEditor
. from No the patent publisherliability is assumed with respect to the vin ardeHowK
use of the information contained herein. Although every precaution
has been taken in the preparation of this book, the publisher and Managing Editor
author assume no responsibility for errors or omissions. Nor is any lia- Gina Kanouse
bility assumed for damages resulting from the use of the information
contained herein. Project Editor
Christy erdHack
International Standard Book Number: 0-672-32901-8
Library of Congress Catalog Card Number: 2005938304 y CopEditor
Cheri Clark
Printed in the United States of America
First Printing: November 2006 Senior Indexer
09 08 70 4 3 2 1 Cheryl Lenser
Proofreader
rTademarks
Karen A. Gill
All terms mentioned in this book that are known to be trademarks or
service marks have been appropriately capitalized. Sams Publishing echnical EditorT
cannot attest to the accuracy of this information. Use of a term in this Dallas ordRelef
book should not be regarded as affecting the validity of any trademark
or service mark. Publishing
Coordinator
aWrning and Disclaimer Sharry Lee Gregory
Every effort has been made to make this book as complete and as Designer
accurate as possible, but no warranty or fitness is implied. The infor- Gary Adair
mation provided is on an (cid:141)as is(cid:142) basis. The author and the publisher
shall have neither liability nor responsibility to any person or entity age youtPLa
with respect to any loss or damages arising from the information Interactive
contained in this book.
Composition
Corporation
Bulk Sales
Sams Publishing offers excellent discounts on this book when ordered
in quantity for bulk purchases or special sales. For more information,
please contact
U.S. Corporate and Government Sales
1-800-382-3419
[email protected]
For sales outside of the U.S., please contact
International Sales
[email protected]
iii
Dedication
om and . Krista TPickard are Drmore than dear friends. They are like
family to Jayne and me, even though we(cid:144)ve only known them a few short
years. One runs across people such as the Pickard family rarely; we(cid:144)re so
blessed it happened om to and us. Krista, Twe love you both.
Acknowledgments
ates deserves Loretta special Ythanks for putting up with me sthroughout this book(cid:144)
writing. She was always there when I needed something. , As she an is editortop-notch,
making sure everything is in, s all are the crossed, t(cid:144)s and are the dotted. i(cid:144)Loretta,
I hope we have many projects together in the future!
Speaking of being there: Kevin , s Howard, was development this editorbook(cid:144)
outstanding! This is the first time we(cid:144)ve worked together on a book. , I themust say
book went smoothly from start to finish, and I think much of that was due to Kevin.
He was always on top of things and responded quickly when I asked, and I sure
appreciate him.
Dallas Releford had to work through all the glitches, technical problems, and outright
errors that I wrote s into first this draft. book(cid:144)Any problems that might be left are
all mine. Dallas, I(cid:144)m always thrilled when I learn . s you(cid:144)re technical my editorbook(cid:144)
I know that caring eyes are reviewing every word, while at the same time you give
me lots of freedom to say what I .want to say
Christy Hackerd kept the files moving smoothly s through production. the book(cid:144)
Christy always responded to , my she emails made quicklythe normally horrid author
review process much easier for me, , and you . I can Christyappreciate be hermy books(cid:144)
project editor from now on.
Perhaps the hardest working editor was Cheri Clark given how quickly I had to turn in
writing. I had far less time to proofread my manuscript before turning ,in each chapter
and I(cid:144)m afraid that Cheri was the one who paid the price. s I my feel job it(cid:144)to make
the editors work less, not more, but in this case I did the opposite. Kudos for Cheri for
making my sentences readable. In addition, the other staff and editors on this project
made this book better than it otherwise could be.
, I want Finallyto express massive thanks to readers who keep coming back to my
eaching you how titles. to Tdo something is nothing but a pleasure for me.
I love hearing from you, so feel free to write. Depending on my workload, I always do
ravel my and . best deadlines Tto sometimes answerpush email down to ,a low priority
but when I can respond, ou I can do. contact .com. Yme at Office07@BidMentor
.com comes (The from BidMentormy eBay domain; I teach others how to be successful
.) Of on s course, eBayworld, in some today(cid:144)valid emails get filtered out due to high-
octane spam filters that filter improperly; nevertheless, in general my email system
is highly reliable, and I should get what you send.
(cid:132)Greg Perry
vi
ant e to ou!WHear Wfrom Y
As the reader of this book, you are our most eimportant . critic Wand commentator
value your opinion and want to know what we(cid:144)re doing right, what we could do
, what areas betteryou(cid:144)d like to see us publish in, and any other words of wisdom
you(cid:144)re willing to .pass our way
As an associate publisher for Sams Publishing, I welcome ou your cancomments. Y
email or write me directly to let me know what you did or t didn(cid:144)like about this
book(cid:132)as well as what we can do to make .our books better
Please note that I cannot help you with technical problems related to the topic of this book.
e do Whave a User Ser, vices where group, I howeverwill forward specific technical questions
related to the book.
When you write, please be sure to s include title this and book(cid:144)author as well as your
name, email address, . and I phone will numbercarefully review your comments and
share them with the author and editors who worked on the book.
Email: [email protected]
Mail: Greg iegandW
Associate Publisher
Sams Publishing
800 East 96th Street
Indianapolis, IN 46240 USA
Reader Services
isit Vour website and register this .samspublishing.com/register book for at www
convenient access to any updates, downloads, or errata that might be available for
this book.
Introduction
s Office Microsoft products Corporation(cid:144)have an installed base of more
than 25 million licensed users. More than 90% of the Fortune 500 compa-
nies use Microsoft Office. Microsoft completely redesigned the Office inter-
face when it produced s Office goal 2007. was Microsoft(cid:144)to make the
Office 2007 interface easier than ever to use, as well as more integrated
among other applications and the Internet.
By redesigning the interface, Microsoft in effect did away with menus and
toolbars and replaced the interface with an ever-changing ribbon across
the top of the o Office many product Office screens. old-timers, Tthe rib-
bon was a bold move(cid:132)Microsoft did away with the interface we(cid:144)ve been
using for what . seems At like first, foreverthe ribbon might frustrate you.
ou(cid:144)ll find s yourself that Ywondering, option (cid:141)Where(cid:144)I need?(cid:142) If you look
up at the ribbon, you(cid:144)ll probably find it! The ribbon changes depending
on what you(cid:144)re doing at the time. If you need a feature that you used to
have to hunt through menus to locate, you(cid:144)ll probably find it on the rib-
bon. Office pros are happily finding that after a session or two with Office
2007, they wonder how they ever worked efficiently with the clunky
menus and toolbars that used to be there.
Brand-new Office users may not ever know how well they have it with the
new interface. The ribbon makes it far simpler to master Office than the
menu system did. In addition, the graphical features of Office 2007, espe-
cially when used with a indows ista(cid:133)compatible WVcomputer with Aero
graphics capabilities, make learning Office 2007 a pleasure(cid:132)and a quick
pleasure at that.
iv Introduction
ou probably are Yanxious to get started ake with just Office a 2007. few Tprelimi-
nary moments to acquaint yourself with the design of this book, as described in
the next few sections.
Who Should Read This Book?
This book is for both beginning and advanced Office 2007 users. Readers rarely
believe that lofty claim, for good reason, but the design of this book and the
nature of Office 2007 make it possible for this book to address that wide of an
audience. The reason is simple: The book you hold in your hands approaches
Office 2007 the way that most users approach Office 2007 in that a task needs to
be done and this book shows you how to do it. All major and most minor Office
2007 features are not taught from a theoretical viewpoint; you t don(cid:144)read para-
graph after paragraph of background before learning how something works.
Instead, you see how something works in a step-by-step lesson. For example, if
you want to create an Excel graph, you(cid:144)ll jump to the task in this book that walks
you through the creation of an Excel graph. Why bother with a background of
color palettes when you need a simple pie chart?
sredaeRrailimafnuhtiwdesab(cid:133)swodniWstnemnorivnelliwdnifytnelpfo-cudortni
rotypleherehtahtsgnirbmehtylkciuqpuot.deepssihTkoobswohsuoywohot
odkrownieciffO,7002sallewsawohoteganamynamfoehtdesab-ternetnI
eciffO7002stnemeletahtuoydeenniredrootesueciffO7002nis(cid:144)yadot,enilno
detcennoc.dlrowfIuoyerawenoteht,ternetnIsihtkoobsplehuoytegdetratsdna
swohsuoywohotenibmocehtternetnIhtiweciffO7002otniagygrenysmorf.htob
, this Quite book simplytalks ot newcomers without talking down to them.
This book also brings those who presently use a Microsoft Office product up to
speed with ou Office face 2007. a Ymighty dramatic interface change, as the pre-
ceding section explained. ith Wthe fundamental Office understanding you already
have, you will appreciate the new features and added power of Office 2007, and
you(cid:144)ll learn how to maximize your use of the Office 2007 ribbon to get your work
done .quickly and easily
What This Book uoDoes for Y
Although this book is not a complicated reference book, you(cid:144)ll learn almost every
aspect of Office 2007 from a s task-based, . point typical Office of user(cid:144)2007view
includes many advanced technical details that most users never need, and this
book does not waste your time ou with want those. to Yget up to speed with Office
2007 now , and this book helps you fulfill that goal.
Those of you who are tired of the mass of quick-fix computer titles cluttering
s shelves will today(cid:144)find a welcome reprieve here. This book presents both the