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 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 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