Excel 2016 pivot table data crunching / Bill Jelen, Michael Alexander.
Material type: TextSeries: MrExcel libraryPublisher: Indianapolis, Indiana : Que, [2016]Description: xiv, 417 pages : illustrations ; 24 cm. ; pbkISBN:- 0789756293
- 9780789756299
- 9780789756299:
- 005.54
- J447655 2016
Item type | Current library | Call number | Status | Date due | Barcode |
---|---|---|---|---|---|
General Lending | Carlow Campus Library General Lending | 005.54 (Browse shelf(Opens below)) | Available | 84782 |
Includes index. 27.79 CW908
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.