| |||||||||||||||
 Trade In this Item for up to £7.25
Trade in Excel Dashboards and Reports (Mr. Spreadsheet's Bookshelf) for an Amazon.co.uk gift card of up to £7.25, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
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.
From the Back Cover
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 www.wiley.com/go/exceldr to download workbook files for all examples used in the book
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
It probably has a few tricks in it that I might have found useful in a novelty way but I feel it won't have significantly expanded my skill level as much as the other book I read by J Walkenbach did (Power Programming with Excel VBA 2007 - a very good read).
I feel that part of good dashboard design is managing the (sometimes large) source data efficiently. There seemed to be little on how to do this, more on how to change the colour of a bar on a chart. Part of the reason I bought this book was because it had a section on MS Query - something I'm starting to play around with - and I hoped it would fully outline the capability of this programme. It didn't by a long way.
I'm now going to try out Excel 2007 Advanced Report Development - it looks like it contains a lot over my head at the moment but at least it looks comprehensive enough to return to many times in the future.
In summary, this book is good if you're new to Excel charting and pivot tables and want a gentle introduction to some of their basic capabilities. However if you're anything more than that you will read it once, put it on the shelf and rarely return to it.
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
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
