Chapter 2. PivotTables, PivotCharts, and Conditional Formatting

This chapter starts with the basics of PivotTables to give you an understanding of this Excel analysis tool. It continues with a complete exploration of Excel 2007 PivotTable features, and then includes conditional formatting, which helps us see relative data values and ranges across thousands of rows of data. We'll discuss PivotCharts, along with some more advanced PivotTable data to round out this subject area of Microsoft business intelligence. This chapter will provide examples and explanations of the following:

  • Creating a PivotTable

  • Conditional formatting

  • Adding a PivotChart

  • Slicing and dicing the PivotTable and PivotChart

NOTE

For further reasearch on this topic, go to http://office.microsoft.com/office/excel/training ...

Get Microsoft ® Office 2007 Business Intelligence now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial