Using the Book's CD
The companion CD included with this book contains practice files you can use as you work through the book's exercises. By using practice files, you won't waste time creating samples and typing spreadsheet data. Instead, you can jump right in and concentrate on learning how to use Microsoft© Office Excel© 2007.
What's on the CD?
The following table lists the practice files supplied on the book's CD.
Chapter 1: What's New in Excel 2007
Chapter 2: Setting Up a Workbook
Chapter 3: Working with Data and Data Tables
Data and Data Tables\Series.xlsx
Data and Data Tables\2007Q1ShipmentsByCategory.xlsx
Data and Data Tables\Average Deliveries.xlsx
Data and Data Tables\Service Levels.xlsx
Data and Data Tables\Driver Sort Times.xlsx
Chapter 4: Performing Calculations on Data
Chapter 5: Changing Document Appearance
Chapter 6: Focusing on Specific Data Using Filters
Chapter 7: Reordering and Summarizing Data
Chapter 8: Combining Data from Multiple Sources
MultipleFiles\Daily Call Summary.xlsx
MultipleFiles\Operating Expense Dashboard.xlsx
MultipleFiles\Fleeting Operating Costs.xlsx
Chapter 9: Analyzing Alternative Data Sets
Alternatives\Driver Sort Times.xlsx
Chapter 10: Creating Dynamic Lists with PivotTables
Chapter 11: Creating Charts and Graphics
Charting\Yearly Package Volume.xlsx
Charting\Volume by Center.xlsx
Chapter 12: Printing
Printing\Revenue by Customer.xlsx
Printing\Pickups by Hour.xlsx
Printing\Summary by Customer.xlsx
Chapter 13: Automating Repetitive Tasks with Macros
Macros\Yearly Sales Summary.xlsx
Chapter 14: Working with Other Microsoft Office System Programs
Other Programs\Summary Presentation.xlsx
Other Programs\2007 Yearly Revenue Summary.pptx
Other Programs\Level Descriptions.xlsx
Other Programs\Revenue Chart.xlsx
Other Programs\Revenue Summary.pptx
Chapter 15: Collaborating with Colleagues
Sharing\Projections for Comment.xlsx
Sharing\Projection Change Tracking.xlsx
Minimum System Requirements
To run Office Excel 2007, your computer needs to meet the following minimum hardware requirements:
Installing the Practice Files
You need to install the practice files in the correct location on your hard disk before you can use them in the exercises. Follow these steps:
Remove the companion CD from the envelope at the back of the book, and insert it into the CD drive of your computer.
The Step By Step Companion CD license terms appear.
Follow the on-screen directions. To use the practice files, you must accept the terms of the license agreement.
After you accept the license agreement and click Next, a menu screen appears.
If the menu screen does not appear, click the Start button and then click Computer. Display the Folders list in the Navigation pane, click the icon for your CD drive, and then in the right pane, double-click the StartCD executable file.
Click Install Practice Files.
Click Next on the first screen, and then click Yes to accept the terms of the license agreement on the next screen.
If you want to install the practice files to a location other than the default folder (My Documents\Microsoft Press\Excel SBS), click the Browse button, select the new drive and path, and then click OK.
If you are using Windows Vista, the default folder will be Documents\Microsoft Press\Excel SBS.
Click Next on the Choose Destination Location screen, and then click Install on the Ready to Install the Program screen to install the selected practice files.
After the practice files have been installed, click Finish.
Close the Step by Step Companion CD window, remove the companion CD from the CD drive, and return it to the envelope at the back of the book.
Using the Practice Files
When you install the practice files from the companion CD that accompanies this book, the files are stored on your hard disk in chapter-specific subfolders under My Documents\Microsoft Press\Excel SBS. Each exercise is preceded by a paragraph that lists the files needed for that exercise and explains any preparations needed before you start working through the exercise. Here are examples:
USE the ForFollowUp workbook in the practice file folder for this topic. This practice file is located in the My Documents\Microsoft Press\Excel SBS\Focusing folder.
BE SURE TO start Excel 2007 before beginning this exercise.
OPEN the ForFollowUp workbook.
You can browse to the practice files in Windows Explorer by following these steps:
On the Windows taskbar, click the Start button, and then click My Documents. If you are using Windows Vista, click Documents, instead.
In the My Documents or Documents folder, double-click Microsoft Press, double-click Excel SBS, and then double-click a specific chapter folder.
You can browse to the practice files from a dialog box by following these steps:
In the Favorite Links pane in the dialog box, click My Documents. If you are using Windows Vista, click Documents, instead.
In the My Documents or Documents folder, double-click Microsoft Press, double-click Excel SBS, and then double-click the specified chapter folder.
Uninstalling the Practice Files
You can free up hard disk space by uninstalling the practice files that were installed from the companion CD. The uninstall process also deletes any files that you created in the Microsoft Press\Excel SBS chapter-specific folders while working through the exercises. Follow these steps:
On the Windows taskbar, click the Start button, and then click Control Panel.
In Control Panel, click Add or Remove Programs. If you are using Windows Vista, in Control Panel, under Programs, click the Uninstall a program task.
In the Add or Remove Programs window, click Microsoft Excel 2007 Step by Step, and click Remove. If you are using Windows Vista, in the Programs and Features window, click Microsoft Office Excel 2007 Step by Step, and then on the toolbar at the top of the window, click the Uninstall button.
If a message box asks you to confirm the deletion, click Yes.
If you need additional help installing or uninstalling the practice files, see "Getting Help" later in this book.