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

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 ...

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