In this book, Excel legend Bill Jelen ("MrExcel") and Michael Alexander teaches PivotTables and PivotCharts step-by-step, using a realistic business scenario that every Excel user can intuitively understand. Coverage includes: "Create PivotTables, modify them, and change the way you see" Performing calculations in PivotTables "Using visualization PivotCharts and other" Analyze various sources of data with PivotTables "PivotTables Share with others" Working with and analyzing OLAP data "Making the most of features PowerPivot new powerful Excel 2010's "Using Excel 2010's Slicer to dynamically filter out PivotTables" Enhancing PivotTables with macros and code VBA This book is part of a series of Library new MrExcel, edited by Bill Jelen, the world famous Excel expert and host of Excel is very popular help site, MrExcel.com. New PowerPivot Teaching PivotTables, PivotCharts, and Excel 2010's features through a scenario of the real world that makes sense intuitively for users at all levels including proven recipe PivotTable to the results of on-the-job instant help Excel users avoid the pitfalls common and part the fault of the brand-new MrExcel Library series, edited by legend Excel Bill Jelen