Excel 2007 dashboards & reports for dummies
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 Fo...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, NJ :
Wiley
c2008.
|
| Edición: | 1st edition |
| Colección: | --For dummies.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627609206719 |
Tabla de Contenidos:
- Excel® 2007 Dashboards & Reports For Dummies; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Sample Files for This Book; Icons Used In This Book; Where to Go from Here; Part I: Making the Move to Dashboards; Chapter 1: Getting in the Dashboard State of Mind; Defining Dashboards and Reports; Preparing for Greatness; A Quick Look at Dashboard Design Principles; Chapter 2: Building a Super Model; Data Modeling Best Practices; Excel Functions That Really Deliver
- Using Smart Tables That Expand with DataPart II: Building Basic Dashboard Components; Chapter 3: The Pivotal Pivot Table; An Introduction to the Pivot Table; The Four Areas of a Pivot Table; Creating Your First Pivot Table; Customizing Your Pivot Table Reports; Creating Useful Pivot-Driven Views; Chapter 4: Excel Charts for the Uninitiated; Chart Building Basics; Common Chart Tasks; Working with Pivot Charts; Chapter 5: The New World of Conditional Formatting; Applying Basic Conditional Formatting; Getting Fancy with Conditional Formatting; Chapter 6: The Art of Dynamic Labeling
- Creating a Basic Dynamic LabelAdding Layers of Analysis with Dynamic Labels; Excel's Mysterious Camera Tool; Formula-Driven Visualizations; Part III: Building Advanced Dashboard Components; Chapter 7: Components That Show Trending; Trending Dos and Don'ts; Comparative Trending; Highlighting Periods of Time; Other Trending Techniques; Chapter 8: Components That Group and Bucket Data; Creating Top and Bottom Displays; Using Histograms to Track Relationships and Frequency; Highlighting Top Values in Charts; Chapter 9: Components That Display Performance against a Target
- Showing Performance with VariancesShowing Performance against Organizational Trends; Using Thermometer-Style Charts to Display Performance; An Introduction to the Bullet Graph; Showing Performance against a Target Range; Part IV: Advanced Reporting Techniques; Chapter 10: Macro-Charged Reporting; Why Use a Macro?; Introducing the Macro Recorder; Macro Security in Excel 2007; Excel Macro Examples; Chapter 11: Giving Users an Interactive Interface; Introducing Form Controls; Adding and Configuring Controls; Using the Button Control; Using the Check Box Control
- Check Box Example: Toggling a Chart Series On and OffUsing Option Button Controls; Option Button Example: Showing Many Views through One Chart; Using the Combo Box Control; Combo Box Example: Controlling Multiple Pivot Tables with One Combo Box; Using the List Box Control; List Box Example: Controlling Multiple Charts with One Selector; Part V: Working with the Outside World; Chapter 12: Using External Data for Your Dashboards and Reports; Using the Get External Data Group; Using the MS Query Wizard; Managing External Data Properties; Chapter 13: Sharing Your Work with the Outside World
- Protecting Your Dashboards and Reports
