P

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

Page Break command
Page Break Preview command
Page Break Preview window 2nd
Page Down key
page fields (pivot tables)
Page Setup dialog box 2nd 3rd
Page Up key
panes, multiple
partially fixed references
passwords
        managing
        saving files with
Paste as Hyperlink command
Paste command
Paste Special feature 2nd 3rd 4th
        All Except Borders option
        All option
        Column Widths option
        Comments option
        Formats option
        Formula option
        Formulas and Number Formats option
        pictures
        Validation option
        Values and Number Formats option
        Values option
patterns
Patterns tab 2nd
payments 2nd [See also PMT( function)]
percent
Percent style
Percentage format
PERCENTILE( ) function
PERCENTRANK( ) function 2nd
PERMUT( ) function
permutations
PERSONAL.XLS
personalized menus
        turning off
Phone Number format
PI( ) function
Picture command
Picture toolbar
        Color
        Compress Pictures
        Crop
        Format Picture
        Insert Picture From File
        Line Styles
        More Brightness and Less Brightness
        More Contrast and Less Contrast
        Reset Picture
        Rotate Left 90 ¼
        Set Transparent Color
pictures
        adding to worksheets
        applying as background
       clip art [See clip art]
        compressing
        copying and pasting
       drawing shapes [See drawing shapes ]
        Format Picture dialog box
                options
        image handling
        Insert Picture dialog box
        inserting
        positioning and resizing
        resizing handles
        resizing with distortions
        touching up
pie charts
        3-D effect
        bar of pie
        exploded
        exploding slices in
        grouping slices
        pie of pie
pie of pie charts
Pivot charts
pivot charts
        creating
pivot tables
        adding calculated fields
        adding multiple data items
        building
        Column Fields
        compared to grouping and data lists
        creating multi-layered
        creating pivot chart and pivot table in one step
        criteria for using
        Data Items
        filtering
        formatting
        key benefit
        laying out
        levels of grouping
        life without
        overview
        page fields 2nd
        page filtering versus group filtering
        preparing
        rearranging
        refreshing data
        related fields
        Row Fields
        selecting type of data
        Show Pages feature
        subgrouping
                hiding or showing individual groups
        understanding regions
PivotTable and PivotChart Report command
PivotTable and PivotChart Wizard 2nd
PivotTable Field List 2nd
        adding additional levels of grouping
PivotTable toolbar
        calculated fields
        Chart Wizard
        Format Report button
plot area (chart)
’Plot empty cells as “ setting
PMT( ) function
Polynomial trend
Power and Exponential trends
POWER( ) function
PPMT( ) function
present value 2nd [See also PV( function)]
PRICE( ) function
PRICEDISC( ) function
PRICEMAT( ) function
principal
Print Area submenu
Print dialog box 2nd
Print Preview
        Normal view
        versus worksheet view
printing
        charts
                embedded
                standalone
        comments
        customizing print settings
        default settings
        formulas
        headers and footers
        Help topic
        margins settings
        ’Number of copies “ text box
        ’Print range “ box
       options
                First page number
                Orientation
                Paper size
                Print quality
                Scaling
        page settings
        parts of spreadsheet
        Print Preview tool
        selecting printer
        selection
        settings in grouped worksheets
       sheet settings
                Black and white
                Cell errors
                Comments
                Gridlines
                Page order
                Print titles
                Row and column headings
        steps to print worksheet
probability
PRODUCT( ) function
        SUBTOTAL ( ) function codes and
programming spreadsheets [See VBA, programming spreadsheets with]
progression of time
PROPER( ) function 2nd
        using to change names in all caps to initial caps
properties (programming)
        using
Properties dialog box
proportional fonts
Protect Sheet dialog box 2nd
        Delete columns and Delete rows options
        Edit objects option
        Edit scenarios option
        Format cells, Format columns, and Format rows options
        Insert columns and Insert rows options
        Insert hyperlinks option
        Select locked cells option
        Select unlocked cells option
        Sort option
        Use AutoFilter option
        Use PivotTable reports option
Protect Workbook dialog box
Protection submenu
Publish as Web Page dialog box
PV( ) function
pyramid charts 2nd