About the Author

Michael Alexander is a Microsoft Excel MVP who has written several books on advanced business analysis with Microsoft Access and Excel. Visit Michael at DataPigTechnologies.com for free Excel and Access training. 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.

Table of Contents

Introduction. Part I: Moving from Spreadsheets to Dashboards. Chapter 1: Introducing Dashboards. Chapter 2: Developing Your Data Model. Part II: Excel Chart Basics. Chapter 3: Introducing Excel Charts. Chapter 4: Understanding Chart Types. Chapter 5: Working with Chart Series. Chapter 6: Formatting and Customizing Charts. Part III: Going Beyond Tables and Charts. Chapter 7: Using Pivot Tables. Chapter 8: Using Pivot Charts. Chapter 9: Using Excel Sparklines. Chapter 10: Chartless Visualization Techniques. Part IV: Creating Advanced Dashboard Components. Chapter 11: Components that Show Trending. Chapter 12: Components that Group Data. Chapter 13: Components that Show Performance against a Target. Part V: Automating Your Dashboards and Reports. Chapter 14: Macro-Charged Reporting. Chapter 15: Adding Interactive Controls to Your Dashboard. Part VI: Working with the Outside World. Chapter 16: Importing Microsoft Access Data into Excel. Chapter 17: Sharing Your Work with the Outside World. Index.