• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Using the Book’s CD-ROM

Using the Book’s CD-ROM

The CD-ROM inside the back cover of this book contains all the practice files you’ll use as you work through the exercises in the book. 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 2003.


This book does not contain the Excel 2003 software. You should purchase and install that program before using this book.

Minimum System Requirements

To use this book, you will need:

  • Computer/Processor

    Computer with a Pentium 133-megahertz (MHz) or higher processor

  • Operating System

    Microsoft Windows 2000 with Service Pack 3 (SP3) or Microsoft Windows XP or later operating system

  • Memory

    64 MB of RAM (128 MB recommended) plus an additional 8 MB of RAM for each program in the Microsoft Office System (such as Word) running simultaneously

  • Hard Disk

    Hard disk space requirements will vary depending on configuration; custom installation choices may require more or less hard disk space.

    • 245 MB of available hard disk space with 115 MB on the hard disk where the operating system is installed.

    • An additional 4 MB of hard disk space is required for installing the practice files.

  • Drive

    CD-ROM drive

  • Display

    Super VGA (800 × 600) or higher-resolution monitor with 256 colors or higher

  • Peripherals

    Microsoft Mouse, Microsoft IntelliMouse, or compatible pointing device

  • Applications

    Microsoft Office Excel 2003, Microsoft Office PowerPoint 2003, Microsoft Outlook Express or Microsoft Office Outlook 2003, Internet Explorer version 5 or later

Installing the Practice Files

You need to install the practice files on your hard disk before you use them in the chapters’ exercises. Follow these steps to prepare the CD’s files for your use:

Insert the CD-ROM into the CD-ROM drive of your computer.

The Step by Step Companion CD End User License Agreement appears.


If the license agreement screen does not appear, start Windows Explorer. In the left pane, locate the icon for your CD-ROM drive and click the icon. In the right pane, double-click the file named StartCD or StartCD.exe.

It is necessary to accept the terms of the license agreement in order to use the practice files. After you accept the license agreement, the Step by Step Companion CD menu appears.

Click Install Practice Files.

Click Next on the first screen, and then click Yes to accept the license agreement on the next screen.

If you want to install the practice files to a location other than the default folder (C:\SBS\Excel), click the Browse button, select the new drive and path, and then click OK.

Click Next on the Select Features screen and then click Next on the Start Copying Files screen to install the selected practice files.

After the practice files have been installed, click Finish.

Within the installation folder are subfolders for each chapter in the book.

Remove the CD-ROM from the CD-ROM drive, and return it to the envelope at the back of the book.

Using the Practice Files

Each topic in the chapter explains how and when to use any practice files. The file or files that you’ll need are indicated at the beginning of the procedure in blue type, as shown here:

Open: SampleFile from the SBS\Excel\SampleFolder folder.

Usually you will be instructed to open the practice files from within Excel. However, you can also access the files directly from Windows by clicking Start, All Programs, Microsoft Press, Excel 2003 Step by Step. Locate the file in the chapter subfolder and double-click to open it.

The following table lists each chapter’s practice files.

1GettingToKnowXLFileOpen, ZeroIn, DataEntry, and Replace
2SettingUpWorkbookEasier, DataRead, and AddPicture
3PerformingCalculationsNameRange, Formula, and FindErrors
4ChangingDocAppearanceFormats, CreateNew, EasyRead, Conditional, Follow, and Margins
5UsingFiltersFilter, Calculations, and Validate
6MultipleSourcesTemplateStart, January, February, March, Linking, 2001Q1, Consolidate, TotalByHour2001, Y2001Q1, and Y2001ByMonth
7ReorderingAndSummarizingSorting and Levels
8AnalyzingAlternativeDataSetsDefining, Multiple, GoalSeek, Solver, and Descriptive
9PivotTableCreatePivot, EditPivot, Export, and External
10ChartsCreateChart, Customize, TrendLine, Dynamic, and Diagrams
11PrintingPrinting, Part, and PrintChart
12MacrosView, Record, Toolbar, Menu, and RunOnOpen
13OtherProgramsInclude, YearEndSummary, Worksheet, SalesByCategory, Hyperlink, ProductList, PasteChart, and ChartTarget
14DatabaseLookup, Query, Products, and Summary
15WebSaving, Publish, Pivot, WebData, Smart, and Structured
16CollaboratingSharing, Comments, Tracking, MergeTarget, Owner, Buyer, Protection, and Signature

Uninstalling the Practice Files

After you finish working through this book, you should uninstall the practice files to free up hard disk space.

On the Windows taskbar, click the Start button, point to Settings, and then click Control Panel.

Double-click the Add or Remove Programs icon.

Click Microsoft Office Excel 2003 Step by Step, and click Change/Remove.

Click OK when the confirmation dialog box appears.


If you need additional help installing or uninstalling the practice files, please see the section “Getting Help” earlier in this book. Microsoft’s product support does not provide support for this book or its CD-ROM.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint