PivotTables are one of the most powerful tools in Excel. In addition to the ability to quickly and conveniently aggregate source data, they allow you to change the structure of the analysis on the fly, moving fields from one area to another. In this book, you'll learn how to create basic PivotTables that can help reduce analysis time, as well as more complex tables with drill-down capabilities and accompanying charts. By the end of reading, you can create complete reporting systems based on dynamic PivotTables. The publication is intended for both experienced analysts and ordinary Excel users with basic skills in working with the program. To perform the examples described in the book, you need Microsoft Excel installed on the Windows platform.