Using the Book s CD | MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))

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	Folder\File
Chapter 1: What's New in Excel 2007	None
Chapter 2: Setting Up a Workbook	Creating\Exception Summary.xlsx Creating\Route Volume.xlsx
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	Formulas\VehicleMiles.xlsx Formulas\ITExpenses.xlsx Formulas\PackagingCosts.xlsx Formulas\ConveyerBid.xlsx
Chapter 5: Changing Document Appearance	Appearance\VehicleMileSummary.xlsx Appearance\HourlyExceptions.xlsx Appearance\HourlyTracking.xlsx Appearance\ExecutiveSearch.xlsx Appearance\Dashboard.xlsx Appearance\CallCenter.xlsx
Chapter 6: Focusing on Specific Data Using Filters	Focusing\PackageExceptions.xlsx Focusing\ForFollowUp.xlsx Focusing\Credit.xlsx
Chapter 7: Reordering and Summarizing Data	Sorting\ShippingSummary.xlsx Sorting\GroupByQuarter.xlsx Sorting\ShipmentLog.xlsx
Chapter 8: Combining Data from Multiple Sources	MultipleFiles\Daily Call Summary.xlsx MultipleFiles\Operating Expense Dashboard.xlsx MultipleFiles\Fleeting Operating Costs.xlsx MultipleFiles\January Calls.xlsx MultipleFiles\February Calls.xlsx MultipleFiles\Consolidate.xlsx
Chapter 9: Analyzing Alternative Data Sets	Alternatives\2DayScenario.xlsx Alternatives\Multiple Scenarious.xlsx Alternatives\Target Values.xlsx Alternatives\Ad Buy.xlsx Alternatives\Driver Sort Times.xlsx
Chapter 10: Creating Dynamic Lists with PivotTables	PivotTables\Creating.xlsx PivotTables\Creating.txt PivotTables\Focusing.xlsx PivotTables\Editing.xlsx PivotTables\Formatting.xlsx
Chapter 11: Creating Charts and Graphics	Charting\Yearly Package Volume.xlsx Charting\Volume by Center.xlsx Charting\Future Volumes.xlsx Charting\Revenue Analysis.xlsx Charting\Org Chart.xlsx
Chapter 12: Printing	Printing\Revenue by Customer.xlsx Printing\Pickups by Hour.xlsx Printing\Summary by Customer.xlsx Printing\Hourly Pickups.xlsx Printing\Corporate Revenue.xlsx
Chapter 13: Automating Repetitive Tasks with Macros	Macros\VolumeHighlights.xlsm Macros\Yearly Sales Summary.xlsx Macros\Performance Dashboard.xlsx Macros\RunOnOpen.xlsm
Chapter 14: Working with Other Microsoft Office System Programs	Other Programs\Summary Presentation.xlsx Other Programs\2007 Yearly Revenue Summary.pptx Other Programs\RevenueByServiceLevel.xlsx Other Programs\Hyperlink.xlsx Other Programs\Level Descriptions.xlsx Other Programs\Revenue Chart.xlsx Other Programs\Revenue Summary.pptx
Chapter 15: Collaborating with Colleagues	Sharing\Cost Projections.xlsx Sharing\Projections for Comment.xlsx Sharing\Projection Change Tracking.xlsx Sharing\SecureInfo.xlsx Sharing\Projections Signed.xlsx Sharing\Shipment Summary.xlsx

Minimum System Requirements

To run Office Excel 2007, your computer needs to meet the following minimum hardware requirements:

500 megahertz (MHz)
256 megabytes (MB) RAM
1.5 gigabytes (GB) available space
CD or DVD drive
1024x768 or higher resolution monitor

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:

1.	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.
2.	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. Important 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.
3.	Click Install Practice Files.
4.	Click Next on the first screen, and then click Yes to accept the terms of the license agreement on the next screen.
5.	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. Important If you are using Windows Vista, the default folder will be Documents\Microsoft Press\Excel SBS.
6.	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.
7.	After the practice files have been installed, click Finish.
8.	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:

1.	On the Windows taskbar, click the Start button, and then click My Documents. If you are using Windows Vista, click Documents, instead.
2.	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:

1.	In the Favorite Links pane in the dialog box, click My Documents. If you are using Windows Vista, click Documents, instead.
2.	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:

1.	On the Windows taskbar, click the Start button, and then click Control Panel.
2.	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.
3.	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.
4.	If a message box asks you to confirm the deletion, click Yes.