Microsoft Word - Excel-I-2003 Tutorial.pdf

(1040 KB) Pobierz

This tutorial was adapted from a tutorial by

see its complete version at

http://www.fgcu.edu/support/office2000/excel/index.html

http://staff.aub.edu.lb/~acc/

Excel 2003 – Tutorial I

Spreadsheet Basics

•

Screen Layout

Title bar

Menu bar

Standard Toolbar

Other Tools

Task Pane

Adding and Renaming Worksheets

Format Painter

AutoFormat

Formulas and Functions

•

Modifying Worksheets

•

Formulas

Linking Worksheets

Relative, Absolute, and Mixed

Referencing

Basic Functions

AutoSum

Moving Through Cells

Adding Worksheets, Rows,

Columns, and Cells

Resizing Rows and Columns

Selecting Cells

Moving and Copying Cells

Deleting Rows, Columns, and Cells

Freeze Panes

Sorting and Filling

•

Basic Sorts

Complex Sorts

Auto-fill

Comparing Workbooks

•

Formatting Cells

•

Compare Side by Side

Formatting Toolbar

Format Cells Dialog Box

Formatting Worksheet

Dates and Times

Page Properties and Printing

•

Page Breaks

Page Setup

Margins

Header/Footer

Sheet

Print Preview

Academic Computing Center - AUB

http://staff.aub.edu.lb/~acc/

Excel 2003 - Tutorial I

Spreadsheet Basics

Microsoft Excel

is a spreadsheet program that you can use to organize, analyze and

attractively present data such as a budget or sales report. Each

Excel

file is a

workbook

that can hold many

worksheets.

The worksheet is a grid of

columns,

designated by

letters, and

rows,

designated by numbers. The letters and numbers of the columns and

row called

labels

are displayed in gray buttons across the top and left side of the

worksheet. The intersection of a column and a row is called a

cell.

Each cell on the

spreadsheet has a

cell address

that is the column letter and the row number. Cells can

contain text, numbers, or mathematical formulas.

Screen Layout

Name Box

Menu bar

Standard toolbar

Formula Bar

Formatting toolbar

Row 5

Column E

Cell E5

Worksheet tab

scroll buttons

Worksheet tabs

Task pane

Wednesday, January 18, 2006

2 of 19

Academic Computing Center - AUB

http://staff.aub.edu.lb/~acc/

Excel 2003 - Tutorial I

Title bar

The

Title

bar contains the name of the program

Microsoft Excel,

and the default name of

the workbook (Excel file)

Book 1

that would change as soon as you save your file and

give another name.

Menu bar

The

bar contains menus that include all the commands you need to use to work

your way through

Excel

such as

File, Edit, View, Insert, Format, Tools, Data,

Window,

and

Help

Standard Toolbar

This toolbar is located just below the

bar at the top of the screen and allows you to

quickly access basic

Excel

commands.

New

E-mail

Save

Research

Print Preview

Copy

Format Painter

Insert Hyperlink

Sort

Drawing

Help

Open

Permission

Spelling

Cut

Paste

Undo/Redo

AutoSum

Chart Wizard

Zoom

Toolbar

Options

Note:

If not all the list appears, press on the

Toolbar Options

button

placed at the end

of any toolbar, and press on

Add or Remove Buttons

tag, then select

Standard

and you

will get the possible commands for this toolbar.

•

New:

Select

File > New

from the

bar. The

New Workbook

pane

appears on the right hand side of the screen. Under the title

New

select

Blank workbook.

An alternative is to click the

New

button

found on

the

Standard

toolbar to create a new workbook.

Open:

Click

File > Open

from the

bar, or click the

Open

button

found on the

Standard

toolbar to open an existing workbook.

•

Save:

To save click on the

Save

button

found on the

Standard

toolbar. Choose a directory to save the file in. Specify a filename, and then

press

Save.

This is done only the first time you try to save a file. It is

recommended that you save your changes every ten minutes. All you have

to do is to press on the

Save

button, or simply go to

File > Save.

This will

update your initially saved file.

•

Wednesday, January 18, 2006

3 of 19

Academic Computing Center - AUB

http://staff.aub.edu.lb/~acc/

