Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, 2/e (Paperback)

Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

• Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets
• Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more
• Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners

Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

掌握 Excel 兩個最強大的功能

即使您經常使用 Excel，您可能對 Excel 最有用的兩個功能不太熟悉。PivotTable 和 PivotChart 可將冗長的、難以閱讀的數據轉換為動態、易於閱讀的表格和圖表，突出顯示您最需要的信息；您可以輕鬆進行調整，點擊即可獲得結果，或將多個來源的數據融合到一個文檔中。現在，您可以通過這本實用指南學習如何使用這些強大的 Excel 工具。

本書通過一系列逐步教程和易於跟隨的屏幕截圖，以視覺方式向您展示如何創建和自定義 PivotTable 和 PivotChart，使用它們來分析業務數據，最終以更少的工作量實現更多成果。

- 解釋了 PivotTable 和 PivotChart 的好處，這是 Excel 的兩個強大功能，允許用戶創建動態電子表格
- 包括創建和自定義、分析業務數據、構建自定義計算、連接外部數據源（包括 Access 數據庫、Word 表格、網頁、XML 數據、SQL Server 數據庫和 OLAP 立方體）、創建宏以自動化任務等內容
- 使用逐步教程和易於跟隨的屏幕截圖，適合視覺學習者的「看著學」方法

這本實用、視覺化且內容豐富的書籍將幫助您提升 Excel 技能，掌握 PivotTable 和 PivotChart。