TY  - BOOK
AU  - Jelen,Bill
AU  - Alexander,Michael
TI  - Excel 2016 pivot table data crunching
T2  - MrExcel Library
SN  - 0789756293
AV  - HF5548.4.M523 JEL
PY  - 2016///
CY  - Indianapolis, Indiana
PB  - Que
KW  - Microsoft Excel (Computer file)
KW  - Business
KW  - Computer programs
KW  - Business intelligence
KW  - Knowledge management
KW  - Electronic spreadsheets
N1  - Includes index; Pivot table fundamentals -- Creating a basic pivot table -- Customizing a pivot table -- Grouping, sorting and filtering pivot data -- Performing calculations in pivot tables -- Using pivot charts and other visualizations -- Analyzing disparate data sources with pivot tables -- Sharing pivot tables with others -- Working with and analyzing OLAP data -- Mashing up data with power pivot -- Dashboarding with Power view and 3D map -- Enhancing pivot tables with macros -- Using VBA to create pivot tables -- Advanced pivot  table tips and techniques -- Dr. Jekyll and Mr. GetPivotData
N2  - "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!"--Back cover
ER  -