Rights Contact Login For More Details
More About This Title Excel Dashboards & Reports
English
John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include Excel 2010 Formulas, Excel 2010 Power Programming with VBA, and the bestselling Excel Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.
English
Introduction 1
Part I: Moving from Spreadsheets to Dashboards
Chapter 1: Introducing Dashboards 11
Chapter 2: Developing Your Data Model 29
Part II: Excel Chart Basics
Chapter 3: Introducing Excel Charts 55
Chapter 4: Understanding Chart Types 75
Chapter 5: Working with Chart Series 109
Chapter 6: Formatting and Customizing Charts 139
Part III: Going Beyond Tables and Charts
Chapter 7: Using Pivot Tables 187
Chapter 8: Using Pivot Charts 221
Chapter 9: Using Excel Sparklines 245
Chapter 10: Chartless Visualization Techniques 259
Part IV: Creating Advanced Dashboard Components
Chapter 11: Components that Show Trending 279
Chapter 12: Components that Group Data 305
Chapter 13: Components that Show Performance against a Target 323
Part V: Automating Your Dashboards and Reports
Chapter 14: Macro-Charged Reporting 339
Chapter 15: Adding Interactive Controls to Your Dashboard 355
Part VI: Working with the Outside World
Chapter 16: Importing Microsoft Access Data into Excel 379
Chapter 17: Sharing Your Work with the Outside World 395
Index 411
