Microso
ft
O
ffi
ce Excel 2003
Lecture 11.1
How to open the MS Excel
•
All Programs
Æ
Microsoft Office
Æ
Microso
ft
O
ffi
ce Excel 2003
Dr. Abu‐Arqoub ٢
“Book 1” is a workbook
Each one is a worksheet. So, a workbook may
Page Setup
‐
Margins
•
File
Æ
Page Setup
Dr. Abu‐Arqoub ٣
Determine value of Margin
Note: We will not go over anything here in Excel, since
they are some common features between Excel and
Word and we already covered
them. Horizontally or
Page Setup
‐
Header and Footer
• Note: We will not go over File, Edit, …etc since we covered them in MS word 2003.
Dr. Abu‐Arqoub ٤
Click for Footer
Click for Header Note: Another way
to view Header and Footer by
View Menu
View ÆHeader
Page Setup
‐
Header and Footer
Dr. Abu‐Arqoub ٥
Change Font Format
Insert content in the left of header
Insert content in the center of header
Insert content in the right of header Page Number Number of pages Insert Time Insert Date Insert
Picture Footer is
Row, Column & Cell
•
Sheet is composed of
Rows (Labeled 1, 2, 3, 4
, etc.) and
Columns (Labeled A, B, C, D
, etc.). The “
intersection
” of
each
row
and
column
is called a
cell
. In the image the
cursor is on
the “
home
”
cell
–
A1
.
No
ti
ce Row 1 and Column A are
“bold,”
and
colored “orange.”
This
indicates
what is called
the “
address
of the
cell
.
Notice right above cell A1
, that
A1
is
displayed
in a
small box
called the
Name Box
. Whenever you
“click” on a cell the address of that cell will be shown in the
Name Box.
Dr. Abu‐Arqoub ٦
Select Cells
•
Double Click on a cell will let you fill the data in the cell.
•
You can click on a cell to select this cell.
•
To Select more than one cell, you can click the left button
while you are moving over these cells.
•
To select more than one area of the cells, you can click the
left button while, you can keep holding the CTRL key and
pressing the left mouse button while you are moving over
these areas.
Selecting Columns, Rows, and
whole sheet
Dr. Abu‐Arqoub ٨
To select Column “A”, Click here on the cell that
holds its name
To select Row“4”, Click here on the cell that
holds its name
Change Column width or Row
Height
Dr. Abu‐Arqoub ٩
Slowly move the mouse arrow to the right edge
of the B cell (between the B and the C). The cursor will turn into an arrow pointing right and
left with a small vertical line in the middle (see
arrow beside). Hold down the left mouse button and move (drag)
the line to the right. Note: Changing
row height is the same way of changing column
Change Column width or Row
Height
•
Here is
another way for changing column
width
. Point to the
B at the top of column B
(in
the
Gray
area) and
click
the
left
mouse button
(The
cell
should turn
dark blue
and the
column
light blue
.).
Dr. Abu‐Arqoub ١٠
•
Now,
keeping
the
cursor
somewhere in the
“
blue
” area,
click
the
Right Mouse Button
.
Notice that a
menu
with
Column Width…
appears.
Click
‐on
Column Width…
and
type
in
the width you need and
click OK
.
Note: Changing row height is the same
Insert Column or Row
Dr. Abu‐Arqoub ١١
While you are selecting a row, right click here and choose Insert and then a
new row will be added above this row
Note: Same way for
Insert Column or Row
Dr. Abu‐Arqoub ١٢
A new row will be inserted above the row
where the cursor is located in.
A new column will be inserted to the left of the column where the cursor
Worksheets
Dr. Abu‐Arqoub ١٣
To insert a new worksheet. You can use
Insert menu too. Insert Æ Worksheet Right click on a
sheet and a menu will
appear
Delete worksheet
Rename worksheet
Change the color of this tab (the name of the
Format Rows & Columns
Dr. Abu‐Arqoub ١٤
Change the height of the row
Hide the row that the cursor in
Unhide any hidden rows, if any, between the selected
rows.
Change the width of the column
Hide the column that the cursor in
Unhide any hidden columns, if any, between the selected
Format Worksheet
Dr. Abu‐Arqoub ١٥
Rename the current opened
sheet
Hide the current opened sheet Choose a picture from
file as a background for this sheet
Choose the color of the tab for the current opened
sheet A window will
appear to choose which sheet you want
Format Cells
Dr. Abu‐Arqoub ١٦
At first, a single cell or a group of cell can be
selected to be
formatted. Then, we go to Format Æ Cells
Based on user’s needs, choose the category. For
example, if you want to add “$”, or want to ensure that 3 decimal points are appeared…
etc
Font, Border, and Pattern: we already have
covered this window in MS
Format Cells
Dr. Abu‐Arqoub ١٧
Number Category Determine number of decimal
points
Choose the currency symbol
Currency Category: Determine number of decimal
Format Cells
Dr. Abu‐Arqoub ١٨
Percentage Category: Determine number of
decimal points
Text Category: When you have a text
Format Cells
Dr. Abu‐Arqoub ١٩
Horizontally text alignment.
Vertically text alignment.
This option will increase the row height
to fit the cell contents.
Choose the text direction here as
you want
Decrease the size of contents [Font Size] to
fit in the cell
Merge the selected cells
Conditional Format
1. Select the cells for which you want to add, change, or remove
conditional
formatting
.
2. On the
Format
menu, click
Conditional Formatting
.
3. Do one of the following:
– To use values in the selected cells as the formatting criteria, click Cell Value Is, select the comparison phrase, and then type a constant value or a formula. If you enter a formula, start it with an equal sign (=).
– To use a formula as the formatting criteria (to evaluate data or a condition other than the values in selected cells), click Formula Is and then enter the formula that evaluates to a logical value of TRUE or FALSE.
4. Click
Format
.
5. Select the formatting you want to apply when the cell value meets the
condition or the formula returns the value TRUE.
6. To add another condition, click
Add
, and then repeat steps 1 through 3.
– You can specify up to three conditions. If none of the specified conditions are true, the cells keep their existing formats.
Insert Menu
•
Insert Symbol, Picture [Clip Art or From File], AutoShape,
WordArt, or Diagram are the same as MS Word 2003.
•
In addition that Insert
Æ
Object
Î
“Microsoft Equation 3” is
the same when we insert equations in MS Word 2003.
