What’s the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You’ll find out when you see the dazzling examples in Excel 2007 Dashboards & Reports For Dummies. And, before long, everyone’s eyes will be riveted to your dashboards and reports too!

This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You’ll learn the fundamentals of using Excel 2007 to go beyond simple tables to creating dashboard-studded reports that wow management. Get ready to catch dashboard fever as you find out how to use basic analysis techniques, build advanced dashboard components, implement advanced reporting techniques, and import external date into your Excel reports. Discover how to:

• Unleash the power of Excel as a business intelligence tool

• Create dashboards that communicate and get noticed

• Think about your data in a new way

• Present data more effectively and increase the value of your reports

• Create dynamic labels that support visualization

• Represent time and seasonal trending

• Group and bucket data

• Display and measure values versus goals

• Implement macro-charged reporting

Using Excel 2007 as a BI tool is the most cost-efficient way for organizations of any size create powerful and insightful reports and distribute throughout the enterprise. And Excel 2007 Dashboards and Reports for Dummies is the fastest you for you to catch dashboard fever!

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 7 Ratings

Excel 2007 Dashboard & Reports for Dummies - 2009-03-12
Reviewer Rating:
Michael Alexander, in Excel 2007 Dashboard & Reports for Dummies, did a great job of demystifying using Excel as a dashboard reporting tool. His explanation of how to create and when to use pivot tables, specialized charting techniques, automation, and tricks make creating a powerful and effective dashboard easier.

Top and Bottom views of data in Pivot Tables, Comparative Trending, Bullet Graphs, Sparklines, and Performance against Targets are all concepts that he fully explains to the reader. He also places emphasis on proper definition of the data elements required to produce a dashboard and what to include and more specifically what not to include in the dashboard.

I recommend Excel 2007 Dashboard & Reports for Dummies to all levels of Excel users.

Very Good Dashboard Concepts & Use of Pivot Tables - 2009-09-05
Reviewer Rating:
I purchased this book 2 weeks ago and found it provided a very good introduction to the concepts of dashboards.

The use of the 3-layer approach (Data, Analysis & Presentation) is akin to any business intelligence development.

The author introduces solid BI concepts without the technical jargon and complexity.

The spreadsheet downloads from the website is very handy to help follow the creation and modifications of reports and dashboards.

The pivot table aspect was also well covered. After this book I'll be purchasing a more advanced one on pivot tables.

Good Enough! - 2009-03-25
Reviewer Rating:
I expected more how-to, more examples, and a bit more advanced level. By maybe I should have not, since this is "...for Dummies". The book is fine, I will be buying more of dummies books because it gives you the head start, and a bit more!

Very good - 2009-01-25
Reviewer Rating:
Very good book. My job entails creating spreadsheet reports. Although I have Office 2002, I still found many of the topics very useful to me. I am sure when I upgrade to Office 2007, I should be able to use more features described in the book. The book is worth the amount spent.

Great head start - 2008-12-14
Reviewer Rating:
I purchased this book because I was called on to train someone ELSE how to do this, and the idea of dashboards intrigued me. It helped me quite a bit. I would definitely recommend this to someone who needs to get the basics quickly and easily. You do need to be familiar with Excel, but that really ought to be a given. Solid purchase.

Browse Similar Topics

Top Level Categories:
Desktop Applications

Sub-Categories:
Desktop Applications > Excel