Excel dashboards and reports /

Mostrar otras versiones (2)

Learn to use Excel dashboards and reports to better conceptualize data Updated for all the?latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create?compelling Excel reports. Veteran author...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Alexander, Michael, 1972-
Otros Autores: Walkenbach, John
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Hoboken, N.J. : J. Wiley & Sons, Ã2013.
Edición:2nd ed.
Colección:Mr. Spreadsheet's bookshelf.
Temas:
Microsoft Excel (Computer file)
Dashboards (Management information systems)
Statistics > Charts, diagrams, etc.
Business report writing.
Balanced scorecard (Management)
Business writing.
Tableaux de bord (Gestion)
Statistique > Tableaux, graphiques, etc.
Style commercial.
BUSINESS & ECONOMICS > Information Management.
BUSINESS & ECONOMICS > Knowledge Capital.
Statistics.
Charts, diagrams, etc.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Introducing dashboards
  • Table design best practices
  • Using Excel sparklines
  • Chartless visualization techniques
  • Excel charting for the uninitiated
  • Working with chart series
  • Formatting and customizing charts
  • Components that show trending
  • Component that group data
  • Components that show performance against a target
  • Developing your data model
  • Adding interactive controls to your dashboard
  • Marco-charged reporting
  • Using Pivot tables
  • Using Pivot charts
  • Adding interactivity with slicers
  • Using the internal data model and power view
  • Integrating external data into Excel reporting
  • Sharing your work with the outside world.

Ejemplares similares