Excel 2007 Dashboards & Reports For Dummies (For Dummies (Computer/Tech)) (Paperback)

~ (Author)
Key Phrases: sales amount, combo box, icon sets, Building Basic Dashboard Components Figure, Check Box, Making the Move (more...)

Editorial Reviews

Product Description

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!

From the Back Cover

Create dashboards that communicate and get noticed

Use pivot tables and form controls to build reports that mean something

What's the use of putting out reports that no one bothers to read? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool. You'll find out when you see the examples in this book, and soon your dashboards and reports will be getting rave reviews.

Discover how to:

• Think about your data in a new way

• Create dynamic labels that support visualization

• Represent time and seasonal trending

• Display and measure values versus goals

• Give users an active interface

See all Editorial Reviews

Product Details

• Paperback: 336 pages
• Publisher: For Dummies (March 4, 2008)
• Language: English
• ISBN-10: 0470228148
• ISBN-13: 978-0470228142
• Product Dimensions: 9.2 x 7.3 x 0.9 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (7 customer reviews)
• Amazon.com Sales Rank: #73,259 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #47 in	Books > Computers & Internet > Microsoft > Applications > Excel
  #51 in	Books > Computers & Internet > Software > Spreadsheets

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars Great book, April 8, 2008

By	Jonathan Moss (Pleasanton, CA United States) - See all my reviews (REAL NAME)

This is a great book to have as a resource for not only some of the new features of Excel 2007, but also as a primer to what a data warehouse is and what it means to build one. Of course, the latter is something that can be learned in depth in many other texts, but for a user of Excel, it makes for a good launching point to other more complex concepts of data warehouses and BI (Business Intelligence).

There are many great examples that can simply make spreadsheets look and work better regardless of whether you are building a dashboard or not.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Excel 2007 Dashboard & Reports for Dummies , March 12, 2009

By	Truitt L. Bradly "Microsoft Access MVP 2007 &... (Austin, TX) - See all my reviews (REAL NAME)

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.

4.0 out of 5 stars Very Good Dashboard Concepts & Use of Pivot Tables, September 5, 2009

By	Pernel Roberts "rownel" (T&T) - See all my reviews (REAL NAME)

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.