Excel 2007 Dashboards and Reports For Dummies 1st Edition by Michael Alexander (PDF)

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 toolCreate dashboards that communicate and get noticedThink about your data in a new wayPresent data more effectively and increase the value of your reportsCreate dynamic labels that support visualizationRepresent time and seasonal trendingGroup and bucket dataDisplay and measure values versus goalsImplement macro-charged reportingUsing 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!

User’s Reviews

Editorial Reviews: From the Back Cover Create dashboards that communicate and get noticedUse pivot tables and form controls to build reports that mean somethingWhat’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 wayCreate dynamic labels that support visualizationRepresent time and seasonal trendingDisplay and measure values versus goalsGive 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.

Reviews from Amazon users which were colected at the time this book was published on the website:

⭐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.

⭐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.

⭐Michael Alexander has done a great job of explaining some complex Excel concepts in plain English and with some humor. I considered myself an intermediate user but had not really worked in Pivot Tables and all that go with them. This book has been a revelation and is one I’m reading front to back. The practice files that can be downloaded are great aids (although finding them on the web site is a pain).The first couple of chapters should not be missed: storyboarding your data to make the best use of it in a dashboard and understanding different levels of analysis are critical prior to jumping into the rest of the book.This is a book I highly recommend.

⭐This book clearly present the steps to making a dashboard. Starting with the pivot table, they build on various dashboarding concepts- conditional formating, the camera option, macro, sparklines, to dynamically linking excel to power point.The authors make excel dashboarding easy, effective, and powerful. Thank you to the authors for making such a clear and useful book. This excellent book has really improved my output at work.

⭐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.

⭐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.

⭐As most “For Dummies” books this does what it advertises. There are times I wish it was a bit different in layout but for the most part it helped me with my presentations. Some of the limitations are my own brain accepting that Excel may not do what I want the way I want. Ha. If you are new to dashboards and reporting this is a very handy book and easier to use than the others I purchased. It is the one I go back to the most and the one that is borrowed by others a lot.

⭐After taking a statistics course at my local university, I was able to convert the knowledge into practicle application with the use of this splendid book. As always “books for Dummies” are always broken down into useful compartments. The book does acknowledge that the user have had some statistical and Excel experience.

⭐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.

⭐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.

⭐Have not got around to this book yet but if it is like the other excel for dummies books, it will be perfect for me.

⭐Excel 2007 Dashboards and Reports For Dummies. This is an excellent book for producing Dashboards & Reports and carries my full recommendation. A five star rating to the seller.

⭐It is good book that explains well how to create dashboards, probably not designed for “dummies” in a first place.

Keywords

Free Download Excel 2007 Dashboards and Reports For Dummies 1st Edition in PDF format
Excel 2007 Dashboards and Reports For Dummies 1st Edition PDF Free Download
Download Excel 2007 Dashboards and Reports For Dummies 1st Edition 2008 PDF Free
Excel 2007 Dashboards and Reports For Dummies 1st Edition 2008 PDF Free Download
Download Excel 2007 Dashboards and Reports For Dummies 1st Edition PDF
Free Download Ebook Excel 2007 Dashboards and Reports For Dummies 1st Edition