Cargando…

Excel PivotTables and PivotCharts : your visual blueprint for creating dynamic spreadsheets /

"Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key techniques for creating PivotTables and PivotCharts"--Resource description page.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: McFedries, Paul
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Hoboken, N.J. : Wiley Pub., Ã2006.
Colección:Visual read less, learn more.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Understanding PivotTables
  • 2. Building a PivotTable
  • 3. Manipulating your PivotTable
  • 4. Changing the PivotTable view
  • 5. Customizing PivotTable fields
  • 6. Setting PivotTable options
  • 7. Performing PivotTable calculations
  • 8. Creating custom PivotTable calculations
  • 9. Creating a PivotChart
  • 10. Building more advanced PivotTables
  • 11. Building a PivotTable from an OLAP cube
  • App. A. Building formulas for PivotTables
  • App. B. Using Microsoft Query with Excel PivotTables
  • App. C. Importing data for PivotTables
  • App. D. Learning VBA basics for PivotTables
  • App. E. Glossary of PivotTable terms.