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...

Description complète

Détails bibliographiques
Cote:Libro Electrónico
Auteur principal: Jelen, Bill
Autres auteurs: Alexander, Michael
Format: Électronique eBook
Langue:Inglés
Publié: Indianapolis, Ind. : Que, Ã2005.
Collection:Business solutions.
Sujets:
Microsoft Excel (Computer file)
Electronic spreadsheets.
Business > Data processing.
Tableurs.
Gestion > Informatique.
Accès en ligne:Texto completo (Requiere registro previo con correo institucional)
Table des matières:
  • 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.

Documents similaires