آموزش Excel 2000-EN

[A M I R]

Excel 2000

​

[h=3]Excel Basics

The Excel Window

Entering and Editing Data

Working with Multiple Worksheets

Creating Formulas

Complex Formulas

Formatting Numbers

Using Functions

---

[h=3]Changing Worksheet Layout

Inserting and Deleting Rows and Columns

Adjusting Column Width and Row Height

Inserting and Deleting Cells

Moving and Copying Cell Contents

Aligning Text

Fonts, Color, and Borders

---

[h=3]Charting and Printing

Creating a Chart

Moving, Resizing, and Deleting Charts

Editing Charts

Using the Page Setup Dialog Box


Print Preview

Print



​

 

[A M I R]

[h=2]The Excel Window

[h=3]Introduction
Microsoft Excel 2000 is a spreadsheet application in the Microsoft Office

Suite. A spreadsheet is an accounting program for the computer. Spreadsheets are

primarily used to work with numbers much like Microsoft Word is used to work with

text. Spreadsheets calculate and analyze information by using mathematical formulas

[h=4]By the end of this lesson, learners should be able to:
Identify the parts of the Excel window


​

 

[A M I R]

[h=2]The Excel Window

[h=3]The Excel Window
When you open Excel, many items you see are standard in most Windows 95 or 98 programs. A few things are specific to Excel 2000.

​

 

[A M I R]

[h=2]The Excel Window

[h=5]Toolbars Toolbars can be customized and offer a series of commonly used Excel features
[h=5]Column Headings Each Excel spreadsheet has 256 columns
[h=5]Row Headings Each spreadsheet has 65,536 rows
[h=5]Name Box Shows the address and name of the current selection

[h=5]Formula Bar Displays the current entry (as you are typing or editing) or the contents of the current cell

[h=5]Cell An intersection of a column and row. Each cell has a cell address. In the above

picture, the cell address of the selected cell is A1. The heavy border around the selected cell is called the cell pointer.

[h=5]Navigation Buttons Allow you to move to another worksheet in an Excel workbook easily

[h=5]Sheet Tabs Allow you to move around the workbook easily



​

 

[A M I R]

[h=2]The Excel Window

[h=3]The Excel Workbook
When you open Microsoft Excel, a workbook automatically shows in the workspace.

[h=5]

Important Terms
A workbook is made up of three worksheets.

The worksheets are labeled Sheet1, Sheet2, and Sheet3.

Each Excel worksheet is made up of columns and rows.

In order to access a worksheet, click on the tab that says Sheet#.


​

 

[A M I R]

[h=2]The Excel Window

[h=5]To Change the Number of Worksheets:
Choose Tools

Options.

In the Options dialog box, click the General tab.

Click on the spin box controls (up and down arrows) to change the number of worksheets in a new workbook.

​

 

[A M I R]

[h=2]The Excel Window

[h=3]The Cell
The Excel worksheet is made up of columns and rows.When these

columns and rows intersect, they form little boxes called cells


[h=5]

Important Terms
Each cell has a unique cell address composed of a cell's column and row.
The active cell is the cell that receives the data or command you give it.
A darkened border, called the cellpointer, identifies it.

​

 

[A M I R]

[h=2]The Excel Window

[h=3]Moving the Cell Pointer
To activate any cell, click the cell.

To move the pointer one cell to the left, right, up, or down, use the keyboard arrow keys.

To see other areas of the worksheet, use the scroll bars. To scroll large

distances, hold the Shift key while dragging the scroll bar





​

 

[A M I R]

[h=2]The Excel Window

[h=5]Some frequently used keyboard commands:
PgDn: Down one screen


PgUp: Up one screen


Home: To column A in the current row


Ctrl + Home: To cell A1

​

 

[A M I R]

[h=2]The Excel Window

[h=3]Challenge!
Use the horizontal and vertical scroll bars to explore the Excel worksheet.

Now, explore using PgUp, PgDn, Home, and Ctrl + Home.

To see other areas of the worksheet, use the scroll bars. To scroll

large distances, hold the Shift key while dragging the scroll bar.

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=3]Introduction
[h=4]By the end of this lesson, learners should be able to:

• Enter and Delete data

• Edit data

• Select multiple cells

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=3]Entering Data
You can enter three types of data in a worksheet: text, numbers, and formulas. Text is

any entry that is not a number or formula. Numbers are values used when making calculations. Formulas are calculations.

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=5]To Enter Data into a Cell:
Click the cell

Begin typing the data.

An insertion point appears, and the text you are entering appears in the active cell and in the formula bar.

The formula bar buttons (Cancel button and Enter button) appear.

Clicking the Enter button

ends the entry and turns off the formula bar buttons

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=5]To Delete Data
Click the cell.

AND


Click the Cancel button

to delete an entry and turn off the formula buttons.

OR
Cancel an entry by pressing the Escape key.
OR
Right-click and choose Clear Contents from the shortcut menu.
OR
Select data and press Delete or Enter key.

Excel’s AutoComplete feature keeps track of text entered in a column

and can complete other entries in the same column. For example, if you typed

GCFLearnFree.org in cell A1 and enter "G" in A2, Excel automatically fills the cell

with GCFLearnFree.org. If GCF Global Learning is the text you want to enter, press

Enter or Tab to move to the next cell. If it’s not what you want, just keep typing

until you overwrite the AutoComplete feature



​

 

[A M I R]

[h=2]Entering and Editing Data

[h=3]Editing Data
You may find you need to edit or change data you enter into a cell. You can do this two ways.

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=5]Quick and Easy Method:

Click the cell and type the new entry; the old entry is replaced.

If the original entry is long and only requires a minor adjustment (in spelling, for example), edit the entry.

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=5]To Edit:
Click on the cell and edit the entry in the formula bar.
OR
Double-click on the cell. This opens the cell for direct editing.
Press Enter or click the Enter button on the Formula bar

to complete the entry.

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=3]Selecting Multiple Cells
In Excel, the cell that is currently selected is the active cell. A group of cells is called a range.

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=5]To Select a Range of Cells:
Move to the first cell in the range.

The mouse pointer becomes a large cross.

Hold down the left mouse button and drag to the last cell you want to select.

Release the mouse button.

The cells you selected are shaded.

​

 

[A M I R]

[h=2]Entering and Editing Data

[h=5]To Select All Cells in a Column or Row:
Click the Column or Row heading.




[h=5]To Select Multiple Columns or Rows:

Click one heading and drag to select the others.

​