Excel Dashboards and Reports (Mr. Spreadsheet's Bookshelf) and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a 6.00 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Excel Dashboards and Reports (Mr. Spreadsheet's Bookshelf) on your Kindle in under a minute.

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

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

Michael Alexander
4.6 out of 5 stars  See all reviews (10 customer reviews)
RRP: 27.99
Price: 19.03 & FREE Delivery in the UK. Details
You Save: 8.96 (32%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 30 Aug.? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 17.30  
Paperback 19.03  
Trade In this Item for up to 6.00
Trade in Excel Dashboards & Reports (Mr. Spreadsheet's Bookshelf) for an Amazon Gift Card of up to 6.00, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

23 May 2013 Mr. Spreadsheet's Bookshelf (Book 17)
Learn to use Excel dashboards and reports to better conceptualize data Updated for all the latest features and capabilities of Excel 2013, this go–to resource provides you with in–depth coverage of the individual functions and tools that can be used to create compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you 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 way that is both visually attractive and effective 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 analysis processes Walks you through creating impressive dashboards, eye–catching visualizations, and real–world What–If analyses Excel Dashboards and Reports, Second Edition is part technical manual, part analytical guidebook, and exactly what you need to become your organization′s dashboard dynamo!

Frequently Bought Together

Excel Dashboards & Reports (Mr. Spreadsheet's Bookshelf) + Excel 2013 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) + 101 Ready-to-use Excel Macros (Mr. Spreadsheet's Bookshelf)
Price For All Three: 59.81

Buy the selected items together

Product details

  • Paperback: 432 pages
  • Publisher: John Wiley & Sons; 2nd Edition edition (23 May 2013)
  • Language: English
  • ISBN-10: 1118490428
  • ISBN-13: 978-1118490426
  • Product Dimensions: 22.8 x 19.4 x 2.2 cm
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Bestsellers Rank: 14,240 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Create versatile, engaging dashboards with Excel Organizations are hungry for data-driven insights, and the need to turn large amounts of data into meaningful information has made building effective dashboards and reports more important than ever. As one of the most powerful and commonly used business tools, Excel is an ideal platform for synthesizing complex data into clear and effective reporting. This book provides you with the technical know-how to move from reporting your data with simple tables full of dull numbers to creating meaningful and appealing reporting solutions that will wow an audience. You'll learn to analyze large amounts of data, present the results, add interactive controls, design eye-catching visualizations, and connect to external data sources with this one-of-a-kind Excel guide. Let Mr. Spreadsheet show you how to: Effectively analyze and present large volumes of data Create eye-catching visualizations Improve data visibility from different perspectives Add interactivity to slice data into various views on the fly Connect to external data sources

About the Author

Michael Alexander is a Microsoft MVP who has written several books on advanced business analysis with Access and Excel, including 101 Ready-To-Use Excel Macros and the Access 2013 Bible. A consultant and developer, he offers workshops and webinars through www.datapigtechnologies.com. John Walkenbach, aka Mr. Spreadsheet, has written hundreds of articles and over 50 books, including multiple editions of the bestselling Excel Bible . He also created the award-winning Power Utility Pak.

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

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4.6 out of 5 stars
4.6 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars Really good so far! 19 April 2014
Format:Paperback|Verified Purchase
I have been worried about setting up dashboards for quite some time and had previously thought Excel wouldn't be up to the challenge. I have just started reading this book and just the introductory comments are so very helpful. There is so much more to dashboards than an Excel formula, and other well-known authors are acknowledged and recommended for further reading.

The free files took a bit of digging out of Wiley's website, as the url's in the book no longer work, but even I managed to download them.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars A must !! 2 April 2014
Format:Paperback|Verified Purchase
This book is ideal for either quick reference or a thorough read from cover to cover. It is clear and easy to understand and has helped me develop reporting dashboards, especially incorporating sparklines and 'auto update' graphics. Excellent !
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent 11 Dec 2013
By Tonyarm
Format:Paperback|Verified Purchase
This book shows you how to do it from the beginning. I now produce effective dashboards and reports that are earning me extra fees from my clients. As well as gaining the specific knowledge the books title alludes to, despite being an experienced excel user, I have learnt many new things about excel that I now use in my daily work - a real bonus.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Very useful tutorial and reference book 22 Sep 2013
By Steve W
Format:Kindle Edition|Verified Purchase
A thorough tutorial on using charts, pivot tables, etc to create dashboard reporting. Very well written to explain complex issues in a simple way. Talks a lot about Excel 2013, but most of the functionality is also available in earlier versions of the software.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Wow - I thought I knew about reports! 26 July 2013
Format:Paperback|Verified Purchase
I bought this in the hope of learning a trick I didn't already know and I was right to do so! I've been an excel user for many years but hadn't mastered all the features of excel 2010 (or 2013 - both are covered in this book). The use of sparklines and the clear recommendations about how to make more of the presentation of a report have both been invaluable, as has the clear explanation of the difference between a report and a dashboard. Excellent!
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