for dummies store - a Wiley Brand
  • Print
  • Share
Excel Dashboards and Reports for Dummies, 3rd Edition (1119076765) cover image

Excel Dashboards and Reports for Dummies, 3rd Edition

ISBN: 978-1-119-07676-6
Paperback
384 pages
January 2016
US $29.99 Add to Cart
Other Available Formats: E-book

Introduction 1

Part I: Getting Started with Excel Dashboards & Reports 7

Chapter 1: Getting In the Dashboard State of Mind 9

Chapter 2: Building a Super Model 25

Part II: Building Basic Dashboard Components 51

Chapter 3: Dressing Up Your Data Tables 53

Chapter 4: Sparking Inspiration with Sparklines 69

Chapter 5: Formatting Your Way to Visualizations 83

Chapter 6: The Pivotal Pivot Table 115

Part III: Building Advanced Dashboard Components 151

Chapter 7: Charts That Show Trending 153

Chapter 8: Grouping and Bucketing Data 179

Chapter 9: Displaying Performance against a Target 201

Part IV: Advanced Reporting Techniques 217

Chapter 10: Macro-Charged Dashboarding 219

Chapter 11: Giving Users an Interactive Interface 233

Chapter 12: Adding Interactivity with Pivot Slicers 255

Part V: Working with the Outside @World 273

Chapter 13: Using External Data for Your Dashboards and Reports 275

Chapter 14: Sharing Your Workbook with the Outside World 301

Part VI: The Part of Tens 323

Chapter 15: Ten Chart Design Principles 325

Chapter 16: Ten Excel Chart Types and @When to Use Them 339

Index 345

  • Print
  • Share