Excel 2016 pivot table data crunching / Bill Jelen, Michael Alexander.
Material type: TextSeries: MrExcel libraryPublisher: Indianapolis, Indiana : Que, ©2016Description: xiv, 417 pages : illustrations ; 24 cmContent type:- text
- unmediated
- volume
- 0789756293
- 9780789756299
- HF5548.4.M523 JEL
Item type | Current library | Collection | Call number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|
Books | GSU Library Epoch General Stacks | Non-fiction | HF5548.4.M523JEL (Browse shelf(Opens below)) | Available | 50000005885 |
Browsing GSU Library Epoch shelves, Shelving location: General Stacks, Collection: Non-fiction Close shelf browser (Hides shelf browser)
QC981.8.C5BAR Voluntary approaches in climate policy / | HD6054.2.A45PUN Successful professional women of the Americas : from polar winds to tropical breezes / | JC599.F6ORD Lessons for citizens of a new democracy / | HF5548.4.M523JEL Excel 2016 pivot table data crunching / | S494.5.A65MEL Moo's law : an investor's guide to the new agrarian revolution / | QD412.S5JAI Organoselenium compounds in biology and medicine : synthesis, biological and therapeutic treatments / | HD5840.5.A6POL An employment-targeted economic program for Kenya / |
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.