Cargando…

PowerPivot for the data analyst : Microsoft Excel 2010 /

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Jelen, Bill
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Que, ©2010.
Colección:MrExcel library.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Downloading and installing PowerPivot
  • The promise of PowerPivot
  • Why wouldn't I build every future pivot table in PowerPivot?
  • Getting your data into PowerPivot
  • Creating and managing relationships
  • Using data sheet view
  • Building pivot tables
  • Cool tricks native to pivot tables
  • Cool tricks new with PowerPivot
  • Using DAX for aggregate functions
  • Using DAX for date magic
  • Named sets, GetPivotData, and cube formulas
  • Final formatting : making the report not look like Excel
  • Upgrading to PowerPivot server.