Excel 2007 PivotTables and PivotCharts Your Visual Blueprint for Interpreting and Presenting Excel Data |
|
| Author:
| McFedries, Paul |
| Series title: | Visual Blueprint Ser. |
| ISBN: | 978-1-118-07944-7 |
| Publication Date: | Jun 2011 |
| Publisher: | John Wiley & Sons, Incorporated
|
| Imprint: | Visual |
| Book Format: | Ebook |
| List Price: | Contact Supplier contact
|
Book 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...
More 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