Overview
- Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards that will have your managers singing your praises.
- The book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world.
- Throughout the book, the reader is challenged to think about Excel and data analytics differently—that is, to think outside the cell.
- This book will show you how to create dashboards in Excel quickly and effectively.
- Don’t wait—get started today.
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (24 chapters)
-
Dashboards and Data Visualization
-
Excel Dashboard Design Tools and Concepts
-
Formulas, Controls, and Charts
About this book
In this book, you learn how to:
- Apply data visualization principles for more effective dashboards
- Employ dynamic charts and tables to create dashboards that are constantly up-to-date and providing fresh information
- Use understated yet powerful formulas for Excel development
- Apply advanced Excel techniques mixing formulas and Visual Basic for Applications (VBA) to create interactive dashboards
- Create dynamic systems for decision support in your organization
- Avoid common problems in Excel development and dashboard creation
- Get started with the Excel data model, PowerPivot, and Power Query
Reviews
“This book’s index is detailed. … this is a very useful, detailed, and informative book that will be of great use to the intended audience.” (David Bellin, Computing Reviews, April, 2016)
“The book is not only a step-by-step introduction on how to make a dashboard that would impress our colleagues and management. It goes one level further – what should we get into a good data visualization, best practises and pitfalls for it. … the book is really useful – if you are an Excel dashboard developer you would benefit from it!” (Vitosh Academy, vitoshacademy.com, March, 2016)
Bibliographic Information
Book Title: Dashboards for Excel
Authors: Jordan Goldmeier, Purnachandra Duggirala
DOI: https://doi.org/10.1007/978-1-4302-4945-0
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Jordan Goldmeier and Purnachandra Duggirala 2015
Softcover ISBN: 978-1-4302-4944-3Published: 29 September 2015
eBook ISBN: 978-1-4302-4945-0Published: 07 October 2015
Edition Number: 1
Number of Pages: XXVIII, 542
Number of Illustrations: 633 b/w illustrations
Topics: Microsoft and .NET, Information Systems and Communication Service