Introduction to Spreadsheets: Using Microsoft Excel
Jery R. Stedinger
School of Civil and Envir. Engineering, Cornell University
January, 2000, updated for EXCEL 2000
CONTENTS
Introduction
Absolute & Relative Addressing
Tool Bar
Cell Naming
Have a Question?
Copying and Moving Cells
Workbooks and Worksheets
Saving and Printing Files
Entering Information
Creating Charts
Moving Around
Creating Macros
Selecting Blocks of Cells
Other Useful Macro Information
Formatting
Goal Seeking
Formulas
Solver
Functions
Numerical Precision
Other Features
Introduction
This introduction to Microsoft
Excel is designed to be read while you sit in front of a Macintosh
or PC running the program.
Excel runs on both PCs and Macintoshes.
The Windows 97,
Windows 98 for Macs, and 2000 versions are very similar.
This tutorial should get you started,
and give you the sense of its power.
This tutorial is pertinent for Excel 2000, Excel 97, and
Excel 98.
Spreadsheet programs (Lotus 1-2-3, Quattro, Excel) are software that present users with a
worksheet or matrix of rows and columns in which text, data, and formulas are stored.
Excel's
worksheet, scroll bars, formula bar, and menus are shown below.
They look slightly different
with different machines and versions of Excel.
An Excel worksheet can have thousands of rows and hundreds of columns.
An intersection of a
row and column is called a
cell
. Just as elements of an array are described by their row i and
column location j, cells are referred to by their row number and column letter:
A1, B2, C7, G55, AA256, etc.
When
selected
, a cell becomes the active cell.
In the figure below, cell A1 has been selected, as
can be seen because that cell is highlighted.
The cell's name, A1, appears in the formula bar
(immediately below the menu and above the worksheet).
If the cell contained text, data, or
formulas, they would appear in the formula bar.
Try typing something and editing what you
typed by
using the cursor
in the formula bar to insert or to select different letters or words.
When you have what you want in the cell, press
Enter, Tab, Return
, or click on the "check" next
to the formula bar.