Download Wiley Office 2010 Visual Quick Tips

Index
A
CO
C
Calculator tool, 114–115
calendars, 306–309
captions, 213, 228, 344–345
CDs, copying presentations to, 184–185
cells
borders, 140–141
changing text orientation, 153
data-validation rules, 132–133
generating random numbers in, 110
joining text from separate, 113
354
AL
RI
TE
D
D
MA
data. See also text
automating, 102–103
collecting from Outlook, 222–225
color-coding, 144–145, 258–259
importing/exporting, 218–221
printed, 154
setting validation rules, 232–233
data forms, 128–129
data-validation rules, 132–133, 232–233
Database Documenter feature (Access), 242–243
database tables, 126–127
datasheets, 260–263
definitions/synonyms, looking up, 54–55
Design Checker (Publisher), 325
digital signature, 34–35
distribution lists, 270–271
documents. See also files
adding line numbers, 96–97
assigning properties, 28–29
bookmarks, 56–57
checking compatibility, 24–25
comparing, 74–75
converting to presentations, 158–159
encrypting, 32–33, 274–275
marking as final, 38–39
PDF, 26–27
recovering unsaved, 40–41
removing sensitive information, 30–31
searching through, 52–53
drafts, 40–41
Drop Caps feature (Word), 64–65
TE
GH
PY
B
backgrounds, 256–257, 334–335
bibliographies, 82–83
blog posts, 50–51
bookmarks, 56–57
borders, 70–71, 140–141
building blocks, 14–15, 46–47
protecting, 108–109
setting constraints, 125
Watch window, 106–107
certificates, 274
chart objects, 146–147
charts (Word), 78–79. See also PivotCharts
citations, 83
clip art, 202–203, 330–333, 342–343
color
background, 142–143
gridline, 138
color-coding, 104, 144–145
comments, inserting in formulas, 112
compressing media files, 180–181
conditional formatting, 144–145, 258–259
conversations (e-mail), 286–287
cover pages, 88–89
cross-references, 94–95
RI
Access (Microsoft)
adding background reports, 256–257
applying input masks, 230–231
assigning themes to forms, 252
attaching files to records, 234–235
automating tasks with macros, 248–249
changing form tab order, 253
collecting data from Outlook, 222–225
conditional formatting, 258–259
copying previous records, 229
creating mailing labels, 246–247
default values, 226
displaying summary statistics, 240
documenting databases, 242–243
exporting reports to Word, 244–245
importing data from Excel, 218–221
inserting OLE objects, 236–237
overview, 214, 250
pictures in forms, 254–255
PivotCharts, 262–263
PivotTables, 260–261
primary key fields, 227
saving filters as queries, 238–239
setting data validation rules, 232–233
setting field captions, 228
templates, 216–217
viewing object dependencies, 241
action buttons, 170–171
archiving (e-mails), 290–293
author permissions, 36–37
AutoArchive feature (Outlook), 290–291
AutoCorrect (Word), 62–63
AutoFill feature (Excel), 102–103
AutoFilter feature (Excel), 131
AutoText (Word), 60–61
E
electronic business card, 273, 298–301
e-mails. See also Outlook (Microsoft)
archiving, 290–293
electronic business cards to, 273, 298–301
encrypting, 274–275
junk, 288–289
recalling, 276–277
rules, 282–285
sending publications as, 322–323
viewing archived, 292–293
encryption, 32–33, 274–275
endnotes, 84–85
equations, 174
errors, auditing worksheets for, 116–117
Excel (Microsoft)
adding background color/patterns/images, 142–143
applying workbook themes, 136–137
auditing worksheets for errors, 116–117
AutoFill feature, 102–103
AutoFilter feature, 131
borders, 140–141
Calculator tool, 114–115
center-aligning printed data, 154
centering text across merged cells, 155
changing cell text orientation, 153
changing default font, 17
changing gridline colors, 138
chart objects, 146–147
color-code worksheet tabs, 104
conditional formatting, 144–145
creating database tables, 126–127
creating projections, 118–119
data forms, 128–129
data-validation rules, 132–133
establishing what-if scenarios, 120–121
exporting data from Access to, 219
freezing headings, 111
generating random numbers in cells, 110
Goal Seek feature, 122–123
importing data to Access from, 218–221
inserting comments in formulas, 112
joining text from separate cells, 113
naming worksheet tabs, 105
opening workbooks, 100–101
printing gridlines, 139
protecting cells, 108–109
Solver feature, 124–125
Sort dialog box, 130
Sparklines, 150–151
trendlines, 148–149
Watch windows, 106–107
wrapping text, 152
Expression Builder (Access), 232–233
F
fields (Access), 227–228
file formats, 23, 25, 206
files. See also documents
Access, 234–235
assigning passwords, 33
changing default save location, 22–23
media, 180–181
Office, 26–27
text, 316
fill patterns, 142
filler text, 76
Filter Query (Access), 239
filters, saving as queries in Access, 238–239
fonts, changing default, 16–17
footer building blocks, 44–45
footnotes, 84–85
formatting, 47, 143–145, 258–259
forms, 252–255
formulas, 112
G
Goal Seek feature (Excel), 122–123
graphics
adding captions, 344–345
adding custom watermarks, 348–349
assigning artistic effects to pictures, 336–337
clip art, 330–331
grouping objects, 340–341
online clip art, 332–333
ordering objects, 338–339
overview, 326
Picture Manager, 352–353
removing image backgrounds, 334–335
Screenshot, 328–329
turning WordArt objects into picture files, 346–347
Ungroup command, 342–343
wrapping text around, 350–351
gridlines, 138–139
growth trends, 119
H
handouts, 179
header building blocks, 44–45
headings, freezing in Excel, 111
hyperlinks, 95, 172–173
hyphenation in publications, 320–321
I
iCalendar file format, 307
images, 142, 334–335. See also pictures
Import Spreadsheet Wizard, 218–221
indexes, 90–93
input masks, 230–231
items (Outlook), 304–305
J
junk e-mail, 288–289
L
ligatures, 17
line numbers, 96–97
line spacing, 66–67
linear trends, 118
M
macros, 14–15, 248–249
mailing labels, 246–247
Map It feature (Outlook), 302–303
media files, compressing, 180–181
metadata, 30
Microsoft Clip Organizer, 330–333
355
Index
N
narration, recording for presentations, 168–169
Navigation pane (Word), 58–59
nonbreaking space, 77
notes, organizing with OneNote, 18–19
numbered lists (Word), 69
O
Object Dependencies feature (Access), 241
objects
chart, 146–147
grouping graphic, 340–341
ordering, 338–339
viewing dependencies, 241
WordArt, 346–347
Office Compatibility Checker, 24–25
OLE objects, 236–237
OneNote, 18–19
OpenType ligatures, 17
Optimize Media Compatibility feature (PowerPoint), 181
Out-of-Office reply, 278–281
Outlook (Microsoft)
adding e-mail accounts, 266–267
archiving e-mails, 290–291
categorizing items, 304–305
cleaning up folders and conversations, 286–287
collecting data from, 222–225
creating distribution lists, 270–271
creating electronic business cards, 298–301
customizing e-mail signatures, 272–273
delegating tasks, 311
encrypting messages, 274–275
filtering junk e-mail, 288–289
Map It feature, 302–303
mobile features, 303
Out-of-Office reply, 278–281
Overlay mode, 308–309
overview, 264, 296
Quick Steps feature, 268–269
recalling messages, 276–277
recording journal entries, 310
rules, 282–285
sending calendar snapshots, 306–307
subscribing to RSS feeds, 294–295
viewing archived e-mails, 292–293
Outlook Connector, 267
Overlay mode, 308–309
P
passwords, 33, 109
Paste Options gallery, 12–13
PDF documents, 26–27
permissions, author, 36–37
phishing, 289
photo album presentations, 212–213
PickList feature (Excel), 127
Picture Manager, 352–353
356
pictures. See also images
adding to presentations, 202–203
assigning artistic effects to, 336–337
organizing with Picture Manager, 352–353
removing, 353
using in forms, 254–255
PivotCharts, 262–263
PivotTables, 260–261
placeholders, 192–193
PowerPoint (Microsoft). See also presentations
adding equations, 174
adding pictures to presentations, 202–203
adding video/sound, 206–207
animating slides, 210–211
broadcasting presentations, 188–189
compressing media files, 180–181
converting Word documents to presentations, 158–159
copying presentations to CD, 184–185
creating photo album presentations, 212–213
creating self-running presentations, 175
creating speaker notes, 178
custom slide masters, 194–195
editing video, 208–209
inserting action buttons, 170–171
inserting hyperlinks, 172–173
inserting SmartArt graphics in presentations, 204–205
organizing presentation in sections, 160–161
printing handouts, 179
recording narration, 168–169
rehearsing timing, 166–167
reusing slides, 164–165
saving presentations on SkyDrive, 186–187
sending presentations to reviewers, 162–163
slide layouts, 192–193
SmartArt graphics, 204–205
speaker notes, 178
themes, 196–201
turning presentations into video, 182–183
writing on slides during presentations, 176–177
presentations. See also PowerPoint (Microsoft)
photo album, 212–213
self-running, 175
primary key fields (Access), 227
printing, 139, 179
private key, 34
projections, creating, 118–119
properties, 20, 28–29
Protect Sheet feature, 108–109
Protect Workbook feature, 108
publications. See Publisher (Microsoft)
Publisher (Microsoft)
automatically fitting text, 319
controlling hyphenation, 320–321
finding templates online, 314–315
inserting text files, 316
moving pages, 318
nudging text boxes, 317
overview, 312
saving publications for commercial printers, 324–325
sending publications as e-mails, 322–323
Q
queries, saving filters as, 238–239
Quick Access toolbar, 4–5, 114–115
Quick Steps, 268–269
R
records
adding using data forms, 128–129
attaching fields to, 234–235
copying, 229
deleting, 129
editing using data forms, 128–129
filtering, 131
sorting, 130
reports, 244–245, 256–257
Research pane (Word), 56
restricted access, 37
Review tab, 49
Ribbon, 5–11, 19
RSS feeds (Really Simple Syndication), 294–295
rules (e-mail), 282–285
S
screen capture, 328–329
Screenshot, 328–329
Selection and Visibility pane, 339
self-running presentations, 175
SharePoint, 189, 217
signatures (e-mail), 272–273
SkyDrive, 186–187
slide masters, 194–195
slides
animating, 210–211
creating custom layouts, 192–193
reusing, 164–165
writing on during presentations, 176–177
SmartArt graphics, 204–205
SmartTag icon, 69
Solver feature (Excel), 124–125
Sort dialog box, 130
sound, adding to presentations, 207
Sparklines, 150–151
speaker notes, 178
startup folders, 100–101
summary statistics, 240
T
tab order (Access), 253
table of contents (TOC), 86–87
tables, database, 126–127
tasks
automating with macros, 14–15, 248–249
delegating, 311
templates
Access, 216–217
Publisher, 314–315
text. See also data
automatically fitting, 319
centering across columns, 155
changing orientation in cells, 153
filler, 76
finding and replacing, 53
joining from separate cells, 113
translating, 48–49
wrapping, 152, 350–351
text boxes, 317
text files, 316
themes, 136–137, 196–201, 252
TOC (table of contents), 86–87
Track Changes feature (Word), 72–75
transition effects, 167
trendlines, 148–149
Tufte, Edward (inventor), 151
U
Ungroup command, 342–343
V
validation rules (Access), 232–233
video (PowerPoint), 182–183, 206, 208–209
View tab (Ribbon), 19
W
Watch window, 106–107
watermarks, 348–349
Web pages, saving Office files as, 27
what-if scenarios, 120–121
Windows Paint, 347
Windows Rights Management feature, 39
Word (Microsoft)
adding cross-references, 94–95
adding filler text, 76
adding header/footer building blocks, 44–45
adding line numbers to documents, 96–97
AutoCorrect, 62–63
AutoText, 60–61
bookmarks, 56–57
borders, 70–71
changing default font, 16
charts, 78–79
comparing documents, 74–75
converting documents to presentations, 158–159
creating bibliographies, 82–83
creating blog posts, 50–51
Drop Caps, 64–65
exporting reports from Access to, 244–245
generating indexes, 90–93
generating table of contents (TOC), 86–87
inserting cover pages, 88–89
inserting footnotes and endnotes, 84–85
inserting horizontal lines, 68
looking up synonyms/definitions, 54–55
Navigation pane, 58–59
nonbreaking spaces, 77
resuming numbering in lists, 69
searching documents, 52–53
setting default line spacing, 66–67
sharing building blocks, 46–47
Track Changes, 72–73
translating text, 48–49
WordArt objects, 346–347
workbooks, 100–101, 108, 136–137
357
Index
worksheets
auditing for errors, 116–117
color-coding tabs, 104
naming tabs, 105
protecting, 109
wrapping text, 152, 350–351
358
X
x extension, 25
XE field, 90–93
XLSTART folder, 100