Skip to main content

Excel Dashboards and Reports

Excel Dashboards and Reports

Michael Alexander, John Walkenbach

ISBN: 978-0-470-62012-0

Sep 2010

456 pages

Select type: Paperback

Product not available for purchase


The go to resource for how to use Excel dashboards and reports to better conceptualize data

Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an “Excel Report.” What they don’t offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.

  • Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualization
  • Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly
  • Shows how to automate redundant reporting and analyses

Part technical manual, part analytical guidebook, Excel Dashboards and Reports is the latest addition to the Mr. Spreadsheet’s Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that’s both visually attractive and effective.

Introduction 1

Part I: Moving from Spreadsheets to Dashboards

Chapter 1: Introducing Dashboards 11

Chapter 2: Developing Your Data Model 29

Part II: Excel Chart Basics

Chapter 3: Introducing Excel Charts 55

Chapter 4: Understanding Chart Types 75

Chapter 5: Working with Chart Series 109

Chapter 6: Formatting and Customizing Charts 139

Part III: Going Beyond Tables and Charts

Chapter 7: Using Pivot Tables 187

Chapter 8: Using Pivot Charts 221

Chapter 9: Using Excel Sparklines 245

Chapter 10: Chartless Visualization Techniques 259

Part IV: Creating Advanced Dashboard Components

Chapter 11: Components that Show Trending 279

Chapter 12: Components that Group Data 305

Chapter 13: Components that Show Performance against a Target 323

Part V: Automating Your Dashboards and Reports

Chapter 14: Macro-Charged Reporting 339

Chapter 15: Adding Interactive Controls to Your Dashboard 355

Part VI: Working with the Outside World

Chapter 16: Importing Microsoft Access Data into Excel 379

Chapter 17: Sharing Your Work with the Outside World 395

Index 411

Example Files