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]

Office Web Components (Microsoft)

OLAP (Online Analytical Processing)

     defining

OLAP (Online Analytical Processing) cubes

     benefits of 2nd

     calculated fields

     combining 2nd

     defining

     dimension fields

     local cube connections 2nd

     local cubes, building

     measure fields 2nd

    pivot tables

         arranging data 2nd

         autoformatting

         autosorting

         displaying top/bottom records

         drilling into data 2nd 3rd 4th 5th 6th 7th

         versus Excel-stored data, calculated fields

         versus Excel-stored data, data handling

         versus Excel-stored data, drilling through data 2nd

     prebuilt data views

     server cube connections 2nd

     setting actions in

     summary tables

     viewing online

     writing back to

OLAP (Online Analytical Processing) servers

     cube connections 2nd

     defining

OLTP (Online Transaction Processing) databases

     data storage

Optimize memory option (PivotTable Options dialog) 2nd

Options button (PivotTable Field dialog)

     accessing field running total options

Options command (PivotTable Field dialog)

     Show Data As combo box 2nd

         % Difference From option

         % of Column option

         % Of option

         % of Row option 2nd

         % of Total option

         Difference From option

         Index option 2nd

         Running Total In option

order lead-time report case study 2nd 3rd

order of operator precedence (calculation rules) 2nd

Outline view (VBA pivot tables)

     fixing 2nd