Page 296 - Excel Data Analysis

18 537547 Index.qxd 3/4/03 11:54 AM Page 282

INDEX

Consolidate dialog box, 36–39 type manually, 2 day names, 17
consolidation, data, 37, 39 validate, 56–57 day names, sort, 32
Const keyword, 161 data labels, PivotCharts, 155 DblClick event, 211
constants, VBA, 161 data lists DCOUNT function, 103
constraints on data, specify, 67 create, 26–27 DCOUNTA function, 103
Convert Text to Columns Wizard, defined, 2 Decimal data type, 160
90–91 fill a series, 28–29 decimal places, format, 16–17
copy operation. See also Fill Handle; filter, 48–53 declaration, VBA variables, 180–181
import operation; link operation
find values, 74–81 Define Names dialog box, 8–9, 10–11,
cells, 14–15 import values, 33 12–13
formulas, 63 Degrees Of Freedom, 229
remove records from, 27
series of data, 28–29 repeat values, 28–29 deletion, range names, 8
values from PivotTable reports, sort, 30–31 delimited text files, imported, 86–89
141 Delimited Text option, 87
from Web sites, 92–93 subtotals, 46–47
summarize, 46–47 descriptive statistics, 226–227
Copy option, 14–15 Descriptive Statistics tool, 226–227
CORREL function, 223 data records, 26
data source names, 96 deselection, cells, 14
Correlation tool, 222–223 design mode, forms, 200–201
correlations, 107, 108, 109, 222–223 data tables, 70–71, 154–155
data type conversion functions DGET function, 103
Count function, 37, 59 (VBA), quick reference, 259–260 dialog boxes. See forms; entries for
Count Nums function, 37 specific dialog boxes
data types. See also entries for
count operation, 37, 59, 103, 227 specific types Difference From option, 131
COVAR function, 225 assign to VBA variables, 180–181 digital signatures, 174–177
Covariance feature, 224–225 currency, 4 #DIV/0 message, 273
covariance of sets of data, 224–225 date/time values, 5, 17 DMAX function, 103
Create Names dialog box. See defined, 4 DMIN function, 103
ranges, named
formulas, 5 Do While statement, 182–183
cross-tabulation. See PivotTables fractions, 4 dollar signs, format, 16–17
currency, 4, 16–17
number precision, 4 Double data type, 158
Currency data type, 158 numeric, 4 doughnut charts, 108
Custom AutoFilter dialog box, 50–51
percentages, 4 DPRODUCT function, 103
custom filters, 50–51 PivotTable reports, 123 DSNs, 96
custom forms, 194, 204–205. See also PivotTables, 120 DSTDEV function, 103
forms
customer service for CD-ROM, 275 scientific notation, 4 DSTDEVA function, 103
text, 4 DSUM function, 103
Customize dialog box, 21
cylinder charts, 109 VBA default, 160 duplicate range names, 8
VBA variable default, 180 DVAR function, 103
D Data Validation dialog box, 56–57 DVARP function, 103
database functions (Excel), quick
data analysis. See PivotCharts; reference, 240 E
PivotTables
database queries, 96–101
data consolidation. See databases, external, 94–103, 142–145 E (large E), in scientific notation, 4
consolidation, data e (small e), in scientific notation, 4
data-type source fields, 120
data constraints, specify, 67 edit. See also Visual Basic Editor
data entry. See also forms; import Date data type, 159 formulas, 62–63
operation date/time functions, 241, 261 keyboard shortcuts, 234
import from external sources, 2 date/time values, 5, 17, 28–29, 153 End Type statement, 160
DAVERAGE function, 102–103
keyboard shortcuts, 234 engineering functions, 214, 242–243
282