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] page areas 2nd page breaks in VBA pivot tables page fields Page fields multiple consolidation range pivot tables 2nd page fields multiple consolidation range pivot tables, creating in page fields (VBA) reports, filtering in VBA 2nd 3rd 4th 5th Page Layout option (PivotTable Options dialog) PageField section (PivotTable Field dialog) hiding items options passwords Excel, saving in pie charts pivot charts as 2nd pivot caches creating refreshing pivot charts alternatives to standard charts 2nd 3rd 4th workbooks 2nd as pie charts 2nd chart types, availability of creating 2nd defining 2nd Drop Category Fields Here area Drop Page Fields Here area Drop Series Fields Here area formatting month exclusions for certain data items troubleshooting pivot tables, creating on same sheet as rules customization permanancy 2nd element size/location limitations layouts 2nd 3rd worksheets, embedding on 2nd pivot table referencing formulas, copying troubleshooting 2nd pivot table reports as interactive Web pages 2nd 3rd 4th changing summary calculations blank cells causing counts data source changes 2nd data sources blank cells 2nd column headings column headings, unique headings field formatting gaps 2nd good design attributes 2nd preparation case study 2nd 3rd repeating groups as columns storing in section headings 2nd tabular layouts 2nd defining division revenue contribution reports 2nd formatting 2nd AutoFormat Table option (PivotTable Options dialog) AutoFormatting 2nd case study 2nd For Empty Cells Show option (PivotTable Options dialog) For Error Values Show option (PivotTable Options dialog) Grand Totals for Columns option (PivotTable Options dialog) Grand Totals for Rows option (PivotTable Options dialog) 2nd Mark Totals with * option (PivotTable Options dialog) Merged Labels option (PivotTable Options dialog) 2nd multiple sections at once Page Layout option (PivotTable Options dialog) Preserve Formatting option (PivotTable Options dialog) Repeat Item Labels on Each Printed Page option (PivotTable Options dialog) 2nd Set Print Titles option (PivotTable Options dialog) Subtotal Hidden Page Items option (PivotTable Options dialog) limitations of 2nd macros reasons for using pivot caches, creating removing subtotals revenue by line of business reports case study 2nd 3rd seasonality reports 2nd line comparisons measuring percentages in multiple field tracking cell importance 2nd Top 10 reports producing 2nd 3rd year-to-prior year comparisons year-to-year comparisons YTD numbers, tracking pivot table toolbar customizing for custom formatting redisplaying 2nd Refresh Data icon pivot tables adding columns to adding fields to 2nd adding rows to blank tables creating column areas creating case study 2nd 3rd 4th 5th 6th 7th file size/memory requirements from existing pivot tables from existing pivot tables, file size limitations from existing pivot tables, pivot cache changes 2nd pivot table reporting system creation case study 2nd PivotTable Wizard PivotTable Wizard, selecting data source location PivotTable Wizard, selecting pivot table location PivotTable Wizard, specifying data ranges data areas 2nd defining 2nd development of 2nd drop areas dragging fields to 2nd dropping fields in external data importing without PivotTable Wizard external data options 2nd 3rd external data sources, building with MS Query case study 2nd 3rd 4th 5th field list redisplaying fields customizing, field names customizing, reasons for formatting limitations of 2nd 3rd 4th pivot table reporting system creation case study 2nd grouping fields date fields 2nd date fields, by months date fields, by weeks 2nd date fields, two fields in one report 2nd numeric fields order lead-time report case study 2nd 3rd text fields 2nd 3rd hard data, converting to hiding data 2nd 3rd 4th 5th hiding Data Field items hiding items without data 2nd 3rd hiding Page Field items 2nd location selecting via PivotTable Wizard multiple consolidation range tables 2nd case study 2nd 3rd Column fields creating, defining dataset ranges 2nd creating, naming dataset ranges 2nd creating, page fields Page fields 2nd Row fields Value fields 2nd OLAP 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 page areas 2nd pivot charts layouts 2nd pivot charts, creating on same sheet as pivot table toolbar redisplaying 2nd rank number fields, adding 2nd reappearing deleted data items troubleshooting 2nd rearranging 2nd redefining refreshing disappearing data, troubleshooting 2nd repeated data items troubleshooting reporting systems, creating case study 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th row areas showing data 2nd 3rd 4th showing Data Field items showing items without data 2nd 3rd showing Page Field items 2nd sorting manual sorts 2nd via Advanced Options dialog 2nd via Standard toolbar sorting buttons 2nd synchronization via macros case study 2nd 3rd 4th 5th usage scenarios 2nd 3rd VBA 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 filtering multiple items in PivotFields 2nd filtering recordsets 2nd 3rd filtering reports via page fields 2nd 3rd 4th 5th Grand Total for rows, suppressing 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 producing executive overviews 2nd 3rd 4th sizing 2nd 3rd 4th subtotal rows 2nd 3rd subtotal rows, suppressing 2nd summarizing date 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 when to use 2nd PivotFields multiple items, manually filtering 2nd PivotTable Classic format (AutoFormat) 2nd 3rd 4th PivotTable Field dialog displaying Field Settings command Format Cells dialog Number tab, applying field numeric formats Name text box Options button accessing field running total options Options command Show Data As combo box 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th PageField section hiding items options Subtotals dialog Custom option 2nd Summarize By section 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 versions of 2nd PivotTable Field dialog box None under Subtotals command PivotTable Field List Dimension fields expanding PivotTable field name is not valid error message troubleshooting PivotTable Options dialog accessing Background query option Enable drill to details option Optimize memory option 2nd Refresh every option Refresh on open option Save data with table layout option 2nd Save password option PivotTable Report command pivot tables creating 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 Multiple Consolidation Ranges option 2nd pivot table creation selecting data source location selecting pivot table location specifying data ranges pivot table reports AutoFormatting precalculated calculated fields Preserve Formatting option (PivotTable Options dialog) Product function Product page fields Project Explorer (VBA Editor) enabling properties (VBA) Properties window (VBA Editor) |