Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

Jelen, Bill

  • 出版商: MicroSoft
  • 出版日期: 2021-12-17
  • 售價: $1,620
  • 貴賓價: 9.5$1,539
  • 語言: 英文
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 0137521839
  • ISBN-13: 9780137521838
  • 相關分類: Excel
  • 立即出貨 (庫存=1)


Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power-- including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen ("MrExcel") shares practical "recipes" for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else.

By reading this book, you will:

  • Master easy, powerful ways to create, customize, change, and control pivot tables
  • Transform huge datasets into clear summary reports
  • Instantly highlight your most profitable customers, products, or regions
  • Use the data model and Power Query to quickly analyze disparate data sources
  • Create powerful crosstab reports with new dynamic arrays and Power Query
  • Build geographical pivot tables with 3D Maps
  • Construct and share state-of-the-art dynamic dashboards
  • Revamp analyses on the fly by dragging and dropping fi elds
  • Build dynamic self-service reporting systems
  • Share your pivot tables with colleagues
  • Create data mashups using the full Power Pivot capabilities in modern Excel versions
  • Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online
  • Save time and avoid formatting problems by adapting reports with GetPivotData
  • Unpivot source data so it's easier to work with
  • Use new Analyze Data artificial intelligence to create pivot tables


使用 Microsoft 365 Excel 和 Excel 2021 的樞紐分析表和樞紐分析圖,只需幾分鐘即可生成強大且動態的報告:掌握您的數據和業務的控制權!即使您以前從未創建過樞紐分析表,本書也將幫助您充分利用它們的靈活性和分析能力,包括 Microsoft 365 Excel 的重要最新改進。憑藉超過30年的尖端 Excel 經驗,MVP Bill Jelen('MrExcel')分享了解決真實業務問題的實用“配方”,避免錯誤的專家見解,以及您在其他地方找不到的高級技巧和訣竅。

- 掌握創建、自定義、更改和控制樞紐分析表的簡單而強大的方法
- 將大型數據集轉換為清晰的摘要報告
- 瞬間突出顯示您最有利可圖的客戶、產品或地區
- 使用數據模型和 Power Query 快速分析不同的數據來源
- 使用新的動態數組和 Power Query 創建強大的交叉報表
- 使用3D 地圖構建地理樞紐分析表
- 構建並共享最先進的動態儀表板
- 通過拖放字段即時改進分析
- 構建動態自助報告系統
- 與同事共享您的樞紐分析表
- 使用現代 Excel 版本中的完整 Power Pivot 功能創建數據混合
- 使用桌面版的 VBA 或 Excel 在線版的 TypeScript 生成樞紐分析表
- 通過使用 GetPivotData 適應報告,節省時間並避免格式問題
- 將源數據解除樞紐分析,使其更易於處理
- 使用新的分析數據人工智能創建樞紐分析表


Bill Jelen, Excel MVP and the host of, has been using spreadsheets since 1985, and he launched the website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding, Bill Jelen spent 12 years in the trenches--working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen.


Bill Jelen,Excel MVP和MrExcel.com的主持人,自1985年以來一直在使用試算表,並於1998年推出了MrExcel.com網站。Bill曾是Leo Laporte的Call for Help節目的常駐嘉賓,並製作了超過2,200集的每日視頻播客Learn Excel from MrExcel。他是關於Microsoft Excel的57本書的作者,並為Strategic Finance雜誌撰寫每月的Excel專欄。在創辦MrExcel.com之前,Bill Jelen在一家市值5億美元的上市公司的財務、市場營銷、會計和運營部門擔任財務分析師長達12年。他與妻子Mary Ellen一起居住在佛羅里達州的Merritt Island。