V

Index

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

Value fields
     multiple consolidation range pivot tables 2nd
Var function 2nd
variables
     super-variables (VBA)
VarP function 2nd
VBA (Visual Basic for Application)
     AutoComplete feature
    AutoShow feature
         producing executive overviews 2nd 3rd 4th
     AutoSort feature
    code
         syntax of
         writing, handling data range sizes 2nd
         writing, super-variables
     comments
    CreatePivotTable method
         building pivot tables
     Debug mode 2nd
     enabling
     finding final rows 2nd
    groups
         creating
     Help file
     Macro Recorder
    pivot tables
         adding fields to
         AutoSort feature
         blank cells 2nd 3rd
         borders
         building
         building, CreatePivotTable method
         building, defining pivot caches 2nd
         building, defining Sum of Revenue fields 2nd
         building, Excel version differences 2nd
         calculated fields 2nd
         calculated items 2nd
         calculation options
         calculation options, BaseField property 2nd
         calculation options, xlPercentDifferenceFrom property 2nd
         calculation options, xlPercentofTotal property
         captions
         changes to/deletions in
         converting to reports
         data averages 2nd
         default number format
         default number format, changing 2nd
         default sort order
         default state annoyances 2nd
         dropping fields to
         Excel 97 case study 2nd
         executive overviews, producing 2nd 3rd 4th
         filtering multiple items in PivotFields 2nd
         filtering recordsets 2nd 3rd
         filtering reports via page fields 2nd 3rd 4th 5th
         Grand Total for rows, supressing
         grouping data by week 2nd 3rd 4th
         manual sort order
         minimum/maximum data 2nd
         multiple fields 2nd
         Outline view
         Outline view;fixing 2nd
         page breaks
         sizing 2nd 3rd 4th
         subtotal rows 2nd 3rd
         subtotal rows, supressing 2nd
         summarizing data fields via grouping 2nd 3rd 4th 5th 6th
         summary reports, building workbooks
         summary reports, customizing worksheets
         summary reports, fixing Outline view 2nd
         summary reports, producing 2nd 3rd 4th
         summary reports, subtotal rows 2nd
         titles
    PivotFields
         manually filtering multiple items 2nd
     properties
    ShowDetail method
         filtering recordsets 2nd 3rd
VBA (Visual Basic for Application) Editor
     Code window
     opening
    Project Explorer
         enabling
     Properties window
viewing
     OLAP cubes online
Visual Basic Editor [See VBA Editor]
     tying macros to scrollbars 2nd