Apress

Dashboards for Excel

By Jordan Goldmeier

Dashboards for Excel Cover Image

Dashboards for Excel is your key to creating informative, vibrant and and interactive dashboards using a hands-on approach based on real-world experience.

Full Description

  • ISBN13: 978-1-4302-4944-3
  • User Level: Intermediate
  • Publishing March 10, 2015, but available now as part of the Alpha Program
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $59.99
  • eBook Price: $41.99

Related Titles

Full Description

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.

  • Covers advanced Excel techniques mixing formulas and Visual Basic for Applications (VBA) to create interactive dashboards
  • Shows how dynamic charts and tables can be used to create dashboards that are constantly up-to-date and providing fresh information.
  • Demonstrates how to display important data summaries, analytics, and visualization all in the same Excel window!
  • Builds on a firm foundation of industry best practices and the author’s hard won real-world experience

What you’ll learn

  • Learn the visualization tools, charts, tables, and graphs important to management.
  • Understand what management doesn’t want to see in a report
  • Turn around dashboards faster and cheaper than ever before
  • Understand the key role dashboards play in an organization
  • Analyze real-world dashboards to apply important features to your own organization
  • Utilize understated, but powerful, Excel formulas and VBA code
  • Avoid common pitfalls in Excel development and dashboard creation

Who this book is for

This book is for many people. It’s for the developer who isn’t satisfied by accepting Excel’s so-called limitations, who feels that with some creativity, spreadsheets can become a powerful and informative decision engine. It’s for the Excel user who has spent hours—even outside of work—experimenting with Excel formulas and macros in an attempt to find a better, more efficient way to complete a task. It’s for the user who believes in the power of the spreadsheet.

Table of Contents

Table of Contents

Part I: All about Dashboards

1. Introduction to dashboard development

2. A critical look at dashboards

3. The Principles of Visualization

4. Advanced Visualization

5. The Excel advantage

Part II: Excel Dashboard Design Basics

6. Getting Started: Thinking Outside the Cell

7. Visual Basic for Applications for Excel, a Refresher

8. Avoiding pitfalls in Excel development

Part III: Formulas, Controls, and Some VBA—Your First Dashboards

9. The Components of a Dashboard

10. Introducing Formula Concepts

11. Applying Formula Concepts

12. Metrics: Context and Performance

13. Introduction to Controls

14. Project Management/Gantt Chart Dashbaord

15. Project Management II: Adding Decision Support

Part IV: Charting new territory!

16. Introduction to Dynamic Charts

17. Chart Minis

18. User interface Components with Excel

19. Putting it all together: One-way sensitivity analysis Dashboard

20. Putting it all together: Workforce Planning Dashboard

Part V: Advanced Dashboards with Databases

21. Using shapes and other Excel objects (reusable components)

22. Introduction to pulling data from Microsoft Access

23. Advanced Access Data Pulls

24. Putting it all together: Employee Training Management System

25. Other (Lost?) Dashboard Components and Techniques

26. Sports Analytics Dashboard

Part V: Appendix

Appendix A: The Future: PowerPivot/PowerView

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

No errata are currently published