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



Microsoft Excel 2002 is an incredibly versatile and easy-to-use spreadsheet program that can help you calculate and analyze numerical data for both large and small businesses. You can create simple spreadsheets, invoices, and even complex ledger reports. You even can save Excel data for use on the World Wide Web.

The What and Why of Microsoft Excel

Excel provides you with all the tools you need to quickly create many different types of business spreadsheets and reports. Whether you work at home or in a busy office, Microsoft Excel can help you do some heavy-duty number crunching. In Excel, you can

  • Create spreadsheets that include formulas and built-in Excel functions

  • Format numbers and text so that Excel printouts are easy to read

  • Use clip art, pictures, borders, and colors to add interest to your spreadsheets

  • Take Excel data and publish it to the World Wide Web

Additionally, Excel provides several features that make it easy for you to calculate the results of formulas and format your worksheets. You can

  • Use the Excel Function Wizard to help you choose the right function to calculate the appropriate result.

  • Use the Autoformat feature to quickly format an entire worksheet.

  • Use the new speech feature for voice dictation and voice commands.

While providing you with many complex features, Microsoft Excel is easy to learn. This book will help you understand the possibilities awaiting you with Microsoft Excel 2002.

Why Que's 10 Minute Guide to Microsoft Excel 2002?

The 10 Minute Guide to Microsoft Excel 2002 can save you precious time while you get to know the different features in Microsoft Excel. Each lesson is designed to be completed in 10 minutes or less, so you'll be up to snuff on basic and advanced Excel skills quickly.

Although you can jump around between lessons, starting at the beginning is a good plan. The bare-bones basics are covered first, and more advanced topics are covered later. If you need help installing Excel, see the next section for instructions.

Installing Excel

You can install Microsoft Excel 2002 on a computer running Microsoft Windows 98, Windows NT 4.0, Windows 2000, or Windows XP. You can purchase Microsoft Excel as a standalone product on its own CD-ROM or as part of the Microsoft Office XP suite (which comes on a CD-ROM). Whether you are installing Excel as a standalone product or as part of the Microsoft Office XP suite, the installation steps are basically the same.

To install Excel, follow these steps:

  1. Start your computer, and then insert the Excel 2002 or Microsoft XP Office CD in the CD-ROM drive. The CD-ROM should autostart, providing you with the opening installation screen (for either Excel or Office, depending on the CD with which you are working).

  2. If the CD-ROM does not autostart, choose Start, Run. In the Run dialog box, type the letter of the CD-ROM drive, followed by setup (for example, e:\setup). If necessary, use the Browse button to locate and select the CD-ROM drive and the setup.exe program.

  3. When the Setup Wizard prompts you, enter your name, organization, and CD key in the appropriate boxes.

  4. Choose Next to continue.

  5. The next wizard screen provides instructions to finish the installation. Complete the installation. Select Next to advance from screen to screen after providing the appropriate information requested by the wizard.

After you finish the installation from the CD, icons for Excel and any other Office applications you have installed will appear on the Windows Start menu. Lesson 2 in this book provides you with a step-by-step guide to starting Excel 2002.

Conventions Used in This Book

To help you move through the lessons easily, commands, options, and icons you need to select, and keys you need to press appear in bold type.

In telling you to choose menu commands, this book uses the format menu title, menu command. For example, the statement "Choose File, Properties" means to open the File menu and select the Properties command.

In addition to those conventions, the 10 Minute Guide to Microsoft Excel 2002 uses the following sidebars to identify helpful information:

Plain English

New or unfamiliar terms are defined in term sidebars.


Read these tips for ideas that cut corners and confusion.


This icon identifies areas where new users often run into trouble. These sidebars offer practical solutions to those problems.

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