Contents at a glance
Part I: Dashboards and Data Visualization
Chapter 1: Introduction to Dashboard and Decision Support Development
Chapter 2: A Critical View of Information Visualization
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