Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and...
by Paul McFedries
Sales Rank: 493034
List Price: $26.99 $19.70 At Amazon
Paperback: 290 pages
Publisher: Visual; Pap/Onl edition November 5, 2007
Language: English
ISBN-10: 0470132310
ISBN-13: 978-0470132319
Product Dimensions:
9 x 7.4 x 0.7 inches
Shipping Weight: 1.3 pounds
Product Description
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
Back Cover Copy
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® PivotTable® 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
