Excel 2007 Dashboards and Reports For Dummies

Excel 2007 Dashboards and Reports For Dummies
























Publisher: For Dummies
Number Of Pages: 336
Publication Date: 2008-03-04
ISBN-10 / ASIN: 0470228148
ISBN-13 / EAN: 9780470228142


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



Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !