F


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




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net