Excel Dashboards and Reports For Dummies, 2nd Edition (For Dummies Series) - Tapa blanda

Alexander, Michael

 
9781118842249: Excel Dashboards and Reports For Dummies, 2nd Edition (For Dummies Series)
Tapa blanda
ISBN 10: 1118842243 ISBN 13: 9781118842249
Editorial: For Dummies, 2014

Sinopsis

Create dynamic dashboards and put your data on display with For Dummies

No matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet tools in Excel 2013, this book shows you how to analyze large amounts of data, quickly slice data into various views on the fly, automate redundant reporting, create eye-catching visualizations, and more.

  • Helps you move beyond reporting data with simple tables, rows, and columns to designing high-impact reports, dashboards, and visuals
  • Walks you through a wide array of technical and analytical concepts to give you the background you need to select the right tool for interpreting and displaying data
  • Covers how to build a chart, work with pivot tables, group and bucket your data, represent trends, create What-If analyses, and increase the value of your reports

Excel Dashboards & Reports For Dummies, 2nd Edition is the business analysis tool you need to transform your raw data into a powerful and effective presentation that is accessible to everyone.

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on Microsoft Access and Excel. He has more than 15 years’ experience consulting and developing Office solutions and has been named a Microsoft MVP for his ongoing contributions to the Excel community.

De la contraportada

Learn to:

  • Analyze data and report it in a way that makes sense
  • Slice and dice data from different perspectives
  • Create eye-catching and understandable reports, visualizations, and dashboards
  • Automate redundant reporting

Take Excel to the next level with this guide to advanced dashboards and reporting

This reference is your ticket to advanced analysis with Excel! Find out how to use this powerful tool for business intelligence and explore the details of data trending and relationships, creating data visualizations, and more. Part tech manual and part analytics guidebook, this resource will help you create high-impact reports and dashboards today!

  • Make the move to dashboards &; create effective dashboards, make great reports, and build super models
  • Build the basics &; dive into PivotTables, Excel charts, conditional formatting, and dynamic labeling
  • Get advanced &; dig into the powerful components of Excel, including those that show trending, display performance, group data, and more
  • Share your work &; use external data for dashboards and reports and share your work with the world
  • Go further &; take things up a notch with more extensive chart design principles and safeguards to follow before distributing dashboards
  • Advanced reporting &; make interactive interfaces and use macros to super-charge your reporting

Open the book and find:

  • Tips to analyze large amounts of data
  • Information on reporting data in meaningful ways
  • Ways to break data down into various views
  • Tricks to create great visualizations
  • Methods to make impressive dashboards
  • Technical and analytical concepts made easy
  • Tips on creating PivotTables, representing trends, and more

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
For Dummies
Año de publicación
2014
Idioma
Inglés
ISBN 10 
1118842243
ISBN 13 
9781118842249
Encuadernación
Tapa blanda
Número de edición
2
Número de páginas
336
Contacto del fabricante
no disponible
Persona responsable
no disponible

Otras ediciones populares con el mismo título

9788126549177: Excel Dashboards And Reports For Dummies, 2Nd Ed

Edición Destacada

ISBN 10:  8126549173 ISBN 13:  9788126549177
Tapa blanda