Page 770 - Excel 2013 All-in-One For Dummies

752 Excel 2013 All-In-One For Dummies
data sharing
overview, 489
with PowerPoint 2013,
506–507
techniques for, 499–501 with Word 2013, 500–506
data source definitions, creating, 633–635
Data tab, 23, 692
Data Table dialog box,
647–648
data tables, 534, 645,
646–651
Data Validation feature,
111–115, 226–228, 356 Data View, PowerPivot add-
in, 699–701
database functions, 620–622 database tables. See data
lists
date, in headers and
footers, 288
DATE function, 365–366 Date functions
DATE, 365–366 DATEVALUE, 365–366 DAY, 366–367
DAYS360, 368
EDATE, 368–369 EOMONTH, 369
MONTH, 366–367 NETWORKDAYS, 369–370 overview, 364
TODAY, 364–365 WEEKDAY, 366–367 WEEKNUM, 370–371 WORKDAY, 371
YEAR, 366–367 YEARFRAC, 371–372
date number formats, 154, 155–156
Date option, Data Validation dialog box, 112
dates. See also Date functions
filtering data lists by, 605–607
formulas for elapsed, 363 general discussion, 361 inputting, 86, 89–91
NOW function, 372–373 overview, 361
regional date settings, 362–363
DATEVALUE function, 365–366
DAVERAGE function, 621 DAX (Data Analysis
Expression), 71, 701–703 DAY function, 366–367
days
calculating number elapsed, 363
Date function, 365
DAY function, 366–367 DAYS360 function, 368 NETWORKDAYS function,
369–370
WORKDAY function, 371
DAYS360 function, 368 DB function, 383 DCOUNT function, 621 DCOUNTA function, 621 DDB function, 383 Decimal option, Data
Validation dialog
box, 112
decimal points, 56, 57, 89,
99–100 declining balance
depreciation,
calculating, 383–385 Decrease Decimal
button, 147 Decrease Font Size button, 144
Decrease Indent button, 146
default file location, 54, 120–121
Default Standard Width command, 137
Delete dialog box, 195 deleting
background images, 251 cell contents, 191, 194–196 cells, 194–195
columns and rows, 232–233 comments, 486
digital ink, 488
digital signatures, 469 duplicate records in data
lists, 586–587
fields in data lists, 580 graphics, 548 hyperlinks, 460
outlines, 246–247 passwords, 439–440
in protected worksheets,
enabling, 443
records in data forms, 586 text boxes, 565
users from shared
workbooks, 483 worksheets in workbooks,
251–252
delimited files, 628 dependents, tracing, 347,
352–353 depreciation functions,
383–385 descriptions, adding to
UDFs, 737–738 Design contextual tab,
141–142
Design tab, 523–538,
641–642, 676 designing worksheets,
75–76, 82–85. See also
templates Desktop button, Open
dialog box, 188