Page 298 - Excel Data Analysis
P. 298
18 537547 Index.qxd 3/4/03 11:54 AM Page 284
INDEX
functions (Excel). See also formulas; G I
functions (VBA); macros; entries
for specific functions geographical comparisons, 108 IF function, 68–69
data consolidation, 37 GETPIVOTDATA function, 140–141 Image button, 196–197
database, 240 Go To Special dialog box, 45 Import Data dialog box, 88–89
date/time, 241 graphical layout window, 208–209 import operation
defined, 60 graphics, on forms, 197 to data lists, 33
engineering, 214, 242–243 graphs. See charts default format, 88
financial, 214, 244–246 greater than (>), comparison delimited text files, 86–89
find, 60 operator from external databases, 94–103,
in formulas, 272 data list filters, 53 142–145
information, 246 Solver constraints, 67 field delimiters, 88
insert in cells, 60–61 Gregorian calendar, 5 file types supported, 87
loan amortization, 82–83 grid lines, forms, 199 numeric separators, 89
logical, 247 group numeric values, 88
lookup, 74–75, 248 data, 120, 132–133 skip columns, 91
math, 249–251 forms controls, 197 source selection, 87
reference, 248 items in PivotChart fields, 152–153 text breaks, 88
scientific, 214 Group command, 40–41 text format, 93
specify arguments, 60–61 Group option, 132–133 from Web sites, 92–93, 105
statistical, 251–254 Grouping dialog box, 152–153 imported values, sort, 33
sum cells, 59 groups, hide/remove, 133 INDEX function, 77, 78–79
test, 255 H Index option, 131
trig, 249–251 information functions, 246, 263
VBA equivalents, 192–193 Height property, 205 Information messages, 57
in VBA macros, 192–193 hidden cells, in PivotTables, 120 InputBox function, 186–187
functions (VBA). See also macros; Hide method, 207 Insert Calculated Field dialog
Visual Basic Editor; entries for hide operation box, 137
specific functions Insert Calculated Item dialog
buttons in PivotCharts, 151
arrays, 259 detail records, 40–41 box, 137
create, 178–179 Insert Function dialog box, 60–61,
error messages, 43
data type conversion, 259–260 forms, 207 178–179
date/time, 261 insignificant zeros, display, 16
highest/lowest values. See also MAX
Excel equivalents, 192–193 function; MIN function installation
file handling, 262 in data lists, 81 Acrobat Reader (on the CD), 277
financial, 262–263 date/time limits, 5 CD-ROM, 274–275
folder handling, 262 descriptive statistics, 227 Int operator, 67
information, 263 find in data lists, 49 integer constraints, 67
interaction, 264 imported data, 103 Integer data type, 158
math, 264–265 HLOOKUP function, 74–75 interaction, VBA macros, 256, 264
named arguments, 187 hours, format, 17 interactive spreadsheets. See forms;
macros; VBA
private, 170–171, 179 HTML, saved from worksheets, interactive Web pages, 104
public, 170–171, 179 104–105
IPMT function, 82–83
string manipulation, 265–266 HTML option, 85 ISERROR function, 43, 73
Hyperlink option, 85
284
