Cover -- Title Page -- Copyright -- About the Authors -- About the Technical Editors -- Credits -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Topics Covered -- What You Need to Know -- What You Need to Have -- Conventions Used in This Book -- Excel commands -- Visual...

"Create versatile, engaging dashboards with Excel. Organizations are hungry for data-driven insights, and the need to turn large amounts of data into meaningful information has made building effective dashboards and reports more important than ever. As one of the most powerful and commonly used...

Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Obligatory Typographical Conventions Section -- Check Your Security Settings -- Foolish Assumptions -- Icons Used in This Book -- Sample Files Online -- Where to Go from Here -- Part 1 Getting...

John Walkenbach aka "Mr. Spreadsheet" is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for...

Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you...

The ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions....

Create dynamic dashboards and put your data on display with ForDummiesNo matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards Reports For Dummiesis here...

Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- Chapter 1: Important Database Concepts -- Traditional Limits of Excel and How Databases Help -- Scalability -- Transparency of analytical processes -- Separation of data and presentation -- Database Terminology --...