Trade in Yours
For a 5.11 Gift Card
Trade in
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel Dashboards and Reports (Mr. Spreadsheet's Bookshelf) [Paperback]

Michael Alexander , John Walkenbach
4.3 out of 5 stars  See all reviews (11 customer reviews)

Available from these sellers.


Amazon Price New from Used from
Paperback --  
Trade In this Item for up to 5.11
Trade in Excel Dashboards and Reports (Mr. Spreadsheet's Bookshelf) for an Amazon Gift Card of up to 5.11, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
There is a newer edition of this item:
Excel Dashboards & Reports (Mr. Spreadsheet's Bookshelf) Excel Dashboards & Reports (Mr. Spreadsheet's Bookshelf) 4.3 out of 5 stars (12)
In stock.

Book Description

3 Sep 2010 Mr. Spreadsheet's Bookshelf (Book 12)
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.

Product details

  • Paperback: 456 pages
  • Publisher: John Wiley & Sons; 1 edition (3 Sep 2010)
  • Language: English
  • ISBN-10: 0470620129
  • ISBN-13: 978-0470620120
  • Product Dimensions: 2.5 x 19 x 23.6 cm
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Bestsellers Rank: 337,487 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Become your company′s dashboarding expert The need to turn impossible amounts of data into meaningful information has made dashboards a hot topic. Dashboards provide at–a–glance views into key measures relevant to a particular objective or business process. The power and flexibility of Microsoft Excel makes it an ideal platform for creating dashboards. This guide gives you the technical know–how to go from reporting data with simple tables full of dull numbers to creating high–impact reports and dashboards that will wow management both visually and substantively. If you are familiar with data analysis concepts and experienced in using Excel′s table structures, filters, and formulas, you can quickly become your organization′s dashboard guru. Let Mr. Spreadsheet show you how to: Analyze extensive data and report it in a useful way Quickly slice data into various views on the fly Automate redundant reporting and analysis processes Create eye–catching visualizations Create impressive dashboards and What–If analyses COMPANION WEB SITE Visit to download workbook files for all examples used in the book

About the Author

Michael Alexander is a Microsoft Excel MVP who has written several books on advanced business analysis with Microsoft Access and Excel. Visit Michael at for free Excel and Access training. John Walkenbach , arguably the foremost authority on Excel, has written hundreds of articles and created the award–winning Power Utility Pak. His 50–plus books include Excel 2010 Formulas , Excel 2010 Power Programming with VBA , and the bestselling Excel Bible , all published by Wiley. Visit his popular Spreadsheet Page at

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4.3 out of 5 stars
4.3 out of 5 stars
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
4.0 out of 5 stars Review1 19 April 2011
By Pot2684
This book is a very good introduction to the analytics that can be done from Excel, with some nice examples. Should be used as an introduction and overview.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Excel(lent) Manual 10 Feb 2012
By PollyT
Already having an extensive knowledge of Excel and its functionality, I found I needed to learn about creating analytical Dashboards. Having looked around, I have found Excel Dashboards & Reports to be the best guide I could have chosen. Not only is it comprehensive,it provides examples that can easily be related to and it also has supporting downloadable exercises.

I thought I knew a lot about Excel, but this has certainly given me a whole new dimension to my work.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Excel Dashboards & Reports 8 Aug 2011
I have used/studied Microsoft Excel since the early 90's. I now teach MS Ofice from basic to higher levels including the VBA program language.
Both authors of this publication have produced many excellent computer based books and this is no exception.
Very clear easy to follow examples using Excel 2007 and 2010. I am very much a geek when it comes to Microsoft having devoured this books contents on a week's holiday. First class book and I fully recommend it.
Comment | 
Was this review helpful to you?
5 of 6 people found the following review helpful
The book was just excellent :-), especially for people like me - an Excel user, just a bit above the average.
I am happy the book did not contain too complicated and very advanced IT-techniques. , ....., and it was didactic and easy to read.
An expert should look somewhere else.
I found lots of inspiring ideas/tricks, which I am already using to present my ideas without too much disturbing clutter.
Thanks John and thanks Michael.
Mario Runciman
Comment | 
Was this review helpful to you?
Format:Paperback|Verified Purchase
I really enjoyed reading this book and managed to work through it quite quickly because it was a very easy read. The only thing I will say with this edition is that it has some flaws. The next edition has probably fixed a couple of the misinterpretations/things I couldn't learn within the book. I.e. the area using the "frequency" code, didnt work for me and I couldn't it to work no matter how hard I tried. I am a PMO manager and I found this very useful for building portfolio dashboards for my day to day project data.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars dashboard expertise 10 May 2013
This is an excellent book highlighting the power of displaying data graphically and presenting this in an easily accessible format. I use this book on a regular basis
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category