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!
Excel 2007 Dashboards and Reports For Dummies
and over 1.5 million other books are available for Amazon Kindle . Learn more
| |||||||||||||||
 Trade In this Item for up to £1.10
Trade in Excel 2007 Dashboards and Reports For Dummies for an Amazon.co.uk gift card of up to £1.10, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Special Offer until June 30, 2013: Receive an additional £5 promotional Gift Card, when you trade-in at least £10 worth of books. Learn more
|
Book Description
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
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.
Inside This Book
(Learn More)
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
By Steve0
Format:Paperback
I purchased this book as I had to come up with some dashboard designs for my job. I am fairly proficient in Excel already but always struggled with the graphs design from the upgrade to Excel 2007 from 2003. The book is very well thought out and so easy to read, understand and put to practical use immediately. Would recommend for anyone who needs to brush up on their Excel presentation skills.
There are also some day to day excel tips that you may learn
There are also some day to day excel tips that you may learn
3 of 3 people found the following review helpful
By Simon
Format:Paperback|Amazon Verified Purchase
For those of you thinking this book is a waste of time; a chart is a chart after all then think again. I won't go into the benefits of presenting dashboards for info-hungry managers and steering committees, but for those that end up building such dashboards and reports, this is for you. Reducing mountains of data into fuzzy-felt-and-crayon bite-size easily digestible fragments is an art, and however proficient you think you may be now, this book will open your mind to new techniques not only to display such information, but to bring it together too from various sources. It also touches on backwards compatibility too. How many of you knew of the excel REPT() function, or how it can be used with admirable effect in a dashboard?
All in all a good buy. Setting up dashboards will be quicker and ingenious based on what I've learned in here.
All in all a good buy. Setting up dashboards will be quicker and ingenious based on what I've learned in here.
3 of 3 people found the following review helpful
By R. Rose
Format:Paperback|Amazon Verified Purchase
As a user familiar with many of the features found in Excel, I found this book an absolutely fascinating read. The book is compelling as it uses the typical functions you know and love plus other obscure ones (REPT, no I have never used it before either!) to produces basic building blocks. These building blocks then become more relevant as you go through the book and start to understand how they each can be extended and enhanced. From the very simplistic beginnings the author explains why things are done and what the possibilities are. Halfway through the book, I just could not put it down. The clarity of message really does make for an engrossing read and I finished this book quickly, and now use it as a reference for all the little tips and tricks it contains. There are some fantastic time saving tips - creating a quick and dirty heat chart, as well as some more esoteric functions - camera for instance. If you want to produce dashboards in Excel,this is the first book I would read. Excellent price and highly recommended.
2 of 2 people found the following review helpful
By Steel Breeze
Format:Paperback|Amazon Verified Purchase
Good introduction to the dashboards. Plenty of material on the building blocks, written in an easy to follow style, as you would expect from the "Dummies" range.
2 of 2 people found the following review helpful
By ap
Format:Paperback
Good book :) I think it will help me a lot in my daily job even if it's written in foreign (for me) language. It is so simple and but still very useful!
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 24 reviews
4.5 out of 5 stars
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
- Books > Business, Finance & Law > E-Commerce > E-business
- Books > Computing & Internet > New to Computing > Guidebook Series > Dummies > Microsoft Excel
- Books > Computing & Internet > New to Computing > Software Guides > Microsoft Excel
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets
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.
|
