P

 Pacific Brass Sales.xlsx file, 238

Pacific Sales  Staff.xlsx, 262

 Pacific Sales Transactions.xlsx file, 480

Packager application, 887

page breaks, 419–421

Page Layout tab commands and options, 908, 913, 915

Page Layout view, 6, 8, 405–406. See also Print Preview feature

page numbers, 405, 408, 410

pages

adjusting page breaks, 419–421

centering worksheets on, 408

headers and footers, 408–412

magnifying, 422

margins, 407–408

navigating through in Print Preview window, 421

numbers, 405, 408, 410

Page Layout view, 6, 8, 405–406

previewing printouts, 421–422

print areas, 413–414

print layout options, 403–405

printing ranges of, 417

worksheet options, 412–416

Paint bitmap images, 366

painting formats, 274–275

panning, 27, 100

paper feed, 422

paper size, 403–405

paper trays, 422

par values of securities, 544

paradigm shifts, 3

parameters

in Excel Services, 822

in Excel Web Access, 821

in lookup formulas, 484

parameter-based queries, 777–778

Web queries, 780

parentheses (())

argument syntax, 841

in functions, 490

functions and, 438

negative numbers, 138

operator precedence and, 427

Pareto check box, 571

parsing errors, 752–753

part numbers, 313

partially-duplicated rows, 699

participants. See users

passwords

case sensitivity, 163

compared to Information Rights Management, 803

file protection, 59

guidelines for, 59

protecting scenarios, 589

protecting workbooks, 796

refreshing external data and, 748

shared workbooks, 792, 794

specific cell ranges, 159–162

Paste Special dialog box, 883–886

all contents, 187

column widths, 187

comments, 187

displaying, 186

formulas, 187

linking objects, 189

linking objects into Word, 896–897

number formats, 187–188

omitting borders, 187

operations areas, 188–189

pasting objects into Word, 893–897

skipping blanks, 190

themes and, 187

transposing, 190

validation and, 187

values, 187, 188

pasting. See also Paste Special dialog box

all contents, 187

array formulas as constants, 191

assembling lists, 181–185

bitmap images, 885

cells or formulas in linked workbooks, 476–477

charts into Word, 900–901

Clipboard options, 181–185

column widths and, 185, 187

comments, 187

conditional sum formulas, 480–482

copying and, 182–185

cutting and, 185–191

data into e-mail, 802

data into Word, 893–897

data validation settings, 187

destination theme, using, 187

direct cell manipulation, 192–194

displaying, 186

emptying Clipboard, 182

format choices, 187, 883–886

formatting from destination, 185

formatting only, 185

hyperlinks, 191–192

images of worksheets, 397–398

imported data, 755

by inserting new cells, 193–194

keyboard shortcuts, 182

linking objects in Word, 896–897

links to cells, 185, 189–190

lists of names, 450–451

lookup formulas, 484

macro code, 842

with math operators, 188–189

multiple items, 183–185

names into formulas, 449

number formats, 185, 187–188

omitting borders, 187

operations areas, 188–189

Paste button, 182

Paste Link button, 189

pictures from other applications, 365–366

retaining formatting, 185

selectively, 186–188

skipping blank cells, 190

smart tags and, 185

tables into Word, 891–893

themes and, 185, 187

transposing entries, 190

validation and, 187

values, 185, 187, 188

vs. embedding, 882–883

Web query data, 784

Patterned distribution, 575–576, 578–579

patterns on objects, 329–334, 385

pausing

iterations, 600

VBA code, 862

payments

argument, 535

future values, 537–538

NPV function, 537

PMT function, 538, 539

present value and, 536

troubleshooting, 539

payrolls, 534

PDF (Portable Document Format), 15, 72, 423

PEARSON function, 977

percent sign (%), 139, 297–298

Percent Style button, 304, 924

percentages

calculating in PivotTables, 733

cumulative, 571

data entry, 139

formatting, 304, 940

percentages-of-total calculations, 734

styles, 304

PERCENTILE function, 557, 977

percentile rankings, 555–558, 573–574

PERCENTRANK function, 555–556, 977

performance features, 9–10

periods (.), 458, 755

periods (financial), 535, 539–540, 542

permissions

adding users to, 806

document workspaces, 816

IRM (Information Rights Management), 803–806

setting, 161–162, 804

PERMUT function, 977

Personal Macro Workbook, 845

Personal.xlsb file, 845

perspective drawings, 380–381

phishing, 107, 110

phone calls, 808

phone numbers, 306–307

PHONETIC function, 977

photos, 363

PI function, 491, 977

&[Picture] code, 411

Picture format, 894, 895–896

Picture Tools tab commands and options, 911

pictures. See graphics

pie slices, 630, 635, 637

PivotCharts

