Book description
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. 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:
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents at a glance
- Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
-
Part I: Dashboards and Data Visualization
- Chapter 1: Introduction to Dashboard and Decision Support Development
-
Chapter 2: A Critical View of Information Visualization
- Understanding the Problem
- Of Pilots and Metaphors
- A Metaphor Too Far: Driving Down the Information Superhighway
- A Brief History of Dashboards and Information Visualization
- A Quick Summary Before Taking a Critical Look
- Dashboards by Example: U.S. Patent and Trademark Office
- Visualizations That Look Cool but Just Don’t Work
- The Last Word
- Chapter 3: The Principles of Data Visualization in Microsoft Excel
- Chapter 4: The Excel Data Presentation Library
-
Part II: Excel Dashboard Design Tools and Concepts
- Chapter 5: Getting Started: Thinking Outside the Cell
- Chapter 6: Visual Basic for Applications for Excel, a Refresher
- Chapter 7: Avoiding Common Pitfalls in Development and Design
- Chapter 8: The Elements of Good Excel Dashboards and Decision Support Systems
-
Part III: Formulas, Controls, and Charts
- Chapter 9: Introducing Formula Concepts
- Chapter 10: Advanced Formula Concepts
- Chapter 11: Metrics: Performance and Context
- Chapter 12: Charts with Heart (or, How to Avoid a Chart Attack)
- Chapter 13: Creating an Interactive Gantt Chart Dashboard
- Chapter 14: An Interactive Gantt Chart Dashboard, Data Visualization
- Chapter 15: An Interactive Gantt Chart Dashboard, Data Details on Demand
-
Part IV: From User Interface to Presentation
- Chapter 16: Working with Form Controls
- Chapter 17: Getting Input from Users
- Chapter 18: Storage Patterns for User Input
- Chapter 19: Building for Sensitivity Analysis
- Chapter 20: Perfecting the Presentation
-
Part V: Data Models, PowerPivot, and Power Query
- Chapter 21: Data Model Capabilities of Excel 2013
- Chapter 22: Advanced Modeling with Slicers, Filters, and Pivot Tables
- Chapter 23: Introduction to Power Query
- Chapter 24: Introduction to PowerPivot
- Index
Product information
- Title: Dashboards for Excel
- Author(s):
- Release date: October 2015
- Publisher(s): Apress
- ISBN: 9781430249450
You might also like
book
Modern Data Analytics in Excel
If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out …
book
Advanced Excel Success: A Practical Guide to Mastering Excel
Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase …
video
Microsoft Excel - Creating Dynamic Dashboards
In this Microsoft Excel - Creating Dynamic Dashboards training course, expert author Erin Olsen teaches you …
book
Microsoft Excel 2019 Pivot Table Data Crunching
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source …