Using the Book s CD


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.

See Also

If you need additional help installing or uninstalling the practice files, see "Getting Help" later in this book.





MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net