creating, 742–744

new and changed features, 10–11

setting up, 659

PivotTable Field List window, 716–720, 728–729

PivotTable Tools tab commands and options, 911

PivotTables. See also tables

best uses of, 598

calculated fields and items, 734–738

charting, 659

creating, 715–719

customizing calculations, 732–734

displaying details of data values, 741–742

in Excel Web Access, 821

filtering fields, 716, 728–731

formatting, 723–724

grouping and ungrouping data, 737–741

hiding outline controls, 724

hiding row and column labels, 724

hyperlinks in, 875

multiple summary functions, 732

new and changed features, 9, 10–11

numeric formats in, 722

older dragging features, 721

overview, 711–715

PivotCharts, 742–744

PivotTable Field List window, 716–720

rearranging fields, 718–721

refreshing data in, 721

report layouts, 722

scenario reports, 597–598

in shared workbooks, 792

single-axis, 713

size, 9

sorting fields, 727–728

switching summary functions, 731–732

totals and subtotals, 724–727

undoing changes, 10

placeholder cells in formulas, 584

plain text format, 783, 892, 895

plotting. See charts

plus sign (+), 138, 256, 427, 458

PM notation, 523, 529

PMT function

data tables and, 583

as nonlinear, 608

overview, 538, 977

troubleshooting, 539

points on shapes, 350–351, 352, 354

Poisson distribution, 575, 578, 978

POISSON function, 978

Policy Locations, 829

polygons, 348–351

polynomial trendlines, 660

Popular display options, 97

population functions, 558–559, 579–580

pop-up labels. See ScreenTips

porthole window, 25

portrait page layouts, 403

positioning. See moving

pound signs (###), 140, 458, 531

POWER function, 978

PPMT function, 539, 978

precedents, 135, 246, 248–249

precision

data entry, 139, 140

Euro Currency Tools add-in, 551

Goal Seek command and, 601

numeric values, 467

rank-and-percentile functions, 556

Solver add-in, 608

present values

argument, 536

defined, 536

NPV function, 537

PV function, 536–537

previewing. See also displaying; Live Preview feature

cell formats, 5–6

clip art, 363

data import, 750–751

formatting, 270, 326

page breaks, 419–420

picture adjustments, 370

printed output, 405–406. See also Page Layout view

PRICE function, 546, 978

PRICEDISC function, 546, 978

PRICEMAT function, 546, 979

prices of securities, 544, 546, 547

primary axes, 625

principal in payments, 539

print areas, 413–414, 418

Print dialog box, 417–418

Print method, 866

Print Preview feature, 421–422, 908, 943. See also Page Layout view

printers

driver options, 422

names of, 417

printing

in black and white, 416

centering worksheets on pages, 408

comments, 252, 415–416

dpi resolution, 373

drafts, 416

errors, 415–416

to files, 418–419

gridlines and headings, 414–415

guidelines for worksheet design, 119–120

headers and footers, 408–412

immediately, 418

IRM-protected documents, 805

keyboard shortcuts, 943

large worksheets, 416

margins, 407–408

nonprinting objects, 390

options, 416–419

page breaks and, 419–421

page layout options, 403–405, 405–406

previewing output, 421–422. See also Page Layout view

previewing worksheet portions, 398

print areas, 413–414, 418

print ranges, 417

print titles, 414

printer drivers, 422

quality, 404, 416

rows or columns on every page, 414

screen captures, 945

shared workbook settings, 794

text overflows column, 335

workbooks, 418

worksheets, 412–416

XPS documents, 423–424

privacy options, 108–110

privileges

permissions. See permissions

SharePoint sites, 808

PRN (Formatted Text) file format, 71

PROB function, 979

processes, SmartArt graphics for, 358

processors

dual processor support, 10

multithreaded calculation, 463

PRODUCT function, 498–499, 732, 979

product support

Help. See Help

recovering data, 82

programmatic access to documents, 805

Project Explorer, 834

promoting shapes in SmartArt, 361

PROPER function, 503, 505, 979

properties

smart tags, 230

VBA objects, 835–837, 840

protecting objects from changes, 393–394

protecting workbooks. See also security; Trust Center

disabling alteration, 158–159

encryption, 177–178

hiding, 175–176

hiding cells and worksheets, 162–163, 178

with IRM, 803–806

locking windows, 158–159

passwords, 159–162, 163, 794

permissions, 161–162

settings, 176–177

shared documents, 796

protecting worksheets

hiding cells, 162–163

locking cells, 156–157

passwords, 159–162, 163

permissions, 161–162

unlocking cells, 157–158

publishing

tables on SharePoint sites, 818–820

workbooks on Excel Services, 821–823

workbooks on SharePoint sites, 809

PV function, 536–537, 853, 979

pyramids, 359, 637