S


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]

Salas, Pito
     pivot tables, development of
Save data with table layout option (PivotTable Options dialog) 2nd
Save password option (PivotTable Options dialog)
saving
    passwords
         in Excel
scrollbars
     spreadsheets, adding to 2nd
     tying macros to 2nd
seasonality reports 2nd
     cell importance, tracking 2nd
    fields
         measuring percentages in
     line comparisons
section headings
     storing data in 2nd
security
     macros, configuring for
selecting
     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
showing
     Data Field items
     group detail
     Page Field items 2nd
     pivot table data 2nd 3rd 4th
     pivot table items without data 2nd 3rd
sizing
     VBA pivot tables 2nd 3rd 4th
solve order (calculated items)
     changing
sort orders
     VBA pivot tables
sorting
     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
specifying
    data ranges
         via PivotTable Wizard
spreadsheets
     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)
storing
    data
         OLTP databases
Subtotal Hidden Page Items option (PivotTable Options dialog)
subtotal rows
     in VBA pivot tables 2nd 3rd
         suppressing 2nd
subtotals
     adding multiple subtotals to fields 2nd
     removing
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
summarizing
    date fields via grouping
         in VBA 2nd 3rd 4th 5th 6th
summary calculations
     changing
         blank cells causing counts
summary reports
     1992 case study 2nd 3rd 4th
summary tables
     OLAP cubes
super-variables (VBA)
sycnrhonizing
     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