Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, 2/e (Paperback)
暫譯: Excel 樞紐分析表與樞紐分析圖:創建動態電子表格的視覺藍圖,第二版 (平裝本)
Paul McFedries
- 出版商: Hungry Minds
- 出版日期: 2010-06-28
- 定價: $930
- 售價: 2.1 折 $199
- 語言: 英文
- 頁數: 304
- 裝訂: Paperback
- ISBN: 0470591617
- ISBN-13: 9780470591611
-
相關分類:
Excel
立即出貨(限量) (庫存=1)
買這商品的人也買了...
-
$1,200$948 -
$780$616 -
$560$532 -
$590$466 -
$880$695 -
$690$587 -
$780$616 -
$750$593 -
$550$435 -
$820$648 -
$800$760 -
$1,176Computer Organization and Design: The Hardware/Software Interface, 4/e (ARM Edition) (Paperback)
-
$480$408 -
$490$387 -
$520$411 -
$680$578 -
$850$672 -
$560$437 -
$420$332 -
$520$442 -
$450$297 -
$650$553 -
$790$624 -
$580$458 -
$620$409
相關主題
商品描述
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 工具。
這本書使用一系列逐步教程和易於跟隨的截圖,以視覺化的方式展示如何創建和自定義樞紐分析表和樞紐分析圖,使用它們來分析業務數據,並最終以更少的工作達成更多的成果。
- 解釋樞紐分析表和樞紐分析圖的好處,這兩個強大的 Excel 功能允許用戶創建動態電子表格
- 涵蓋創建和自定義、分析業務數據、構建自定義計算、連接外部數據來源(包括 Access 數據庫、Word 表格、網頁、XML 數據、SQL Server 數據庫和 OLAP 立方體)、創建宏以自動化任務等內容
- 使用逐步教程和易於跟隨的截圖,採用「看著學習」的方法,適合視覺學習者
這本書實用、視覺化且內容豐富,是您提升 Excel 技能,掌握樞紐分析表和樞紐分析圖所需的書籍。