E
Edit Data button (PowerPoint), 467
Edit Formatting Rule dialog box (Excel), 334-337
Edit Name dialog box (Excel), 284
Edit Relationships dialog box, 817
Edit Shape button (PowerPoint), 476
Edit WordArt Text dialog box, 909
editing meetings, 697
Effect Options button (PowerPoint), 481
effects. See text effects
Effects button (PowerPoint), 427
effects schemes, 427
efficiency, improving, 6, 227
e-mail accounts, 614
e-mail addresses for contacts, entering, 650
e-mail attachments. See attachments
e-mail etiquette, 635
e-mail headers. See headers, e-mail
e-mail messages. See also drafts; sent messages
addressing, 605, 658
Bcc field, 658
calendar items, creating from, 688
Cc field, 658
creating, 605
entering text, 607
flagging for follow-up, 718, 719
HTML format, 603
mail merging, 617
opening, 619, 626
personalizing, 603
Plain Text format, 603
recalling, 641
replacing, 641
resending, 641
RTF format, 603
saving as drafts, 604-605
scrolling through, 629
tasks, creating from, 718-719
unread, 619
viewing text of, 619
e-mail signatures. See signatures
e-mailing link to OneNote notebook, 546
embedded datasheets. See subdatasheets
embedded fonts in Word, 21
embedding fonts in publications, 889
Enable Content button, 759
Encarta dictionary, 270
enforcing referential integrity, 817
enhanced handouts, 501
entering data series, 256
entering Excel data, 255-256
entering ranges in formulas, 295
entering text, 41, 64
in OneNote, 565, 572
on Outline tab, 390
in Slide pane, 390
in text boxes, 394
equal sign (=) in formulas, 286
erasing slide markup, 511
errata page, xxv, xxxiii
Error button (Excel), 301
Error Checking dialog box (Excel), 302, 305
error codes
#####, 301
common, summarized, 301
#DIV/0!, 301
#NAME?, 301
#REF!, 301
#VALUE!, 301
error messages
adding icons to, 365
Cancel button, 366
displaying default, 366
displaying with validation rules, 363, 364
Retry button, 366
errors, Excel
auditing, 300
changing settings for, 302
deleting, 390
displaying custom messages, 298
displaying in dialog box, 302, 305
finding information about, 301, 305
ignoring, 302
ignoring in AGGREGATE function, 358
messages, 298
reference, 301
settings, changing, 302
tracing dependents to identify, 301
tracing precedents to identify, 301
ways to reduce, 412
errors, spelling, 42, 88-90
etiquette, e-mail, 635
Evaluate Formula dialog box (Excel), 303, 306
events
creating, 688-689
defined, 689
entering details, 689
private, 682
recurring, 689, 690
examining formulas, 303, 306
Excel 2007
data bars in, 334
icon sets in, 335
Excel 2010
data bars in, 334
ease of use, improving, 227996 Edit Data button (PowerPoint)