×
![]( "Buchcover ISBN 9780470132319")
Excel 2007 PivotTables and PivotCharts
Your visual blueprint for interpreting and presenting Excel data
von Paul McFedriesWelcome 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:
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
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