Microsoft Excel 2019 Pivot Table Data Crunching (Business Skills)

Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. 

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to 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 remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present 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 

• Control all future pivot tables using new pivot table defaults 

• Transform huge data sets into clear summary reports 

• Instantly highlight your most profitable customers, products, or regions 

• Use Power Query to quickly import, clean, shape, and analyze disparate data sources 

• Build geographical pivot tables with 3D Map 

• Construct and share state-of-the-art dynamic dashboards 

• Revamp analyses on the fly by dragging and dropping fields 

• Build dynamic self-service reporting systems 

• Share your pivot tables with colleagues 

• Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 

• Automate pivot tables with macros and VBA 

• Save time by adapting reports with GetPivotData 

• Discover today’s most useful pivot table tips and shortcuts 

著名的Excel專家Bill Jelen（MrExcel）和Michael Alexander將幫助您使用Excel 2019樞紐分析表從任何來源進行數據分析。

使用Excel 2019樞紐分析表和樞紐圖，您可以在幾分鐘內生成強大而動態的報告，而不是幾小時，從而掌握您的數據和業務。即使您以前從未創建過樞紐分析表，本書也將幫助您充分利用它們的靈活性和分析能力，包括Excel 2019和Office 365中的有價值改進。借助超過45年的Excel經驗，Bill Jelen和Michael Alexander提供了解決實際業務問題的實用“配方”，幫助您避免常見錯誤，並提供您在其他地方找不到的技巧和訣竅。

通過閱讀本書，您將能夠：
- 掌握創建、自定義、更改和控制樞紐分析表的簡單而強大的方法
- 使用新的樞紐分析表默認值控制所有未來的樞紐分析表
- 將大型數據集轉換為清晰的摘要報告
- 立即突出顯示您最有利可圖的客戶、產品或地區
- 使用Power Query快速導入、清理、整理和分析不同的數據源
- 使用3D地圖構建地理樞紐分析表
- 構建並共享最先進的動態儀表板
- 通過拖放字段即時改變分析
- 構建動態自助報告系統
- 與同事共享您的樞紐分析表
- 使用Excel 2019和Office 365中的完整Power Pivot功能創建數據混搭
- 使用宏和VBA自動化樞紐分析表
- 通過GetPivotData節省時間並適應報告
- 發現當今最有用的樞紐分析表技巧和快捷方式