Introducing Ms-Excel

Name of Module : Introduction to Microsoft Excel 2003

Learning Outcomes: The students should be able to:

1) State the steps to launch spreadsheet software
2) Launch a spreadsheet application
3) State and identify features in spreadsheet application and demonstrate
understanding of user interface State the main toolbars in spreadsheet
software
4) List icons in standard, formatting, formula and chart toolbars.
5) Create a new worksheet using spreadsheet software
6) Enter data into new worksheet
7) Copy, Cut, Paste and Delete data
8) Save the worksheet

students should be able to:

1) State the steps to launch spreadsheet software
2) Launch a spreadsheet application
3) State and identify features in spreadsheet application and demonstrate understanding of user interface State the main toolbars in spreadsheet software
4) List icons in standard, formatting, formula and chart toolbars.
5) Create a new worksheet using spreadsheet software
6) Enter data into new worksheet
7) Copy, Cut, Paste and Delete data
8) Save the worksheet


Activity 1: Launch Microsoft Excel


1. Click Start button at the Task Bar

2. Click All Programs

3. Click Microsoft Office to open Microsoft Excel application.

Activity 2: Introduction to MS Excel window.

Main menu consist of 9 commands (File, Edit, View, Insert, Format, Tools, Data, Window and Help) which is the first letter of the commands word was underline. Otherwise you can open all of the commands word with enter ALT + letter .
Example, enter ALT + F to open menu File.


The figure below shows the cell A1, (column A and row 1)

Activity 3: Open Worksheet MS Excel 2003

1. Creating Worksheet

(i) Click File at a main menu after that click New. The dialog box will appear. (ii) One new worksheet with name Book1 will open in a screen.

Activity 4: Entering Data

1. Enter a title in cell A1.

(a) Click cell A1.
(b) Type a title “KOPERASI SEKOLAH MENENGAH KEBANGSAAN BANDAR BARU”.
(c) Press Enter key.

2. Enter a text in cell A2, “JALAN LOMBONG, KOTA TINGGI”
cell A3, “JOHOR”

Note : Follow step 1

3. Enter text below

In cell A5, type “Customer “
In cell A6, type “Name:“
In cell B6, type “Computer Club “
In cell D6, type “Invoice Number: “
In cell E6, type “G1085 “
In cell A8, type “Address : “
In cell B8, type “SMK Bandar Baru “
In cell D8, type “Date “
In cell E8, type “8.9.05 “
In cell B9, type “Jalan Lombong, Kota Tinggi “
In cell B10, type “Johor“
In cell D10, type “L/O Number:“
In cell E10, type “12345 “

Your screen will be shown below.

5. Continue the next activity to save your workbook.

Activity 5: Save A Workbook

Use the Save or Save As command in File on the bar menu to save the document for the first time. There are few options to save your document. You can choose either one.

1. Save in My Document

The following examples shows how you can save a new document that you have open in Activity 1 in Floppy disk. This document will be saving as try.xls in My Document folder.

a. Click File on the bar menu.

b. Click Save As, then the Save As dialog box will appear.

c. The document will be save as try.xls file in My Documents folder