Excel 2007 PivotTables and PivotCharts
Your visual blueprint for interpreting and presenting Excel data
Buch in deiner Nähe kaufen
Beschreibung
Welcome to the only guidebook series that takes a visual approachto professional-level computer topics. Open the book and you'lldiscover step-by-step screen shots that demonstrate over 130 keytechniques for working with PivotTables and PivotCharts, including:
* Building PivotTables from Excel ranges
* Customizing PivotTable field lists
* Converting PivotTables to regular data
* Grouping numeric, text, or date/time values
* Developing various summary calculations
* Turning a PivotTable into a PivotChart
* Displaying data tables with a PivotChart
* Creating an OLAP cube data source
* Exporting Access(r) PivotTable(r) forms to Excel
* Using Microsoft Query with PivotTables
EXTRA Apply It
* "Apply It" and "Extra" sidebars highlight useful tips
* High-resolution screen shots demonstrate each task
* Succinct explanations walk you through step by step
* Two-page lessons break big topics into bite-sized modules
Autor*in
Paul McFedries
Themen in »Excel 2007 PivotTables and PivotCharts«
Computer-Ratgeber End-User Computing Excel 2007 Microsoft Excel