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)

買這商品的人也買了...

商品描述

CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES!

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