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

Salas, Pito
     pivot tables, development of
Save data with table layout option (PivotTable Options dialog) 2nd
Save password option (PivotTable Options dialog)
         in Excel
     spreadsheets, adding to 2nd
     tying macros to 2nd
seasonality reports 2nd
     cell importance, tracking 2nd
         measuring percentages in
     line comparisons
section headings
     storing data in 2nd
     macros, configuring for
     AutoFormatting predefined formats 2nd
     columns as ranges in data sources
    pivot table location
         via PivotTable Wizard
server OLAP cube connections 2nd
Set Print Titles option (PivotTable Options dialog)
Shortcut key (Record Macro dialog)
Show Data As combo box (PivotTable Field dialog) 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
ShowDetail method (VBA)
     recordsets, filtering 2nd 3rd
     Data Field items
     group detail
     Page Field items 2nd
     pivot table data 2nd 3rd 4th
     pivot table items without data 2nd 3rd
     VBA pivot tables 2nd 3rd 4th
solve order (calculated items)
sort orders
     VBA pivot tables
     data items in unique order 2nd
     pivot tables
         manual sorts 2nd
         via Advanced Options dialog 2nd
         via Standard toolbar sorting buttons 2nd
     VBA pivot tables
         manual sort order
sorting buttons (Standard toolbar)
     sorting pivot tables 2nd
    data ranges
         via PivotTable Wizard
     adding scrollbars to 2nd
standard charts
     as pivot chart alternatives 2nd 3rd 4th
Standard toolbar
     sorting buttons 2nd
StdDev function
StdDevP function
Store Macro in section (Record Macro dialog)
         OLTP databases
Subtotal Hidden Page Items option (PivotTable Options dialog)
subtotal rows
     in VBA pivot tables 2nd 3rd
         suppressing 2nd
     adding multiple subtotals to fields 2nd
Subtotals dialog (PivotTable Field dialog)
     Custom option 2nd
Sum function
Sum of Revenue fields
     VBA pivot tables 2nd
Summarize By section (PivotTable Field dialog)
     Average function
     Count function
     Count Nums function
     Max function
     Min function
     Product function
     StdDev function
     StdDevP function
     Sum function
     Var function 2nd
     VarP function 2nd
    date fields via grouping
         in VBA 2nd 3rd 4th 5th 6th
summary calculations
         blank cells causing counts
summary reports
     1992 case study 2nd 3rd 4th
summary tables
     OLAP cubes
super-variables (VBA)
     pivot tables via macros case study 2nd 3rd 4th 5th

Pivot Table Data Crunching
Pivot Table Data Crunching for Microsoft Office Excel 2007
ISBN: 0789736012
EAN: 2147483647
Year: 2003
Pages: 140

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net