Dashboards for Excel

Front Matter....Pages i-xxviii
Front Matter....Pages 1-1
Introduction to Dashboard and Decision Support Development....Pages 3-17
A Critical View of Information Visualization....Pages 19-33
The Principles of Data Visualization in Microsoft Excel....Pages 35-53
The Excel Data Presentation Library....Pages 55-78
Front Matter....Pages 79-79
Getting Started: Thinking Outside the Cell....Pages 81-109
Visual Basic for Applications for Excel, a Refresher....Pages 111-129
Avoiding Common Pitfalls in Development and Design....Pages 131-153
The Elements of Good Excel Dashboards and Decision Support Systems....Pages 155-175
Front Matter....Pages 177-177
Introducing Formula Concepts....Pages 179-197
Advanced Formula Concepts....Pages 199-216
Metrics: Performance and Context....Pages 217-226
Charts with Heart (or, How to Avoid a Chart Attack)....Pages 227-251
Creating an Interactive Gantt Chart Dashboard....Pages 253-271
An Interactive Gantt Chart Dashboard, Data Visualization....Pages 273-293
An Interactive Gantt Chart Dashboard, Data Details on Demand....Pages 295-316
Front Matter....Pages 317-317
Working with Form Controls....Pages 319-348
Getting Input from Users....Pages 349-368
Storage Patterns for User Input....Pages 369-391
Building for Sensitivity Analysis....Pages 393-421
Perfecting the Presentation....Pages 423-448
Front Matter....Pages 449-449
Data Model Capabilities of Excel 2013....Pages 451-463
Advanced Modeling with Slicers, Filters, and Pivot Tables....Pages 465-481
Introduction to Power Query....Pages 483-514
Introduction to PowerPivot....Pages 515-533
Back Matter....Pages 535-542