Excel 2007 Dashboards & Reports For Dummies~tqw~ darksiderg

*******************************************************************************
Excel 2007 Dashboards & Reports For Dummies
*******************************************************************************
General InformationType.................: Ebook
Part Size............: 13,083,384 bytes



Post InformationPosted by............: ~tqw~
Release NotesExcel 2007 Dashboards & Reports For Dummies fills the gap between handling data
and synthesizing data into meaningful reports. This title shows readers how to
think about their data in ways other than columns and rows.

What are the most meaningful ways to show trending? How do you show
relationships in data? When is showing variances more valuable than showing
actual data values? How do you deal with outliers? How do you bucket data in the
most meaningful way. How do you show impossible amounts of data without
inundating your audience? In Excel 2007 Dashboards & Reports For Dummies,
readers get answers to all these questions.

Part technical manual, part analytical guidebook; this title will help Excel
users go from reporting data with simple tables full of dull numbers, to
creating high-impact reports and dashboards that will wow management both
visually and substantively. This book offers a comprehensive review of a wide
array of technical and analytical concepts that will help users create
meaningful reports and dashboards. After reading this book, the reader will be
able to:

* Analyze large amounts of data and report their data in a meaningful way
* Get better visibility into data from different perspectives
* Quickly slice data into various views on the fly
* Automate redundant reporting and analyses
* Create eye-catching visualizations
* Create impressive dashboards and What-If analyses

Table of Contents

Introduction.
Part I: Making the Move to Dashboards.
Chapter 1: Getting in the Dashboard State of Mind.
Chapter 2: Building a Super Model.
Part II: Building Basic Dashboard Components.
Chapter 3: The Pivotal Pivot Table.
Chapter 4: Excel Charts for the Uninitiated.
Chapter 5: The New World of Conditional Formatting.
Chapter 6: The Art of Dynamic Labeling.
Part III: Building Advanced Dashboard Components.
Chapter 7: Components That Show Trending.
Chapter 8: Components That Group and Bucket Data.
Chapter 9: Components That Display Performance against a Target.
Part IV: Advanced Reporting Techniques.
Chapter 10: Macro-Charged Reporting.
Chapter 11: Giving Users an Interactive Interface.
Part V: Working with the Outside World.
Chapter 12: Using External Data for Your Dashboards and Reports.
Chapter 13: Sharing Your Work with the Outside World.
Part VI: The Part of Tens.
Chapter 14: Ten Chart Design Principles.
Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard.
Index.

Product Details

* ISBN: 0470228148
* ISBN-13: 9780470228142
* Format: Paperback, 360pp
* Publisher: Wiley, John & Sons, Incorporated
* Pub. Date: March 2008
Install NotesAdobe Acrobat Reader