Working with Numbers: Excel 97 - 2003

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

Before you start... How these lessons work

These lessons are part of a set of tutorials, Jan's Illustrated Computer Literacy 101. The tutorials cover Windows, word processing, spreadsheets (which is the section you are in now!), the web, presentations, and databases.

Who is this for?

The whole course is designed for people who are new to computers, but even old pros need a refresher from time to time. You might even learn something new, or at least be reminded of tips and tricks that you have forgotten.

Clearly, if you are reading this page in a browser, you already have some computer skills, or else you have a handy helper or instructor close by.

What's covered?

The lessons in Working with Numbers will teach you a lot about spreadsheets - entering, moving, and editing cell data; formatting data and labels; creating and editing charts; working with formulas.

The Working with Numbers lessons assume that you have some experience with the basic skills in word processing- entering text, editing text, moving and deleting text, formatting text,  printing. If you are not familiar with these tasks, you should work through at least the first project in the Working with Words tutorial before tackling spreadsheets.

The lessons do build on one another, so if you skip one, you may get confused later. Documents you create may be used again in later lessons. Fair warning!

Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel Intro
    InterfaceTo subtopics
    Select & NavigateTo subtopics
    Common TasksTo subtopics
    ExercisesTo subtopics

Project 2: Excel Basics
    Getting StartedTo subtopics
    FormattingTo subtopics
    AutoFillTo subtopics
    FinishTo subtopics
    ExercisesTo subtopics

Project 3: Format & Arrange
    Format CellsTo subtopics
    Format ChartTo subtopics
    ArrangeTo subtopics
    ExercisesTo subtopics

Project 4: Groups & Formulas
    SubtotalsTo subtopics
    Images & DrawingsTo subtopics
    Changes & FormulasTo subtopics
    ExercisesTo subtopics

Project 5: Design
    AnalysisTo subtopics
    What If...To subtopics
    Logical TestsTo subtopics
    Sharing DataTo subtopics
    ExercisesTo subtopics


Lesson design

Each lesson has:

  • Topics -  info for you to read
  • Step-by-Step directions - for things to do at the computer.
  • Quiz - multiple choice questions
  • Exercises- to give you practice and to take you further.

Warning You must actually follow the directions while at the computer!!

You cannot just read about a technique and expect to be able to do it yourself later. It is different when you are doing it yourself!

printer icon You might want to print the steps out if your monitor or resolution is small. It can be hard to read directions on the screen while you are trying to follow the directions!

Tip You may can print just the parts you want. Select the part to print and either right click or go to the File menu and then the Print... command. There may be a choice in the dialog to print just the "Selection", depending on which browser and operating system you are using. This choice might be buried in Advanced settings.

Tip If you want to work with directions on the screen, you can switch between the directions in the browser and the application window where you are working by clicking on the taskbar icon or with the ALT + TAB key combination. Or, if you are using a high resolution, perhaps you can size your windows so that you can see both at the same time.

(These techniques are taught in the Working with Windows lessons.)

What you see may not match!

What you actually see on your computer may vary from what is shown and described here. Things change quickly in the world of computers. Don't let it fluster you!

  • New version or update - Each software revision has changes, some minor and some quite noticeable. Your software may be older or more recent than mine. Some of my images were captured from Excel 97 and some from Excel 2000/2002/2003.
  • Customized - Everyone likes to arrange things to suit themselves. So your computer may not have the default settings any more, and, therefore, not behave as the lessons describe. This, too, is part of the world of computers!

The Step-by-Step sections will explain how to set the features that will affect how your computer responds to the directions. If your computer still does not behave as you expected, look in the Help for the program or ask your instructor or network administrator (or a even more experienced friend). That's why they are there! [Note: You may not be allowed to change some settings on classroom or network computers.]

The directions and images were prepared originally in Excel 97 and have been updated for Excel 2000/2002/2003. Fortunately the newer versions are not much different in appearance. The basic skills and approach are the same, even when the details change. 

If you don't find something that the directions refer to, it may not have been installed. Many import/export filters are available on the installation CD but are not installed by default. Clipart may not have been copied to the hard drive.  In such a case, you must have the installation CD in the CD-ROM drive in order to access the clipart. You can rerun the installation program to add features that were overlooked before.

The templates and wizards will not be the same in a different brand of spreadsheet software and they sometimes change between versions of the same program. There may not be anything even close for some wizards. But the techniques of how to work with a template or a wizard are the same. 

Interrupted Work

You may need to stop before finishing all of the directions in a Step-by-Step section. Pay attention to what lesson page you are on when you quit. If you are sharing a computer, write down the page's address from the browser's address bar. If you are on your own computer, you can bookmark the page in the browser. Bookmarks on a classroom computer may not be there when you get back to it!

The Step-by-Step exercises will usually have a Start with: line that tells you what the situation should be when you start the exercise. This can help when you had to stop before finishing the document. The steps build on one another to complete a document, so don't try to skip steps even if you know how to do the skill being illustrated. Perhaps you'll learn a different way to accomplish a task!

icon-floppy disk Saving

If you were creating a document, don't forget to save it, or you will have lots to redo when you return to the computer! The directions will tell you to save to your Class disk. You can save to your hard drive if you are working on your own computer or if your instructor has assigned you space on the classroom computer.

The Step-by-Step directions have you save your work each lesson's work with a new name. That is not what we do normally in the real world. It is a real help, however, if you find that you need to start the lesson over. If you are saving to a floppy disk, it will get full. You probably will want to delete the older copies from time to time as you go along.

WarningDo not delete the documents you create for the Exercises. Keep a copy around because the exercises for a later project may use what you have already done.

How detailed

The amount of detail in the directions and illustrations will decrease as you gain more experience.

LessonsWorking with Numbers Next Page

Teachers: Request permission to use this site with your class

Copyright © 1997-2012 Jan Smith   <>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~

Last updated: 02 May 2012