Page 783 - Excel 2013 All-in-One For Dummies

Index 765
filtering, 681–686 formatting, 676–681 importing Access data
to, 624
modifying, 687–692 overview, 667
pivot charts, creating
from, 693–695 Power View add-in,
703–705
Quick Analysis tool,
creating with, 668–669 Recommended Pivot
Tables button, creating
with, 670–672 sorting, 686
undo refresh feature, 60
PivotChart Tools tab, 693 PivotTable button, 668 PivotTable Fields task pane,
673–675, 677, 687, 691 PivotTable Options dialog
box, 691–692 PivotTable Style Options
group, Design tab, 676,
677–678
PivotTable Styles group,
Design tab, 676 planning workbook design,
82–83 plot area, 516
plus sign (+), 88
PMT (Payment) function,
379–382 Pointing method for
formulas, 300 Popular Searches, Excel
Help window, 34–35 Portable Document File
(PDF) format, 120, 494,
508–509
portrait orientation, 281 position, consolidation by,
263–266
pound signs (#####), 135 POWER function, 394–395 Power View add-in, 71,
703–705 PowerPivot add-in
calculated columns, adding with DAX, 701–703
data modeling, 696–699 overview, 71, 695–696 switching between Data
View and Diagram
View, 699–701 PowerPoint, Microsoft,
500–501, 506–507 precedence of operators in
formulas, 307–309 precedents, tracing, 347,
349–352 Present Value (PV)
function, 376–377 presenting workbooks
online, 495–496 preview pane, Open dialog
box, 189 previewing printouts,
271, 272
Previous Page button, Print
Preview window, 276 Previous Sheet button, 33 PRICE function, 387 PRICEDISC function, 387 PRICEMAT function, 387 primary key, 623
Print Area, setting and
clearing, 278 Print buttons, Sheet
Options group, 285 Print Preview feature, 272,
274–276 Print screen
overview, 20, 270–271 Page Layout view, 272–273
previewing printouts, 272 Print Preview feature,
274–276
selecting printers, 271–273
Print Titles feature, 204, 278, 282–284
printers, selecting, 271–273 printing. See also footers; headers; page layout
canceling print jobs, 276–277
charts, 544
default settings for, 55 embedded charts, 518 formulas instead of
calculated values,
294–295
Help topics, 34 overview, 269
Page Break Preview
feature, 292–294
Page Layout view, 272–273 previewing printouts, 272 Print Preview feature,
274–276
Quick Print button,
276–277
removing errors from
printouts, 360
selecting printers, 271–273
Printing dialog box, 276 Printing tab, PivotTable
Options dialog box, 692 Product information,
Account screen, 20, 21 Project Explorer window,
722, 723
Proofing tab, Excel Options
dialog box, 50–52,
223–224
PROPER function, 425–427 properties
adding to files, 465 checking before
distribution, 463–465