Microsoft ® Office 2007 Business Intelligence

3.3. Selecting Data for the Excel Table

As shown in Figure 3-4 we're going to jump right in and turn the spreadsheet into an Excel table. We're not going to worry about arranging the data beforehand, because we'll be able to use the tools of an Excel table to sort and group the data. It's amazing to see how quickly we can change an ordinary spreadsheet into a much better-looking table in Excel 2007.

1. Click the Format As Table icon in the Styles menu group, on the Ribbon menu Home tab.

2. Click the Table Style Medium 14 icon in the pop-up gallery.

3. Click the cell-selection icon in the Format As Table dialog box, which allows you to then click directly on the spreadsheet.

4. Click the spreadsheet cell A2 and then hold the right mouse button down and drag ...