Excel PivotTables and PivotCharts can instantly reveal insights that would otherwise need to be pried loose with a crowbar -- or stay buried in your data forever. With Excel 2007, Microsoft has revamped these features. But expert guidance is as welcome as ever -- especially, the help and hands-on walkthroughs Peter Aitken offers here.
Aitken's no-experience-necessary tutorial starts with the absolute basics: choosing internal and external data sources. You'll master Excel 2007's updated PivotTable/PivotChart toolset, including its powerful PivotTable components. And, since owning a hammer doesn't make everything a nail, Aitken also explains when PivotTables aren't the best solution, and points you to better alternatives.
By now, you're ready for the "majors": using PivotTables with multidimensional data in real OLAP applications. Aitken demystifies this; then introduces the fine art of automating PivotTables with VBA. You'll never look at your data the same way again. Bill Camarda, from the May 2007 Read Only