Pivot table data crunching /

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, o...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Jelen, Bill
Otros Autores: Alexander, Michael
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Que, Ã2005.
Colección:Business solutions.
Temas:
Microsoft Excel (Computer file)
Electronic spreadsheets.
Business > Data processing.
Tableurs.
Gestion > Informatique.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Pivot table fundamentals
  • 2. Creating a basic pivot table
  • 3. Customizing fields in a pivot table
  • 4. Formatting your pivot table report
  • 5. Controlling the way you view your pivot data
  • 6. Performing calculations within your pivot tables
  • 7. Creating and using pivot charts
  • 8. Using disparate data sources for your pivot table
  • 9. Using external data sources for your pivot table
  • 10. Leveraging the power of OLAP cubes
  • 11. Enhancing your pivot table reports with macros
  • 12. Using VBA to create pivot tables.

Ejemplares similares