Pivot Table Data Crunching for Microsoft Office Excel 2007

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]

warehouses (data)

Web Components (Microsoft Office)

Web pages

     pivot tables as 2nd 3rd 4th

weeks, grouping date fields by 2nd

wizards

    PivotTable

         Multiple Consolidation Ranges option 2nd

    PivotTable Wizard

         activating

         Another PivotTable or PivotChart Report option 2nd

         Choose Data Source dialog, OLAP Cubes tab

         Create New Data Source dialog, local OLAP cube connections

         data sources, range expansion updates

         Layout dialog box 2nd

         Multidimensional Connection dialog, local OLAP cube connections 2nd

         pivot table creation

         pivot table creation, selecting data source location

         pivot table creation, selecting pivot table location

         pivot table creation, specifying data ranges

         pivot table reports, AutoFormatting

workbooks

     as pivot chart alternatives 2nd

     building

worksheet functions

     calculation rules

worksheets

     pivot charts, embedding 2nd

    VBA pivot table worksheets

         customizing

writing

     back to OLAP cubes

    VBA code

         handling data range sizes 2nd

         super-variables