Digital List Price: $24.99
Kindle Price: $13.00

Save $11.99 (48%)

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

Flip to back Flip to front
Audible Narration Playing... Paused   You are listening to a sample of the Audible narration for this Kindle book.
Learn more

Excel 2007 Dashboards and Reports For Dummies Kindle Edition

32 customer reviews

Amazon Price New from Used from
Kindle
"Please retry"
$13.00

Length: 344 pages Optimized for larger screens
  • Due to its large file size, this book may take longer to download

Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Editorial Reviews

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

About the Author

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years experience consulting and developing office solutions. He is the author/co-author of several books on business analysis using Microsoft Excel and Access. Michael is one of 96 Microsoft Excel MVPs worldwide who has been recognized for his contributions to the Excel community. He is also the principal player behind DataPigTechnologies.com, a site that offers video tutorials to beginning and intermediate Excel and Access users. He currently lives in Frisco, Texas where he works as a Senior Program Manager for a top technology firm. Michael can be contacted at mike@datapigtechnologies.com.

Product Details

  • File Size: 34572 KB
  • Print Length: 344 pages
  • Publisher: For Dummies; 1 edition (March 16, 2011)
  • Publication Date: March 16, 2011
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B004ULZTH4
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Lending: Enabled
  • Enhanced Typesetting: Not Enabled
  • Amazon Best Sellers Rank: #605,274 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 16 years experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. Visit him at www.datapigtechnologies.com.

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful By Jonathan Moss on April 8, 2008
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 12 people found the following review helpful By Michelle M. Wright on April 5, 2010
Format: Paperback Verified Purchase
I've been working with a web analytics tool to track our corporate web site performance. I found the available reports to be limiting, but recently learned that I can import the raw data into Excel. However, I needed help with what to do once I had the raw data! I want to disseminate this information throughout my organization, but don't want maintenance of the dashboard to be a full-time job. But I really wanted to be able to display trending.... that's what my users care about. So I ordered this book. I use Excel, but not extensively. I knew how to do pivot tables and charts, but had never used functions such as VLOOKUP. This book gave me the advice I needed to set up a useful, visually appealing, and maintainable dashboard. It was especially helpful in getting past my unfamiliarity with the 2007 version of Excel. Now I'm looking for a more advanced Excel book. I highly recommend this book as a first step into the world of dashboarding. If you get this book, don't forget to download the examples - it helps a lot to see how the functions interact.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Terry Newton on July 27, 2010
Format: Paperback Verified Purchase
This book is very easy to follow, takes you painlessly and logically step-by-step through the dashboard development process and using Excel to get you there. My organization was so happy to see a single dashboard that I developed using this book that used to take 6-8 Powerpoint slides to present.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Brian on February 28, 2013
Format: Kindle Edition Verified Purchase
I'm a pretty advanced Excel user, but got a lot of good ideas and tips on dasboarding from this book. It's packed with practical tools and advice. The author does a great job of explaining, step by step, how to use various form controls, charting tools, pivot tables, macros, and more.

I especially liked the sections on form controls, macros and Chart Design principles. I tried using Mr. Alexander's design principles on one of my recent charts (a chart that I had previously been rather proud of, but after reading, realized was a clunky and cluttered abomination). Using his "less is more" principles I turned that baby into a thing of beauty and a joy forever. I'm starting to feel like the Frank Lloyd Wright of Excel charting.

I might add that the author has a quirky sense of humor that helps make the book an enjoyable read.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Avid Reader VINE VOICE on June 28, 2010
Format: Paperback Verified Purchase
I've always considered myself a knowledgeable Excel user, but this book taught me a lot of new tricks and improved my knowledge of Excel charting. I'm new to the whole dashboarding concept but Dashboards and Reports for Dummies laid everything out in easy-to-understand chapters that slowly build upon each other. While this book won't make me a dashboards expert it will make it possible for me to present concise and useful information to my management team. Highly recommended for beginners and experts alike.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Joseph C. Nelson on August 21, 2013
Format: Paperback Verified Purchase
I love Excel. This is one of the few software that actually holds the test of time and keeps seeming to get better. But, getting better also means getting more complicated. This is what makes the "For Dummies" series so valuable. I can say that it would be nice if they added in interactive modules for download or created special forums for those of us who purchase this product to bounce ideas and questions around.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 3 people found the following review helpful By Truitt L. Bradly on March 12, 2009
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Felipe Isaac Absalon Huizar on November 17, 2011
Format: Kindle Edition Verified Purchase
I did not know how to create a dashboard in Excel, after read this great book I can do it in a few steps
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in