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.2. Opening an Excel 2003 Spreadsheet in Excel 2007

Figure 2-1 shows a real-world spreadsheet for cell phone plans from the telecommunications industry, used to present phone plans to prospective customers. This spreadsheet does not have an overly large amount of data because it is meant to represent the Excel 2003 files that are commonly a part of today's working environment. (It should be noted, however, that whereas Excel 2003 could hold 65,000 rows, Excel 2007 can hold up to a million rows of data!) This chapter will help you understand how to use PivotTables and PivotCharts with your working spreadsheets as well.

The spreadsheet in Figure 2-1 is not connected to any data sources; all data is contained in the cells shown. Because this spreadsheet ...

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