D

d notation (days), 529

dashboard. See Ribbon

dashed lines, 636

data

alignment. See alignment

editing, shortcuts, 936

formatting, shortcuts, 940

Data And Model cell style category, 279

data bars, 285, 288

data entry

### (number signs), 140

automatic completion. See AutoComplete feature

cell ranges and, 140

commas, 138

constants, categories of, 136

currency values, 138

data series. See data series

decimal points, 138

displayed values, 139–140

E and e (exponents), 138

editing entries, 145–147

Enter key behavior, 136

error correction. See AutoCorrect feature

error values, 136

fractions, 139

functions, list of, 137

insertion points, 136

keyboard shortcuts, 137, 937–938

logical values, 136

maximum cell size, 139

negative numbers, 138

numeric and text combinations, 142–143

numeric values, 138, 139

overlapping adjacent cells, 141

percentages, 139

precision, 139, 140

scientific notation, 138, 139

special characters, 138–139, 142

symbols, 143–144

text alignment, 142–143

text values, 138, 141, 142

text wrapping, 141

too long for cell, 139, 141

types of data, 136

underlying values, 139–140

undoing entries, 145–147

very large or small numbers, 139

Data Interchange Format (DIF) file format, 72

data labels in charts, 623–624, 657

Data menu commands and options, 918–920

data points

adding with mouse actions, 654–655

editing data sources and, 654

labeling, 652–653

selecting, 634

switching assignments in charts, 618–619

data recovery. See recovering data

data series. See also AutoFill feature

adding or deleting from charts, 654–658

AutoFill feature, 216

chart legends and, 623

copying cells to fill, 217

data labels for, 623–624

data size limit, 212

dates and times, 214

decreasing values, 211

distributing long entries, 217–218

dragging fill handles, 211–213, 215

enabling fill handles, 209

error bars for, 661–662

extending formatting, 219–220

extending series, 214

fill handles, 204, 209, 211–213, 215

filling across worksheets, 217

filling from custom lists, 218–219

formatting, 219–220, 653

incremental values, 216

justifying long entries, 217–218

keyboard shortcuts, 217, 938

linear values, 215

linking to worksheet cells, 623

markers for, 653

moving averages and trendlines, 660–661

multiple series charting, 653

series of dates, 523–526

Shape Styles feature, 630

structured references and, 460–461

switching assignments in charts, 618–619

data sets, extracting samples from, 553

data sources

chart legends and, 623

charts and, 654–658

creating for queries, 760

creating PivotCharts from, 743–744

creating PivotTables from, 715–719

external data. See external data

querying. See Query

refreshing PivotTables, 721

