D

Daily Dose of Excel web site, 772

data bars, 532-535

Data Bars command, 528, 533

data bars conditional format, 532-535

data entry, 19

Data Field Settings dialog box, PivotTable Tools, 493-494, 501, 510, 526

data fields, 490

data labels, links to, 449

Data Labels option, Chart Tools, 449

Data Table command, 358, 463-464

data types, 649-650, 689

data validation

creating drop-down list, 558-559

rules, using formulas for, 559-562

specifying validation criteria, 555-556

types of validation criteria, 556-558

Data Validation command, 89

Data Validation dialog box, 555-556, 560, 687

database access, 27-28

database functions, 112

Date & Time drop-down list, 147, 164

date comparison, summing values based on, 207-208

Date data type, 650

DATE function, 147, 149, 151, 156, 160, 163, 165-166, 205, 350, 355, 729

Date number format, Options dialog box, 749

Date option, Settings tab, 557

DATEDIF function, 147, 155, 346

dates and times

calculating next day of week, 704

calculating the next Monday, 703-704

date serial numbers, 140-141

date-related functions

calculating dates of holidays, 162-164

calculating number of days between dates, 153-154

calculating number of work days between dates, 154-155

calculating number of years between dates, 156

calculating person's age, 156-157

converting non-date string to date, 153

converting year to Roman numerals, 166

counting occurrences of day of week, 160-161

determining date of most recent Sunday, 159

determining date's quarter, 165

determining day of week, 158

determining day of year, 158

determining first day of week after date, 159

determining last day of month, 165

determining nth occurrence of day of week in month, 159-160

determining whether year is a leap year, 165

displaying any date, 151

displaying current date, 150

expressing date as ordinal number, 161-162

generating series of dates, 151-153

offsetting date using only work days, 155-156

dates before 1900, 705-706

entering dates, 141-143

entering times, 144-145

formatting, 145-147, 762-763

overview, 654

problems with dates, 147-149

time serial numbers, 143-144

time-related functions

adding hours, minutes, or seconds to a time, 172-173

calculating difference between two times, 170-171

converting between time zones, 173-174

converting decimal hours, minutes, or seconds to a time, 172

converting from military time, 171-172

displaying any time, 167-168

displaying current time, 166-167

rounding time values, 174-175

summing times exceeding 24 hours, 168-170

working with non… time-of-day values, 175-176

DATEVALUE function, 147, 149, 729

DAVERAGE function, 271, 728

David McRitchie's Excel Pages web site, 773

DAY function, 147, 729

DAYS360 function, 147, 729

DB function, 344, 732

DCOUNT function, 110, 176, 178, 271, 728

DCOUNTA function, 176, 271, 728

DDB function, 344, 732

Debt-to-Equity Ratio, 369

Debug button, VB Editor, 639

debugging formulas

auditing tools, 596-604

overview, 581-582

problems and solutions

absolute/relative reference problems, 589-590

actual versus displayed values, 591-592

"blank cells" that are not blank, 584-585

cells are filled with hash marks, 584

circular reference errors, 595

extra space characters, 585

floating-point number errors, 592-593

formulas are not calculated, 591

formulas returning errors, 585-589

logical value errors, 594-595

mismatched parentheses, 583-584

operator precedence problems, 590-591

phantom link errors, 593-594

debugging functions, 637-641

DEC2BIN function, 730

DEC2HEX function, 730

DEC2OCT function, 730

Decimal data type, 650

Decimal option, Settings tab, 557

declaration line, 646

Decrease Decimal button, 747, 753

Defaut date format, 139

Define Name dialog box, 70

Define Name option, 546

DEGREES function, 280, 737

Delete button, 62

deleting

conditional formatting, 543

names, 64

rows or columns, 80, 242

sheets, potential name problems, 82-83

Delimited option, Convert Text to Columns Wizard, 134

DELTA function, 730

dependents, identifying, 600

depreciation formulas. See discounting and depreciation formulas

Developer tab, 23, 608

DEVSQ function, 176, 739

DGET function, 271, 728

Diagrams program, 22

dialog box launcher, 12

dialog icons, 14

dialog sheets, 10-11

Disable All Macros with Notification option, Macro Settings, 609

DISC function, 732

discounting and depreciation formulas

depreciation calculations, 343-346

FVSCHEDULE function, 342-343

IRR function, 332-336

irregular cash flows, 340-342

multiple rates of IRR and the MIRR function, 336-340

NPV function, 322-332

Display Item Labels When No Fields Are in the Values Area option, 511

DMAX function, 271, 728

DMIN function, 271, 728

Do Until loops, 662, 666

Do While loops, 662, 664-665

document themes, 20

DOLLAR function, 121, 742

DOLLARDE function, 286, 289-290, 732

DOLLARFR function, 286, 289-290, 732

dollars, fractional, 289-290

dots, leading, 766

Double data type, 650

Double-click Allows Editing Directly in Cell check box, 36

DPRODUCT function, 271, 728

drag and drop, 15, 17

drawing layer, objects on, 24-26

Drawing Tools tab, 12

drop-down list, 558-559

DSTDEV function, 271, 728

DSTDEVP function, 271, 728

DSUM function, 177, 178, 271-272, 728

duplicate rows, removing, 244-245

DURATION function, 732

DVAR function, 271, 729

DVARP function, 271, 729

dynamic amortization schedules, 351-354

dynamic arrays, 657

dynamic crosstab table, 417-418

dynamic named formulas, 94-95