O'Reilly logo

Microsoft ® Office 2007 Business Intelligence by Doug Harts

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2.3. Getting Started: Selecting Data for the PivotTable

As shown in Figure 2-4 we're going to select all the data in the spreadsheet and see what we can do with the PivotTable tools in Excel. We're not going to worry about selecting just part of the data—we'll just go with everything and choose what we want from the PivotTable user interface. We can also just click the PivotTable icon itself instead of the drop-down arrow on the icon; we'll go immediately to the Create PivotTable dialog box and bypass the choice of PivotTable versus PivotChart.

  1. Left-click the top-left corner of data Cell A2, and while holding down the left mouse button drag the cursor to the bottom-right corner of data Cell M11.

  2. Click the Insert tab on the Ribbon menu, and then ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required