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