HAPPY HOLIDAYS: Get a special discount on Apress Access! Subscribe today >>

Dashboards for Excel

Authors: Goldmeier, Jordan, Duggirala, Purnachandra

Download source code
    • 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.

Buy this book

eBook $44.99
price for USA
  • ISBN 978-1-4302-4945-0
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $59.99
price for USA
  • ISBN 978-1-4302-4944-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

This 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. Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards and decision support systems. Throughout the book, the reader is challenged to think about Excel and data analytics differently—that is, to think outside the cell. This book shows you how to create dashboards in Excel quickly and effectively.

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)


Table of contents (24 chapters)

  • Introduction to Dashboard and Decision Support Development

    Goldmeier, Jordan (et al.)

    Pages 3-17

  • A Critical View of Information Visualization

    Goldmeier, Jordan (et al.)

    Pages 19-33

  • The Principles of Data Visualization in Microsoft Excel

    Goldmeier, Jordan (et al.)

    Pages 35-53

  • The Excel Data Presentation Library

    Goldmeier, Jordan (et al.)

    Pages 55-78

  • Getting Started: Thinking Outside the Cell

    Goldmeier, Jordan (et al.)

    Pages 81-109

Buy this book

eBook $44.99
price for USA
  • ISBN 978-1-4302-4945-0
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $59.99
price for USA
  • ISBN 978-1-4302-4944-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Dashboards for Excel
Authors
Copyright
2015
Publisher
Apress
Copyright Holder
Jordan Goldmeier and Purnachandra Duggirala
eBook ISBN
978-1-4302-4945-0
DOI
10.1007/978-1-4302-4945-0
Softcover ISBN
978-1-4302-4944-3
Edition Number
1
Number of Pages
XXVIII, 542
Number of Illustrations and Tables
633 b/w illustrations
Topics