Pivot table data crunching for Microsoft Office Excel 2007

This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems. Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing report...

Descripción completa

Detalles Bibliográficos
Otros Autores: Jelen, Bill Author (author), Alexander, Michael Contributor (contributor)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] Que Pub 2007
Edición:1st edition
Colección:Business solutions
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627004906719
Tabla de Contenidos:
  • Pivot table fundamentals and ground rules
  • Creating your first pivot table
  • Customizing your pivot table
  • Controlling the way you view your pivot data
  • Performing calculations within your pivot tables
  • Creating and using pivot charts
  • Analyzing disparate data sources with pivot tables
  • Taking your pivot tables to the web
  • Working with and analyzing olap data sources
  • Enhancing pivot reports with macros
  • Using vba to create pivot tables
  • Common pivot table issues and questions
  • A pivot table function map.