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

Figure 3-1 shows a real-world spreadsheet from a schoolteacher who tracks student reading levels and overall achievement scores. In this case, we have previous and current reading and full-scale scores, which is a simple representation of a year-to-year business process. The spreadsheet is not overly complex because it is from the real world of spreadsheets, and we're going to see how it can be enhanced with the business intelligence tools in Excel 2007.

Figure 3-1. A real-world Excel 2003 spreadsheet with no Excel table

The spreadsheet in Figure 3-1 is not connected to any data sources; ...

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