This chapter will introduce you to the power of pivot tables and provide you with the knowledge to create straightforward but useful reports.
Pivot tables can summarize one million rows with five clicks of the mouse button. They’re so powerful with so many options that this chapter cannot cover it all. This chapter is meant to provide you with the tools to create straightforward, but useful, pivot tables. If you find your needs not covered by the sections in this chapter, refer to Pivot Table Data Crunching: Microsoft Excel 2010 (ISBN 0-7897-4313-2) by Bill Jelen and Michael Alexander.
Excel is required to create pivot tables, but the functionality in an existing pivot table will carry over to Excel Starter and Web App.