Description

Book Synopsis


Table of Contents

Introduction 1

Part 1: Getting Started with Excel Dashboards and Reports 7

Chapter 1: Getting in the Dashboard State of Mind 9

Chapter 2: Building a Super Model 23

Chapter 3: The Pivotal Pivot Table 65

Chapter 4: Using External Data for Your Dashboards and Reports. 101

Part 2: Building Basic Dashboard Components 119

Chapter 5: Dressing Up Your Data Tables 121

Chapter 6: Sparking Inspiration with Sparklines 139

Chapter 7: Formatting Your Way to Visualizations 153

Part 3: Adding Charts to Your Dashboards 185

Chapter 8: Charts That Show Trending 187

Chapter 9: Grouping and Bucketing Data 211

Chapter 10: Displaying Performance against a Target 231

Part 4: Advanced Reporting Techniques 247

Chapter 11: Giving Users an Interactive Interface 249

Chapter 12: Adding Interactivity with Pivot Slicers 283

Chapter 13: Sharing Your Workbook with the Outside World 303

Part 5: The Part of Tens 323

Chapter 14: Ten Chart Design Principles 325

Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard 339

Index 345

Excel Dashboards Reports For Dummies

    Product form

    A Paperback / softback by Michael Alexander

    £26.39

    Includes FREE delivery

    RRP £32.99 – you save £6.60 (20%)

    Order before 4pm today for delivery by Sat 19 Sep 2026.

      Trusted by thousands of customers. See 2,385+ Customer Reviews

      View other formats and editions of Excel Dashboards Reports For Dummies by Michael Alexander

      Book details

      Publisher John Wiley & Sons Inc
      Published 23 May 2022
      ISBN-13 9781119844396
      978-1119844396
      ISBN-10 1119844398
      Also in:
      Computing Business applications

      Description

      Book Synopsis


      Table of Contents

      Introduction 1

      Part 1: Getting Started with Excel Dashboards and Reports 7

      Chapter 1: Getting in the Dashboard State of Mind 9

      Chapter 2: Building a Super Model 23

      Chapter 3: The Pivotal Pivot Table 65

      Chapter 4: Using External Data for Your Dashboards and Reports. 101

      Part 2: Building Basic Dashboard Components 119

      Chapter 5: Dressing Up Your Data Tables 121

      Chapter 6: Sparking Inspiration with Sparklines 139

      Chapter 7: Formatting Your Way to Visualizations 153

      Part 3: Adding Charts to Your Dashboards 185

      Chapter 8: Charts That Show Trending 187

      Chapter 9: Grouping and Bucketing Data 211

      Chapter 10: Displaying Performance against a Target 231

      Part 4: Advanced Reporting Techniques 247

      Chapter 11: Giving Users an Interactive Interface 249

      Chapter 12: Adding Interactivity with Pivot Slicers 283

      Chapter 13: Sharing Your Workbook with the Outside World 303

      Part 5: The Part of Tens 323

      Chapter 14: Ten Chart Design Principles 325

      Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard 339

      Index 345

      Recently viewed products

      © 2026 Book Curl

        • American Express
        • Apple Pay
        • Diners Club
        • Discover
        • Google Pay
        • Maestro
        • Mastercard
        • PayPal
        • Shop Pay
        • Union Pay
        • Visa

        Login

        Forgot your password?

        Don't have an account yet?
        Create account