Excel 2016 Pivot Table Data Crunching

Excel 2016 Pivot Table Data Crunching: Includes Content Update Program (MrExcel Library)
by Bill Jelen,Michael Alexander
Print Length 页数: 432 pages
Publisher finelybook 出版社:‏ QUE; 01 edition (5 Nov. 2015)
Language 语言: English
ISBN-10: 0789756293
ISBN-13: 9780789756299
B017MTJ3YA
Excel 2016 PIVOT TABLE DATA CRUNCHING
CRUNCH DATA FROM ANY SOURCE,QUICKLY AND EASILY,WITH EXCEL 2016 PIVOT TABLES!
Use Excel 2016 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. Drawing on more than 40 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!
Create,customize,and change pivot tables
Transform huge data sets into clear summary reports
Analyze data faster with Excel 2016’s new recommended pivot tables
Instantly highlight your most profitable customers,products,or regions
Quickly import,clean,and shape data with Power Query vBuild geographical pivot tables with Power Map
Use Power View dynamic dashboards to see where your business stands
Revamp analyses on the fly by dragging and dropping fields
Build dynamic self-service reporting systems
Combine multiple data sources into one pivot table
Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot
Automate pivot tables with macros and VBA
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
Bill Jelen is MrExcel,the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com,the premier Excel solutions site,with more than 20 million page views annually. A Microsoft MVP for Excel,his best-sellers include Excel 2016 In Depth. Michael Alexander,Microsoft Certified Application Developer (MCAD) and Microsoft MVP,is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions.
CATEGORY: Spreadsheets
COVERS: Microsoft Excel 2016
Contents
Chapter 1 Pivot Table Fundamentals
Chapter 2 Creating A Basic Pivot Table
Chapter 3 Customizing A Pivot Table
Chapter 4 Grouping,Sorting,And Filtering Pivot Data
Chapter 5 Performing Calculations In Pivot Tables
Chapter 6 Using Pivot Charts And Other Visualizations
Chapter 7 Analyzing Disparate Data Sources With Pivot Tables
Chapter 8 Sharing Pivot Tables With Others
Chapter 9 Working With And Analyzing Olap Data
Chapter 10 Mashing Up Data With Power Pivot
Chapter 11 Dashboarding With Power View And 3D Map
Chapter 12 Enhancing Pivot Table Reports With Macros
Chapter 13 Using Vba To Create Pivot Tables
Chapter 14 Advanced Pivot Table Tips And Techniques
Chapter 15 Dr. Jekyll And Mr. Getpivotdata
Excel 2016 PIVOT TABLE DATA CRUNCHING
从任何来源快速搜索数据，快速，轻松，EXCEL 2016 PIVOT TABLES！
使用Excel 2016透视表和透视图可以在几分钟内生成强大的动态报告，而不是几小时…了解您的业务正在发生的事情…控制，并保持控制！即使您以前从未创建过数据透视表，本书也将帮助您充分利用其所有的灵活性和分析能力。 Bill Jelen和Michael Alexander凭借40多年的Excel经验，为解决真实的商业问题提供实用的“食谱”，帮助您避免常见的错误，并提供您无法找到的提示和技巧！
创建，自定义和更改数据透视表
将巨大的数据集转换为清晰的摘要报告
使用Excel 2016的新推荐的数据透视表更快地分析数据
立即突出您最赚钱的客户，产品或地区
使用Power Map vBuild地理数据透视表快速导入，清理和形成数据
使用Power View动态仪表板来查看您的业务所在
通过拖放场来改进分析
建立动态自助服务报告系统
将多个数据源合并到一个数据透视表中
使用自动分组可以更快地构建基于日期/时间的数据透视表v使用Power Pivot创建数据混搭
使用宏和VBA自动化数据透视表
关于MrExcel图书馆
MrExcel Library中的每本书都精确地指出了一组关键的Excel任务，并提供了重点的技能和示例，以便快速有效地执行。由Bill Jelen选择，Microsoft Excel MVP和主管Excel领先的Excel解决方案网站MrExcel.com，这些书将会
大大提高您的生产力 – 节省您每年50小时或更长时间
目前证明，解决现实问题的创新策略
告诉你如何获得很好的结果，无论你有多少数据
帮助您避免用户造成的严重错误
Bill Jelen是世界上第一个电子表格向导的MrExcel。 Jelen主持了MrExcel.com，这是首屈一指的Excel解决方案网站，每年浏览量超过2000万。一个Microsoft的MVP Excel，他的畅销书包括Excel 2016深度。迈克尔·亚历山大，微软认证应用程序开发人员（MCAD）和微软MVP是几本有关Excel和Access高级业务分析的书籍的作者。他在开发Office解决方案方面有超过15年的经验。
CATEGORY: 电子表格
COVERS: Microsoft Excel 2016
目录
第1章数据透视表基础知识
第2章创建基本数据透视表
第3章定制数据透视表
第4章分组，排序和过滤数据透视数据
第5章在数据透视表中执行计算
第6章使用数据透视图和其他可视化
第7章使用数据透视表分析不同的数据源
第8章与其他人共享数据透视表
第9章使用和分析Olap数据
第10章用功率数据透析数据
第11章功能视图和3D地图的仪表板
第12章使用宏增强数据透视表报表
第13章使用Vba创建数据透视表
第14章高级数据透视表技巧和技巧
第15章Jekyll博士和Getpivotdata先生