[#Data] specifier, 458

Data tab commands and options, 911, 917, 918–919, 920, 923

data tables (sensitivity tables). See also tables

editing, 588

with multiple formulas, 585–586

with one input variable, 583–585

with two input variables, 586–587

#Data tag, 704

data types in SharePoint tables, 819–820

data validation

Excel Web Access and, 821

finding, 131–132

jumping to, 133

pasting settings, 187

in shared workbooks, 792

data visualizations in Excel Web Access, 821

databases

Access, 746, 749–750, 759

fields, 122

importing data from, 746

new and changed features, 11

querying, 759

records, 122

date filters, 688, 730

DATE function, 957

dates and times

1904 system, 522

2029 magic crossover, 523

abbreviations for, 528, 529

AutoFill feature, 216

chart axis labels, 645, 648–651

chart base units, 649–651

CONCATENATE function and, 507

current, 523, 531–532

customizing formats, 527–530

default, 522

entering, 522–526

entering with macros, 833

exact dates or months, 533

expiration dates for access, 805

filling data series, 214, 216, 523–526

filtering, 687, 688, 730

formatting, 526–530, 940

formulas and functions, 472, 530–534, 957

grouping items by, in PivotTables, 738–741

headers or footers, 410

keyboard shortcuts, 937–938

overview, 521–522

ranges and conditional formatting, 287

serial values of, 521

sorting and, 682–683

switching operating systems and, 522

transaction example, 472

DATEVALUE function, 472, 533, 957

DAVERAGE function, 957

DAY function, 532–533, 957

days

as chart base units, 649

d, dd, ddd, dddd notations, 529

DAY function, 532–533, 957

DAYS360 function, 957

DAYS360 function, 957

DB function, 542–543, 957

dBase

formats, 754

querying files, 759

DCOUNT function, 957

DCOUNTA function, 958

dd, ddd, dddd notations (days), 529

DDB function, 542–543, 958

Debug.Assert method, 864, 865

debugging

Excel, 23–24

macros and functions, 859–869

row and column differences, 135–136

run-time errors, 866–869

worksheet inconsistencies, 135–136

Debug.Print method, 866

DEC2BIN function, 958

DEC2HEX function, 958

DEC2OCT function, 958

decimal fractions, 467, 545

decimal points

automatic insertion, 209, 211

data entry, 138

DOLLAR function, 503

formatting, 301

truncating numbers to, 502

declaring variables, 861–862

declining balance depreciation, 542–543

decreasing

decimal places, 301

indents, 317

defaults

currency, 522

dates and times, 522

file formats, 54, 56, 57–58

footer and header styles, 409

formatting, 298

IRM setting, 805

Quick Access Toolbar settings, 94

saving to default folder, 51

settings, 522

Solver add-in settings, 608

sorting sequence, 682

table headers, 670

Trust Center settings, 103

defining

cell names, 443–444

scenarios, 590–592

DEGREES function, 958

degrees of freedom, 561

Delete menu, 198–202

deleting. See also clearing; removing

array assignments, 469

buttons on toolbars, 85, 94

cell names, 444

cell styles, 284

cells, 198–202, 203–204

cells in linked workbooks, 476–477

characters and spaces in text, 503, 504

columns, 198–202

comments, 252

cropped portions of pictures, 373

data labels, 652

data series in charts, 655

data table results, 588

duplicate filtered records, 698–699

filters, 686, 762

formulas in linked workbooks, 476–477

hyperlinks, 192, 876, 880

keyboard shortcuts, 936, 941

links to objects, 888–889

links to workbooks, 476

portions of formulas, 435

query criteria, 773

query fields, 767

rows, 272

scenarios, 593

SharePoint tasks, 813

table formatting, 706

tables from queries, 766

undoing deletions, 200

worksheet segments with graphics, 390

worksheets, 946

delimited text files, 71, 72, 750, 751

delimiter characters, 751–752

DELTA function, 958

demoting shapes in SmartArt, 361

dependent workbooks, 473–476

dependents

dependent formulas, 937

indirect, 247

jumping to, 135

overview, 246

tracing, 247–248

depreciation functions, 541–543

depth, applying to shapes, 380

depth axes, 626, 651–652

derivatives in Solver add-in, 608

Descriptive Statistics tool, 568–569

Design tab commands and options, 270–271, 919, 920, 921, 924–925

design-time error tools, 859–866

Developer tab

commands and options, 911, 912, 917, 920

macro recorder, 830

DEVSQ function, 958

DGET function, 958

dialog boxes

collapsing, 447

displaying with custom functions, 851

keyboard shortcuts, 935–936

launchers, 910

live previews in, 375

selecting cells while open, 447

differences, calculating in PivotTables, 733

digital signatures, 112–114

Dim statements, 861–862

dimensions in PivotTables, 713

direct cell manipulation, 192–194, 455

direct editing, 209

direction of gradient fills, 640

DIF (Data Interchange Format) file format, 72

disabling. See turning features on or off

DISC function, 546–547, 959

discontiguous ranges, 349, 518, 655–658

DISCOUNT function, 847–848, 849–851

discount rates, 536, 546–547

Discrete distribution, 575, 578

disk space requirements for files, 53

display text for hyperlinks, 875

display triggers in AutoComplete, 459

displayed values

compared to underlying, 139–140

searching and replacing, 222

displaying. See also hiding

active cells, 429

AutoCorrect options, 228

available external data sources, 745–746

calculated fields and items, 737–738

calculation steps, 242

chart types, 617–618

comments, 252, 415

dialog boxes with custom functions, 851

display text for hyperlinks, 875

embedded objects, 368

formula bar, 96

formulas, 43, 98–100, 454

functions, 439–440

hidden file extensions, 53

hidden folders, 48

hidden graphics, 393

hidden Quick Access controls, 89–90

hidden rows or columns, 944

hidden workbooks, 176

hyperlinks, 191

iteration results, 609

keyboard shortcuts, 944

links to comments, 252

lists of common typing errors, 227

long formulas, 43

Mini toolbar, 95

modules in Visual Basic Editor, 833–835

objects, 388

open worksheets on the taskbar, 30

outline levels, 256–257

pasting options, 210

PivotTable Field List window, 720

PivotTable value details, 741–742

scenarios, 592–593

side-by-side worksheets, 18, 169, 170–171, 798–800

smart tags, 229

SmartArt text pane, 360

views of windows, 173–175

Watch Window, 865

workbook options, 98, 176

XML files, 755

DISTDEV function, 960

distributing shapes evenly on worksheets, 392–393

distributing workbooks or tables. See also collaboration

comparing and merging work, 798–800

publishing on SharePoint sites, 818–820

distribution, random number, 575, 576–579

distribution bins, 570, 571, 572

distributions of data

rank and percentile functions, 555–558

sample and population functions, 558–559

statistical functions, 553–555

#DIV/0! error, 438, 587, 682, 696

divergence, 465

division, 499, 696

division sign (/), 427, 458

DMAX function, 959

DMIN function, 959

document depositories. See collaboration; SharePoint Services

Document Information panel, 815

Document Management Server, 809

Document Management task pane, 811–815

Document Workspace panel, 817

document workspaces. See workspaces

Document Writer, 423–424

documenting macros and custom functions, 851–852

documents and files

automatic backup, 58

browsers and, 65

case sensitivity of names, 52

checking in or out, 810–811

compatibility with older versions, 54–56

copies of, 65

corrupted, repairing, 65, 66–67

creating with hyperlinks, 873, 877–878

default folders, 51

disk space requirements, 53

distributing by e-mail, 800–802

document workspaces, 816–818

downloading or uploading to SharePoint sites, 807–809

embedding, 367–368, 882, 886–887

exporting, 68, 71–72

file extensions, 53

file formats, 51–52, 56

file sharing. See collaboration

file size, 882, 896

hyperlinks to, 873–874, 875–878

hyperlinks to locations within, 874, 877

importing, 68–69, 71–72

"in use," 789–790

information about, 815

linking data to, 882, 886–887

linking workbooks to, 476

links to SharePoint sites, 815

lists of, 63–64

Macintosh, importing, 69

merging into masters, 798–800

names in headers or footers, 410

naming, 52–53

opening, 63–66

opening related, 814

password protection, 59

paths in headers or footers, 410

printing to, 418–419

protecting with IRM, 803–806

read-only, 65

recently opened, 63

saving, 51–52, 56, 60–61

security, 59, 110–114, 803–806

sharing outside Excel, 70–72

shortcut menus and, 64

status information, 812

summary information, 60

versions of, 808

workspaces and, 60–61

DOLLAR function, 503, 959

dollar sign ($), 138, 297–298, 429–430, 458

DOLLARDE function, 545, 959

DOLLARFR function, 545, 959

dollars. See also currency

converting fractional pricing, 545

functions, 503, 545, 959

dots per inch (dpi), 373, 404

double-clicking chart elements, 634

double declining balances, 542–543

doughnut bites in charts, 635, 637

downloading

checked-out documents, 810

diagnostic files, 109

documents from SharePoint sites, 807–809

dpi (dots per inch), 373, 404

DPRODUCT function, 959

DQY files, 763, 778

Dr. Office, 80–81

draft printing, 416

dragging

enabling drag-and-drop, 209

PivotTable fields, 721

shapes, 348

drawing

constrained shapes, 347–348

entering and exiting drawing mode, 346

freehand lines and polygons, 348–351

Drawing Tools tab commands and options, 911, 912

DSTDEVP function, 960

DSUM function, 960

dual processor support, 10

duplicate names, 284, 446

duplicate records, 698–699

duplicate table data, 668

duplicate views, 287

duplicating. See copying

duration, investment, 548–549, 960

DURATION function, 548–549, 960

DVAR function, 960

DVARP function, 960

dynamic hyperlinks, 880

dynamic properties, 62