Excel’s pivot tables are a powerful tool for analyzing data. With only a few minutes of
work, a new user can create an attractively formatted table that summarizes thousands
of rows of data. This book assumes that you know the basics of Excel and pivot tables,
and provides troubleshooting tips and techniques, as well as programming examples.
This book is for anyone who uses pivot tables, and who reads the manual only when all
else fails. It’s designed to help you understand the advanced features and options that are
available, as you need them. Experiment with pivot tables, and if you get stuck, search for
the problem in this book. With luck, you’ll find a solution, a workaround, or, occasionally,
confirmation that pivot tables can’t do what you want them to do.