Excel 2016 pivot table data crunching /
Jelen, Bill,
Excel 2016 pivot table data crunching / Bill Jelen, Michael Alexander. - xiv, 417 pages : illustrations ; 24 cm. - MrExcel Library . - MrExcel library. .
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.
"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
0789756293 9780789756299
2015941454
Microsoft Excel (Computer file)
Business--Computer programs.
Business intelligence--Computer programs.
Knowledge management--Computer programs.
Electronic spreadsheets--Computer programs
Microsoft Excel (Computer file)
HF5548.4.M523 / JEL
Excel 2016 pivot table data crunching / Bill Jelen, Michael Alexander. - xiv, 417 pages : illustrations ; 24 cm. - MrExcel Library . - MrExcel library. .
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.
"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
0789756293 9780789756299
2015941454
Microsoft Excel (Computer file)
Business--Computer programs.
Business intelligence--Computer programs.
Knowledge management--Computer programs.
Electronic spreadsheets--Computer programs
Microsoft Excel (Computer file)
HF5548.4.M523 / JEL