P


padding numbers, 125-126

Page Break between Groups option, Subtotal dialog box, 275

Page Layout tab, Ribbon component, 10-11

Panko, Raymond, 582

Parent property, 673-674

parentheses, 42-44, 583-584

passwords, protecting workbooks with, 32

Paste Function dialog box, 111

Paste List button, 71

Paste Name dialog box, 34, 71-72

Paste Picture Link command, 23

Paste Special dialog box, 114, 542

Paste tool, Clipboard group, 11

Paste Values command, 47-48, 125

pasting

named ranges, 80

names into formulas, 36

path specifications, extracting filenames from, 133

pattern, whether text matches, 697-698

pattern-matched cells, counting, 701

payday loan rates, 307-308

payments

future value of, 302-303

and interest tables, 354-356

loan payments, 305-306

retirement payments, 305-306

smoothing, 331-332

Pearson, Chip, 772

PEARSON function, 741

Pearson Software Consulting web site, 772

Peltier, Jon, 772

Percent Style button, 747

Percentage number format, Options dialog box, 749

PERCENTILE function, 741

PERCENTRANK function, 741

perimeter, 282-283

Period argument, 344

periodic effective rate, 315

periods

early loan payoff, 310-311

years until retirement, 309-310

PERMUT function, 741

phantom link errors, 593-594

PI function, 737

pivot charts, 28, 179, 192, 512

Pivot Table Field List, 492-493, 496, 526

Pivot Table Options dialog box, 493, 495-496

Pivot Table Styles option, 493, 505, 526

pivot tables

calculated field, creating, 514-516

calculated item, inserting, 516-519

creating, 493-498

data appropriate for, 488-491

examples, 486-488, 498-503, 521-524

frequency distribution, 510-512

grouping, 504-510

overview, 29-30, 485-486

producing report with, 524-526

referencing cells within, 519-521

plus sign (+), 33

Pmt argument, 299, 305-306, 311, 331

PMT function, 109, 349-350, 733

POISSON function, 741

polynomial trendlines, 479, 482-483

POWER function, 737

power trendlines, 479-481

Power Utility Pak, 68

PPMT function, 312-313, 733

pre-1900 dates, 148

precedents, identifying, 599-600

Precision as Displayed option, Calculation tab, 745

predicted values, calculating, 477

present value, of annuity with lump sum, 301-302

Presidents' Day, 163

PRICE function, 319-320, 733

PRICEDISC function, 733

PRICEMAT function, 733

principal, 312-314

PROB function, 741

PRODUCT function, 737

profitability ratios, 369

Project window, Visual Basic (VB) editor, 612-616

PROPER function, 98, 125-126, 743

Properties window, Visual Basic (VB) editor, 613

Protect Sheet dialog box, 28-29, 50

Protect Structure and Windows dialog box, 29

protection options, 30-32

Protection tab, 29, 49-50

Pv argument, 299, 310

PV function, 298, 317-318, 733

pyramids, volume of, 284




Excel 2007 Formulas
Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)
ISBN: 0470044020
EAN: 2147483647
Year: 2007
Pages: 212

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