Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you"ll discover step-by-step screen shots that demonstrate over 130 key techniques for working with PivotTables and PivotCharts, including:Building PivotTables from Excel rangesCustomizing PivotTable field listsConverting PivotTables to regular dataGrouping numeric, text, or date/time valuesDeveloping various summary calculationsTurning a PivotTable into a PivotChartDisplaying data tables with a PivotChartCreating an OLAP cube data sourceExporting Access(r) PivotTable(r) forms to ExcelUsing Microsoft Query with PivotTablesEXTRA Apply It"Apply It" and "Extra" sidebars highlight useful tipsHigh-resolution screen shots demonstrate each taskSuccinct explanations walk you through step by stepTwo-page lessons break big topics into bite-sized modules