Excel 2013 Pivot Table Data Crunching (Paperback)

Bill Jelen, Michael Alexander

  • 出版商: QUE
  • 出版日期: 2013-01-16
  • 售價: $1,400
  • 貴賓價: 9.5$1,330
  • 語言: 英文
  • 頁數: 432
  • 裝訂: Paperback
  • ISBN: 0789748754
  • ISBN-13: 9780789748751
  • 相關分類: Excel
  • 立即出貨(限量) (庫存=1)




Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!


Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function.


Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You’ll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems.


•   Create, customize, and change your pivot tables and pivot charts

•   Transform gigantic data sets into crystal-clear summary reports

•   Summarize and analyze data even faster with new Excel 2013 recommended pivot tables

•   Instantly highlight your most (and least) profitable customers, products, or regions

•   Quickly filter pivot tables using slicers

•   Use dynamic dashboards using Power View to see exactly where your business stands right now

•   Revamp analyses on the fly by simply dragging and dropping fields

•   Build dynamic self-service reporting systems your entire team can use

•   Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets

•   Work with and analyze OLAP data, and much more


About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these
books will

•   Dramatically increase your productivity—saving you 50 hours a year or more

•   Present proven, creative strategies for solving real-world problems

•   Show you how to get great results, no matter how much data you have

•   Help you avoid critical mistakes that even experienced users make


 CATEGORY: Spreadsheets

COVERS: Microsoft Office Excel 2013



使用 Excel 2013 樞紐分析表,輕鬆快速地處理來自任何來源的數據!利用 Excel 2013 樞紐分析表和樞紐圖,您可以在幾分鐘內生成強大而動態的報告,而不是花費數小時...準確了解您的業務狀況...掌握並保持控制!


學習 Excel 2013 或最新的 Office 365 的高級樞紐分析表和樞紐圖技巧從未如此簡單。您將找到簡單的、逐步的說明、實際案例研究,甚至是解決最常見業務分析問題的完整、簡單的配方。

• 創建、自定義和更改您的樞紐分析表和樞紐圖
• 將龐大的數據集轉換為清晰的摘要報告
• 使用新的 Excel 2013 推薦樞紐分析表更快地總結和分析數據
• 立即突出顯示您最有利可圖(和最不利可圖)的客戶、產品或地區
• 使用切片器快速篩選樞紐分析表
• 使用 Power View 創建動態儀表板,準確了解您的業務狀況
• 通過簡單拖放字段即可即時修改分析
• 構建動態自助報告系統,您的整個團隊都可以使用
• 使用 PowerPivot 或數據模型從多個數據源和工作表創建樞紐分析表
• 處理和分析 OLAP 數據等等

關於 MrExcel Library:MrExcel Library 中的每本書都專注於特定的關鍵 Excel 任務,並提供快速有效地執行這些任務所需的專注技能和示例。由 Bill Jelen(Microsoft Excel MVP)選擇,他是領先的 Excel 解決方案網站 MrExcel.com 的幕後推手,這些書籍將:

• 大幅提高您的工作效率 - 每年節省您 50 小時或更多時間
• 提供經過驗證的創新策略,解決現實世界的問題
• 教您如何獲得出色的結果,無論您有多少數據
• 幫助您避免即使是有經驗的用戶也會犯的重大錯誤

涵蓋範圍:Microsoft Office Excel 2013