Excel 2007 Dashboards & Reports For Dummies

DESCRIPTION

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