Excel : dashboards & reports / by Michael Alexander and John Walkenbach.

Introduction, 1 -- Part I. Getting started with excel dashboards, 11 -- Part II. Introducing charts into your dashboards, 89 -- Part III. Advanced dashboarding concepts, 225 -- Part IV. Pivot table driven dashboards, 281 -- Part V. Working with the outside world, 365 -- Index, 399.

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.