EBOOK Excel 2007 PivotTables and PivotCharts
Opis
Your visual blueprint for interpreting and presenting Excel data
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"e;Apply It"e; and "e;Extra"e; 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
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"e;Apply It"e; and "e;Extra"e; 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