|
Excel PivotTables & PivotCharts: Your Visual Blueprint for Creating Dynamic Spreadsheets
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 100 key techniques for creating PivotTables and PivotCharts, including:
* Building a basic PivotTable(R) report
*
Pivoting fields to different areas
* Filtering PivotTable data
* Organizing PivotTable data into groups
* Formatting a PivotTable
* Changing the summary calculation
* Creating custom calculations
* Publishing a PivotTable to the Web
* Creating a PivotChart(R) from a PivotTable
* Building a PivotTable from external data
"I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
- Rob L. Meerscheidt (The Woodlands, TX)
* 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
* "Apply It" and "Extra" sidebars highlight useful tips
|