Field list (PivotTables), 301
fields (PivotTable)
expanding/collapsing, 304–305
filtering, 306–309
sorting, 306
filling in sequences, 95
filtering
by color, 348
columns, 341
columns, clearing, 343
numbers, 343–345
PivotTable fields, 306–309
reapplying, 351
tables, 199–200
text, 348
financial planning with Excel Solver, 247
FIND function, 31
finding text. See MATCH function
fixed-width text files, 259
font color, sorting by, 188–189
forecasting
accuracy, estimating, 440–443
with ANOVA, 414–415, 419–420
auto sales, 395–399
outliers, detecting, 440–441
presidential elections, 400–403
random errors, checking for, 443–444
variables for. See variables
form controls, 205.
See also specific controls;
user forms copying, 208
fitting to cells, 207
shape, changing, 208
Format Trendline dialog box, 366
formatting data. See conditional formatting;
text functions
forms. See user forms
Formula Auditing toolbar, 103.
See also auditing tool formulas
array. See array formulas
cell references in, changing. See INDIRECT function
computed criteria for, 335
and conditional formatting, 177–179
copying, 78
copying into new rows automatically, 193–197
copying, with IF formulas, 85
criteria ranges for, 336
for data validation, 271–272
date display with, 40–41
dependent cells for. See dependents
evaluating, 151
goal, matching. See Goal Seek
precedent cells for. See precedents
protecting, 520–521
selecting all, 521
table references in, 202
freezing panes, 77
FREQUENCY function, 574–575
functions.
See also specific functions
array. See array functions
and data tables, 113–114
database statistical. See database statistical functions
large numbers and, 375
lookup. See lookup functions
FV function
#per argument, 59
pmt argument, 59
pv argument, 59
rate argument, 59
syntax, 59
type argument, 59