Excel 2007 PivotTables and PivotCharts
Chapter One
Understanding
PivotTables and Charts
In this chapter, you learn about PivotTables and PivotCharts, which are powerful
data-analysis tools in Excel. They are invaluable for pulling meaning from
huge masses of seemingly meaningless data. Given their power, PivotTables
and PivotCharts are surprisingly easy to use, but using them still involves
many unavoidable complexities. This book teaches you how to use PivotTables
and PivotCharts efficiently and effectively. As the first step, you need to understand
what these tools are and when you might want to use them.
In This Chapter
* Understanding how PivotTables work
* Working with PivotTables
* Creating a PivotTable report
* Creating a PivotTable report with multiple columns
* Using the PivotTable and PivotChart Wizard
* Creating a PivotChart
Understanding How PivotTables
Work
PivotTables enable you to extract meaning from large amounts of data. This
description is deceptively simple because in fact Pi ... read full excerpt from Excel 2007 PivotTables and PivotCharts ebook