Jordan Goldmeier and Purnachandra Duggirala, "Dashboards for Excel"  
English | ISBN: 1430249447 | 2015 | 572 pages | PDF | 32 MB

Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards that will have your managers singing your praises. The book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world. Throughout the book, the reader is challenged to think about Excel and data analytics differently―that is, to think outside the cell. This book will show you how to create dashboards in Excel quickly and effectively. Don’t wait―get started today.
Covers advanced Excel techniques mixing formulas and Visual Basic for Applications (VBA) to create interactive dashboards
Shows how dynamic charts and tables can be used to create dashboards that are constantly up-to-date and providing fresh information.
Demonstrates how to display important data summaries, analytics, and visualization all in the same Excel window!
Builds on a firm foundation of industry best practices and the author’s hard won real-world experience