The goal of this book is to show you how to leverage Excel functionality to build and manage better reporting mechanisms. Each chapter in this book provides a comprehensive review of the technical and analytical concepts that help you create better reporting components — components that can be used for both dashboards and reports. It’s important to note that this book is not a guide to visualizations or dashboarding best practices — although those subjects are worthy of their own book. This book is focused on the technical aspects of using Excel’s various tools and functionality and applying them to reporting.
The chapters in this book are designed to be stand‐alone chapters that you can selectively refer to as needed. As you move through this book, you’ll be able to create increasingly sophisticated dashboard and report components. After reading this book, you’ll be able to
✓✓Analyze large amounts of data and report them in a meaningful way.
✓✓Gain better visibility into data from different perspectives.
✓✓Quickly slice data into various views on the fly.
✓✓Automate redundant reporting and analyses.
✓✓Create interactive reporting processes.