 Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and presenting Excel data
ISBN: 978-0-470-13231-9
Paperback
290 pages
November 2007
US $26.99
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability. |
Instructors may request an evaluation copy for this title.
|
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
* 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
