Part III: Formulas, Controls, and Charts
by Purnachandra Duggirala, Jordan Goldmeier
Dashboards for Excel
- 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
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
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.