Amazon cover image
Image from Amazon.com

Excel 2016 pivot table data crunching / Bill Jelen, Michael Alexander.

By: Contributor(s): Material type: TextTextSeries: MrExcel libraryPublisher: Indianapolis, Indiana : Que, ©2016Description: xiv, 417 pages : illustrations ; 24 cmContent type:
  • text
Media type:
  • unmediated
Carrier type:
  • volume
ISBN:
  • 0789756293
  • 9780789756299
Subject(s): LOC classification:
  • HF5548.4.M523 JEL
Contents:
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.
Summary: "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
Item type: Books
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Status Date due Barcode
Books Books GSU Library Epoch General Stacks Non-fiction HF5548.4.M523JEL (Browse shelf(Opens below)) Available 50000005885

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

There are no comments on this title.

to post a comment.
Share