Excel Dashboards and Reports http://www.fishpond.co.nz/Books/Excel-Dashboards-and-Reports-Michael-Alexander-John-Walkenbach/9780470620120

Mr. Spreadsheet's Bookshelf

By Michael Alexander, John Walkenbach

$37.80 Price includes NZ wide delivery!

Buy Now

Ships from UK supplier

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.