Page 302 - Excel Data Analysis

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

INDEX

TextBox button, 196–197 Covariance feature, 224–225 OptionButton button, 196–197
Thawte Consulting, 175 covariance of sets of data, 224–225 pass parameters, 171
3D charts, 109, 118 F-Test Two-Sample for Variances private subroutines, 170–171, 179
time values. See date/time values tool, 228–229 public subroutines, 170–171, 179
ToggleButton button, 196–197 population, 103 RefEdit button, 196–197
toggles, forms controls, 197 sample, 103, 227 ScrollBar button, 196–197
Trace Cells option, 72–73 sample variance, 227 shortcut keys, 169
Trace Error feature, 72–73 variance comparisons, 228–229 SpinButton button, 196–197
trace operation, formulas, 65, 72–73 variances, 229 TabStrip button, 196–197
Transpose option, 15 Variant data type, 160 TextBox button, 196–197
transposition, rows/columns, 15 variants, 180 ToggleButton button, 196–197
trendlines, 114–115 Varp function, 37 Visual Basic Editor Toolbox, 196–197
trig functions (Excel), quick VBA. See also functions (VBA); Visual Basic for Applications. See
reference, 249–251 macros; Visual Basic Editor VBA
troubleshooting process, case sensitivity, 158 VLOOKUP function, 74–75
CD-ROM, 275 comments, 173
true/false conditions, 68–69, 159, 163 compare values, 162–163 W
trusted sources, 177 concatenated text, 162 Warning messages, 57
24-hour clock, 5 Const keyword, 161
Web queries, 92–93
two/four-digit years, 5, 17 constants, 161 Web sites
Type statement, 160 data types, 158–160
import data from, 92–93, 105
typed data in cells, 2 dialog boxes, 194 interactive pages, 104
display message boxes, 184–185
static pages, 104
U increment counter variables, 183 Western calendar, 5
Unicode Text option, 85 loops, 182–183 what-if comparisons, 70–71
UNISTAT (on the CD), 275 statements, 182–183, 256–259 Width property, 205
Unload statement, 206–207 true/false conditions, 159, 163 wildcards
Unprotect Sheet dialog box, 25 variables, 158, 180–181 in data list filters, 50
user also input. See forms vector LOOKUP format, 75 find values, 6, 77
user input. See also data entry; VeriSign, Inc., 175 in value searches, 6, 77
data lists Visual Basic Editor. See also functions workbook events, 268–269
error messages, 57 (VBA); VBA, statements worksheets
macros, 186–187 activate, 168–169 consolidate multiple sheets, 36–39
user-defined data type, 160 Arrow button, 196–197 create from templates, 23
UserForm events, 268 call subroutines, 170 events, 269
UserForms, 196. See also forms CheckBox button, 196–197 hide cells, 25
utilities. See add-ins ComboBox button, 196–197 link to other document types,
CommandButton button, 196–197 84–85
V create custom functions, 178–179
link to other worksheets, 39
create macros, 170–171
validation, input, 56–57, 212–213 merge, 36–39
#VALUE! message, 273 Frame button, 196–197 navigation, keyboard
Image button, 196–197
Var function, 37 shortcuts, 238
variable declaration, VBA, 258–259 interface (illustration), 157 new, default settings, 23
Label button, 196–197
variance password protection, 24–25
ANOVA (analysis of variance), ListBox button, 196–197 paste from other documents,
220–221 MultiPage button, 196–197 84–85
consolidated data, 37 nodes, 168 protection, 24–25

288