E

E and e (exponents), 138

e-mail

creating document workspaces via, 817

creating messages with hyperlinks, 874, 878–879

distributing files by, 800–802

dpi resolution of pictures and, 373

sending, 808, 812

earlier versions of Excel

Compatibility mode and tables, 670

finding commands and options in Excel 2007, 907–925

natural language formulas in, 456

recalculations and, 461

shared workbooks and, 792

using older PivotTable features, 721

EDATE function, 533, 960

Edit menu commands and options, 909–910

editing. See also collaboration

arrays, 469

AutoComplete, enabling, 210

cell drag-and-drop, 209

cell names, 444–445

cell range finders and, 208

cells, 207–209

chart axes, 625–626

chart axes labels, 626–627

chart data sources, 654–658

chart legends, 623

chart titles, 621–622

checking documents in or out, 810–811

clip art keywords, 363

columns in Query, 776

combining changes to multiple workbooks, 798–800

comments, 252

compared to formatting, 266

curves, 351–352

data entries, 145–147

data tables, 588

decimal points, 209, 211

direct, 209

direct cell manipulation, 192–194

disabling, 208

embedded objects, 883

Enter key behavior and, 208

extending formatting, 209

fill handles and, 209

formula bar and, 207–208, 242

formulas, 435–437, 463–464

graphics objects, 210

highlighting changes, 794–797

hyperlinks, 192, 880

keyboard shortcuts, 936

links between workbooks, 475–476

links to objects, 888–889

macros, 832, 841–843

mouse zooming and, 210

multiple users in same workbook, 790–798

multiple worksheets, 236–241

names of graphics, 388

numeric separators, 210

options for, 208–210

PivotTable fields, 716–721

in place, 883, 886

points on shapes, 350–351

queries, 763–764

scenarios, 591, 593

shapes, 350–351

SharePoint tasks and, 813

smart tag menu and, 210

table styles, 707–709

tables in Word, 896

tables on SharePoint sites, 818–820

Track Changes feature, 794–797

worksheet objects in Word, 894–895

worksheets, 236–241

EFFECT function, 960

effects

3-D, 378–381

applying, 275–276

examples of, 398–401

pictures and, 370

Shape Styles feature, 631

shapes, 371

WordArt, 356–358

elapsed time, displaying, 526, 528–529

elements, XML, 757–758

EMBED formula, 882

embedding

borders on embedded items, 882

captured images of worksheets, 395–397

charts in Word, 901

compared to linking, 881–882

compared to static pasting, 882–883

creating tables from scratch in Word, 897–899

data from the Clipboard, 883–886

editing embedded objects, 883, 886

formatting embedded objects, 384–386

icons for objects, 886

Microsoft Office Excel Worksheet Object format, 894–895

multipage documents, 882

Object command and, 886–888

objects, 366–368

smart tags in data, 230

empty cells. See blank cells

enabling. See turning features on or off

encryption, 177–178

End Function statement, 847, 851

End key, 930

End mode, 127, 942

End Sub statements, 847

End With statements, 843, 860

Enhanced Metafile format, 894, 895–896

enlarging. See resizing; zooming

Enter key, 136, 208, 930

entering data. See data entry

EOMONTH function, 533, 961

equal sign (=), 427, 458, 478, 840

Equation Editor, 887

ERF function, 961

ERFC function, 961

Err.Number property, 868

error bars in charts, 661–662

error handlers, 867–869

error messages. See alerts

error trapping, 854, 867–869

error values, 136, 437–438, 510

errors

avoiding with ISERR function, 511

broken links, 889

chart error bars, 661–662

circular references, 464–466

compatibility issues, 55

correcting. See AutoCorrect feature

debugging in VBA, 859–869

displaying with Error Checking feature, 242–243

error flags in cells, 582

error handlers, 867–869

ERROR.TYPE function, 510

formula error values, 437–438

ignoring flags, 582

PivotTables, 723

printing, 415–416

qualified and unqualified structured references, 459

run-time, 866–869

sorting and, 682

tracing, 249–250

trapping, 854, 867–869

XML files, 756

ERROR.TYPE function, 510, 961

Escape key, 930

estimates, 608

Euro Currency Tools add-in, 549–551

EUROCONVERT function, 551, 961

evaluating formulas, 243–245

EVEN function, 501, 961

EXACT function, 505, 961

exact matches in Query, 770–772

 Exams.xlsx file, 432

Excel

accessing functions in VBA, 851

activating, 21–22

Compatibility mode and tables, 670

debugging, 23–24

enabling macro execution, 828

finding commands and options, 907–925

as mail-merge source, 901–904

natural language formulas in, 456

older PivotTable features and, 721

recalculating older files, 461

registering, 21–22

server version of, 820

sharing older workbooks, 792

SRs (service releases), 22–23

starting, 21–22

unsupported features in Excel Web Access, 821

updating, 22–23

using data in Word, 891–899

Excel 97–2003 (XLS) file format, 57, 830

Excel 2007 (XLSX) file format, 56

Excel Add-In (XLAM) file format, 57

Excel Binary Workbook (XLSB) file format, 56

Excel Macro-Enabled Template (XLTXM) file format, 57

Excel Macro-Enabled Workbook (XLSM) file format, 56

Excel Options dialog box

Advanced category, 97

alerts, 210

AutoComplete, 210

cutting, copying, and sorting, 210

decimal points, 209

direct editing, 209

Enter key, 208

extending formats, 209

fill handles, 209

formulas, 98–100

pasting, 210

percentages, 210

Popular category, 97

settings, 35

system separators, 210

workbook display, 98

zero values, 100

zooming, 210

Excel Services, 820–823

Excel Template (XLTX) file format, 56, 57

Excel Web Access, 820–821

Excel Web site, 82

Excel Worksheet Objects, 894–895

executing

macros, 827–830

queries, 772

existing data connections, 745–746, 779

Exit Function statement, 854

EXP function, 962

expanding

display of formulas, 454

field headings, 724

PivotTable source data, 715

tables, 671–672

 Expense Report.xltx file, 340

expiration dates for access, 805

explicit intersection, 452–453

exploits, 107

EXPONDIST function, 962

exponential curve functions, 562, 566

exponential number formatting, 305–306, 940

exponential regression, 566–567

exponential trendlines, 660

exponents (E, e), 138

exporting. See also embedding; linking objects

compatibility with older versions, 72

Internet Explorer data to Excel, 785

mail merge data into Word, 901–904

opening exported data, 68

saving exported data, 68

tables to SharePoint Services, 818–820

tables to SharePoint sites, 818–820

text files, 71–72

XML files, 755–759

expressions as arguments, 491

Extend Selection mode, 127

extending

formatting, 209, 219–220

outlines, 255

selections, 127, 938–939

series of dates, 525

tables, 671–672

eXtensible Markup Language. See XML (extensible Markup Language)

external content, Trust Center and, 107–108

external data

Access tables, 749–750

importing, 750–755

linking to, 881–882

mapping XML elements to columns, 757–758

overview, 745–748

passwords and, 748

pasted data links, 885

publishing tables to SharePoint sites, 818–820

querying. See Query

refreshing, 747–748

text files, 750–755

Text Import Wizard, 750–755

Web queries, 779–785

XML files, 755–759

external references

converting to formulas, 476

defined, 430–431

in formulas, 473–477

extracting filtered rows, 697–698

extrapolating trendlines, 564–565

extrusions on shapes, 379–380

eyedropper, 224