Excel 2003 - Tutorial I

•

Save As:

To save a different copy or version: Click on the

Save As

option

in the

File

menu, and save your document under a different name, or the

same name but in a different location.

Print:

Select

File > Print

from the

bar, or click the

button

found on the

Standard

toolbar to print a worksheet.

Print Preview:

Select

File > Print Preview

from the

bar, or click

the

Print Preview

button

found on the

Standard

toolbar to preview

the worksheet before it is printed.

•

Spelling:

Use the

Spelling

button

found on the

Standard

toolbar to

correct spelling errors on the worksheet.

and Format Painter

Cut, Copy, Paste,

actions are explained in the

Modifying Worksheets

section.

: These

•

Undo

and

Redo:

Click the backward

Undo

arrow to cancel

the last action you performed, whether it is entering data into a cell,

formatting a cell, entering a function, etc. click the forward

Redo

arrow to

cancel the

Undo

action.

Insert Hyperlink:

To insert a

hyperlink

to a Web site on the Internet,

type the text into a cell you want to be the link that can be clicked with the

mouse. Then, click the

Insert Hyperlink

button

found on the

Standard

toolbar and enter the Web address you want the text to link to

and click

OK.

AutoSum, Function Wizard,

and

Sorting:

These tools are discussed in

detail in the

Formulas and Functions

section.

Zoom:

To change the size of the worksheet that appears on the screen,

choose a different percentage from the

Zoom

option

the

Standard

toolbar.

found on

•

Other Tools

Formatting

toolbar: used to format text, for example font type / size / alignment /

color / text indentation. Also used to create bulleted / numbered lists, borders…

etc.

Drawing

toolbar: contains certain commands for drawing shapes, filling colors…

etc.

Note:

To add or remove a toolbar select from the

bar,

View

toolbars

and

then select the toolbar of your choice. A toolbar that is displayed has a check

beside it.

Scroll bars:

allow you to browse through a worksheet.

Wednesday, January 18, 2006

4 of 19

Academic Computing Center - AUB

http://staff.aub.edu.lb/~acc/

Excel 2003 - Tutorial I

Task Pane

The

Task Pane

appears each time you start

Excel.

To display or hide the task pane:

From the

bar, select

View > Task pane.

To close it, click on the small

button at

the top-left corner. The Task Pane is a dynamic tool found in the Office XP and 2003

suite applications. It allows you to perform certain actions/commands some of which are

shortcuts to commands provided by the

bar or

Standard

toolbar.

The task pane contains several options:

•

Getting started:

It allows you to connect to the internet to get more information

Microsoft Excel.

Moreover, you can open saved files from your local PC and

create a new workbook.

Help:

in case you are lost and you need some feedback. Under

Search for

you

can directly type your keyword and

Excel

will provide you with information

(on/offline).

Search Results:

Allows you to view the result of your previous search under

Help.

It allows you to enter a new search at the bottom of this pane.

Clip Art:

allows you to search the

Clip Art Gallery

using keywords.

Research:

if you are doing a research

Excel

can provide you with online

information. You can choose what type of reference books you would like

Microsoft to take into consideration while searching online.

Clipboard:

a list of the items you have recently

cut, pasted,

copied

New Workbook:

you can

open

a new blank workbook or select one from the

existing workbooks available in your local computer, or select one of the

templates saved in

Excel.

Shared Workspace:

you can create a document workspace if you want to share a

copy of your document. A workspace also enables you to invite others, assign

them tasks, and link to additional resources.

Adding and Renaming Worksheets

The worksheets in a workbook are accessible by clicking the

Worksheet

tabs in the

lower part of the screen. By default, three worksheets are included in the default

workbook. To add a sheet, select

Insert > Worksheet

from the

bar. To rename the

Worksheet

go to

Format > Sheet > Rename

or right-click on the tab with the mouse

and select

Rename

from the

Shortcut

menu or double click on the name of the sheet and

when it is highlighted you can type in the new name. Press the

Enter

key after having

typed in the new sheet name.

Modifying Worksheets

Moving Through Cells

Wednesday, January 18, 2006

5 of 19

Microsoft Word - Excel-I-2003 Tutorial.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: