Index
Pareto charts, 483
passwords
adding to workbooks, 161–162, 774, 775
when assigning user permissions, 773
limitations, 769
removing from workbooks, 775
for VBA projects, 777
Paste Special command, 90–93, 587, 648–649
.pdf file extension, 611
PDF files
creating, 194
saving worksheets as, 778
peekaboo tabs, 554–555
penny, rounding to nearest, 248
Percent Style button, 46, 538
percentage error bars, 516
Percentage number format, 50
percentages
applying percent increase/decrease to values,
244–245
calculating, 239
percent distribution, 243–244
percent of goal, 239–240
percent variance, 241
percent variance with negative values, 242
running total, 244
divide-by-zero errors, 245–246
permissions, assigning to worksheets, 773–774
Personal Macro Workbook, 933
PgDn key, 8, 9
PgUp key, 8, 9
phantom link errors, 432
Picture property, 989, 992
Picture Tools
Format, 564
Adjust, 564
PictureSizeMode property, Image control, 992
pie charts, 473–476
Pivot Column command, 875–876
PivotChart Tools Analyze
Actions
Move Chart, 706
Show/Hide, 705
PivotCharts
creating, 703–706
tips for using, 706–707
pivoting columns, 875–876
PivotTable Options dialog box, 669
PivotTable Tools
Analyze
Show, 669
Design
Layout, 669
PivotTable Styles, 668–669
PivotTable Tools Analyze
Calculations
Fields, Items, & Sets, 693, 695
OLAP Tools, 713
Data
Change Data Source, 687
Filter
Insert Slicer, 711
Group
Group Field, 681
Group Selection, 681
Tools
PivotChart, 703, 705
PivotTable Tools Design
Layout
Grand Totals, 696
PivotTables
adding fields, 671
converting into Cube functions, 833–834
copying, 440
creating automatically, 662–663
creating based on data model, 707–713
creating manually
formatting options, 668–669
number format, changing, 668
setting up layout, 664–666
specifying data, 663–664
specifying location for, 664
data appropriate for, 659–662
examples, 656–658, 672–677
filtering data, 439
with slicers, 698–700
with a timeline, 700–701
frequency distributions, creating, 689–691
grouping items
automatically, 683–689
by date, 683–687
manually, 681–682
by time, 688–689
modifying, 670–671
vs. outlines, 630–631
overview, 655–656
re-ordering fields, 671
referencing cells, 701–703