- 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 differentlythat is, to think outside the cell. This book will show you how to create dashboards in Excel quickly and effectively. Dont waitget 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 authors hard won real-world experience
What youll learn
- Learn the visualization tools, charts, tables, and graphs important to management.
- Understand what management doesnt 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. Its for the developer who isnt satisfied by accepting Excels so-called limitations, who feels that with some creativity, spreadsheets can become a powerful and informative decision engine. Its for the Excel user who has spent hourseven outside of workexperimenting with Excel formulas and macros in an attempt to find a better, more efficient way to complete a task. Its for the user who believes in the power of the spreadsheet.
- Table of Contents
Table of ContentsPart I: All about Dashboards
Chapter 1: A view from the drivers seat
Chapter 2: A critical look at dashboards
Chapter 3: The Principles of Dashboard Visualization
Chapter 4: The Excel advantage (or Excelerating your dashboard)
Part II: Excel Dashboard Design Basics
Chapter 5: Getting Started: Thinking Outside the Cell
Chapter 6: Excel Formulas, a Refresher
Chapter 7: Visual Basic for Applications for Excel, a Refresher
Chapter 8: Avoiding pitfalls in Excel development
Part III: Formulas, Controls, and Some VBAYour First Dashboard
Chapter 9: The Components of a Dashboard
Chapter 10: Introduction to Controls
Chapter 11: Formulas for Dashboard Reporting
Chapter 12: Our first dashboard: Sales tracking dashboard
Chapter 13: Controls Advanced (VBA)
Chapter 14: Putting it all together: Analysis of Alternatives Dashboard
Part IV: Charting new territory!
Chapter 15: Introduction to Dynamic Charts
Chapter 16: Panel charts
Chapter 17: Putting it all together: One-way sensitivity analysis Dashboard
Chapter 18: Other Great Charts
Chapter 19: Advanced Dynamic Charts
Chapter 20: Dynamic Dashboard Tables Techniques
Chapter 21: Advanced Dashboard Tables
Chapter 22: Putting it all together: Workforce Planning Dashboard
Part V: Advanced Dashboards with Databases
Chapter 23: Dashboard Design Principles Review
Chapter 24: Using shapes and other Excel objects (reusable components)
Chapter 25: Introduction to pulling data from Microsoft Access
Chapter 26: Putting it all together: Employee Training Management System
Chapter 27: Advanced Access Data Pulls
Chapter 28: Other (Lost?) Dashboard Components and Techniques
Chapter 29: Sports Analytics Dashboard
Part VI: Appendix
Appendix A: Good Change Management: How to sell an Excel dashboard to a reluctant organization.
Appendix B: The Future: PowerPivot for Excel 2010
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.No errata are currently published