E

E/e (exponent), 354

Ecma International, 1190

Edit Hyperlink dialog box, 955

Edit Links dialog box, 441

Edit Relationships dialog box, 884

editing.

See also revising documents;

undoing

alerts, 746–747

backgrounds and watermarks, 261–262

cells, 361

external links, 441–442

footers, 227

formula name references, 410

formulas, 401–403

hyperlinks, 956–957

linked calendars, 742

outlines, 248–251

as aid to document, 237–238

passwords

changing, 70

presentation, 593

photo albums, 623

placeholder logo file, 1171–1172

presentation comments, 589

relationships, 884

report labels, 1047–1049

resolving proposed edits, 330–334

restricting revision, 311–312

SharePoint files in Outlook, 754–755

SmartArt graphics, 556

tracking changes while, 325–327

UserForm controls, 1136

Web Parts, 84

XML

using XML Notepad, 1147–1148

in Visual Studio, 1147

XML documents, 1164–1175

custom styles, 1170–1171

picture editing, 1171–1172

text, 1165–1167

e-mail.

See also messages;

Microsoft Outlook

adding files to SharePoint via, 757

attachments

encrypting outgoing, 699, 718

previewing, 636

security for, 660

default search folders for, 676–677

extensible support in Outlook for, 643

Hotmail accounts, 642, 657

HTTP-based, 642

improvements to Office, 636–637

Internet, 641

invitations to Live Session via, 129

junk filtering, 15, 637

mail client applications for, 662

managing Outlook mailboxes, 684

messages

adding notes to received, 679

encrypting, 662, 699, 714–719

flagging, 678–680

saving in search folders, 675

postmarking, 637

receiving voice messages and faxes, 637

security

recognizing phishing schemes, 71–72

setting content blocking, 688–689

setting up, 699–700

sharing

audio and video recordings, 111

notes, 130

working with data offline, 651–653

E-Mail Security page (Trust Center), 699–700, 701, 703

Enabled text box property, 994–995

enabling. See turning on/off

Encrypt command, 718

encrypting

Groove’s use of, 135

obtaining public key from public CA, 717

outgoing messages and attachments, 699, 702, 718

Outlook messages, 662, 714–719

swapping certificates with message recipient, 715–716

workbooks, 391–392

encryption algorithms, 702

End key, 361

End Sub statements, 1080, 1086–1087

Enforce Referential Integrity box (Edit Relationships dialog box), 884, 885

Enter button (formula bar), 353

Enter key, 352

equal to (=) operator

as comparative operator, 869

as logical operator, 444

starting formula with, 353

equations in PowerPoint, 600

Equifax, 708

error handlers

about, 1118

commenting out in macros, 1125

creating, 1124–1126

error messages.

See also alerts;

warning messages

circular reference, 430, 432

common macro, 1122–1123

digital signature not trusted, 705

generating custom field value, 868

#NAME? error, 460

natural-language formula conversion, 422

trusted location’s remote or network path location not allowed, 607

validation rules with missing validation text, 865

ERROR.TYPE function, 474

error values

about, 352

defined, 403

types of, 404

errors

avoiding Excel formula, 475

common VBA macro, 1122–1123

 customUI.xml file, 1182

debugging VBA macro, 1123–1124

field name, 859

finding when ZIP package won’t open, 1162

handling, 1118, 1124–1126

help for macro, 1127

locating XML syntax, 1163

#NAME?, 460, 466

numeric value, 476

preventing input, 874

trapping individual VBA, 1126

VBA property, 1090

XML syntax, 1148

EVEN function, 465

event triggers, 971

events

accidentally adding UserForm, 1136

form, 970

sequencing in object-oriented systems, 971

VBA, 1131–1133

EXACT function, 468

Excel, 339–518.

See also formulas;

workbooks;

worksheets

active cells

about, 344

insertion point for, 352

moving without losing selection, 350

redisplaying, 395

data connection libraries, 6

data entry, 352–363

creating long text values, 357

editing and undoing entries, 361–363

making entries in range, 360

numeric text entries, 358–359

preventing confusion of fractions and, dates, 355

text wrapping, 357

text-alignment prefix characters, 358–359

data storage in, 341

Document Inspector for, 62–65

finding errors when unable to open ZIP package, 1162

formulas

cell precedents and dependents for, 351

circular references in, 430–432

incorrect calculations in, 356

functions in, 404

inserting charts in PowerPoint file, 580

keyboard modes for, 343

keyboard shortcuts for, 344, 353

launching add-ins from Formulas tab, 445

modifying display of individual windows, 387–389

naming multiple selections, 350

navigating in regions, 341–344

numeric precision in calculations, 433

Objects folder in, 1084

Open XML Formats requirement for sheets folder, 1156

passwords in, 378

PivotCharts, 516–518, 1003

PivotTables, 485–516

about, 485–489

Classic PivotTable Layout option in, 495

creating, 489–493

field filtering in, 502–505

filtering categories on, 488–489

formatting, 497–498

illustrated, 493

quick create commands, 1003

rearranging fields in, 493–495

totals and subtotals for, 498–501

Ribbon in, 7

saving workspace in window, 381

selecting data in, 344–352

smart tags, 362

tables

copying into PowerPoint from, 538

using in PowerPoint, 602–603

tabs on Ribbon, 28–29

undoing pasted data in, 416

updated features of, 13

use of Open XML Formats, 10–11

viewing

libraries or lists using query, 82

ZIP packages in, 1150

workbooks

hiding and protecting, 389–392

multiple, 379–385

opening multiple windows in, 385–389

worksheets

inserting in presentations, 538

managing, 363–366

protecting, 372–379

recalculating, 427

showing in VBE, 363

viewing, 366–372

XML customization hidden on opening, 1182

XML prefix for, 1145

Excel Options dialog box, 35, 387–388

Excel Services, 6, 13

Exchange Server

accessing from Outlook via HTTP, 658

integrating messaging with Outlook, 641

sending encrypted messages to recipient on, 715

working offline with Outlook data, 651–653

expanding

Chat tool, 145

notebooks, 94

outlines, 238, 244, 249

subdatasheets, 941, 943–946

width of Navigation Pane, 789

explicit intersection, 419

exponent (E/e), 354

exporting

certificates, 693–694

contacts from SharePoint site, 738–739

Groove notes, 161–162

private keys, 695, 696

VBA code modules, 1127

Expression Builder

developing expressions in, 927–931

illustrated, 927

usefulness of, 931

expressions

assigning field names and captions in, 933–934

brackets around field names in, 918

defining arithmetic, 920–926

developing in Expression Builder, 927–931

differences between two Date/Time data types, 921–926

using as argument in function, 457

using in queries, 918–926

viewing calculations in Datasheet view, 930–931

ExprN default field name, 918, 933

Extensible Markup Language. See XML (Extensible Markup Language)

external content

about, 51

accessing, 605, 686, 687

adding to shared workspace library, 83

blocking, 605, 686–689

managing connections to, 47

sending file and Web notes to notebook, 107

setting privacy options for downloads, 59–60

unblocking, 605

Web beacons and links to, 686

External Content area (Trust Center), 47

External Data tab (Access), 785–786

external references, 396–397