آموزش Excel 2000-EN

[A M I R]

[h=2]Entering and Editing Data

[h=5]To Select the Entire Worksheet:
Click the gray rectangle in the upper left corner to select entire worksheet .

If the cells and columns you want to select are not directly next to one

another, select one of the ranges you want to select, and hold down the Control key

while selecting other ranges. For example, you may want to select column A and

column C, but not column B.



​

 

[A M I R]

[h=2]Entering and Editing Data

[h=3]Challenge!
Practice selecting a range of cells using one of the methods taught in this lesson:

Click on a cell and drag to select a number of cells.

Click a column or row heading.

To Select Entire Worksheet, click the gray rectangle in the upper left corner.

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

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

• Name Worksheets

• Insert and Delete Worksheets

• Group and Ungroup Worksheets

• Copy and Move Worksheets

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

[h=3]Naming Worksheets
When working with an Excel workbook, it's not always easy to remember

where your data is located. Give each worksheet a descriptive name so you can find it within the workbook.

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

To Name a Worksheet:



Double-click the sheet tab to select it.

Type a new name for the worksheet.

Press Enter.

Now, the worksheet has a descriptive name.

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

[h=3]Inserting and Deleting Worksheets
To Insert a New Worksheet:

Choose Insert

Worksheet.

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

To Delete one or more Worksheets:

Click on the sheet and choose Delete Sheet from the Edit menu.

-or-

Right Click on the Sheet Tab and select Delete from the shortcut menu.


​

 

[A M I R]

[h=2]Working with Multiple Worksheets

[h=3]Grouping Worksheets
A workbook is a multi-page Excel document. It is made up of multiple worksheets.

When you select more than one worksheet, you are grouping your

worksheets. Duplicate information is entered into all sheets in a group.

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

To Select One Worksheet, simply click a sheet tab.


To Select More than One Worksheet, hold the Control key down and click on the sheet tab of each worksheet.

To Select All Worksheets in a Workbook, right-click on any sheet tab

and choose Select All Sheets from the shortcut menu

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

[h=3]Grouping and Ungrouping Worksheets
When worksheets are grouped, the information you enter into one worksheet is

entered into all sheets in the group. Grouping worksheets saves you time; it eliminates all that cutting and pasting

Remember to ungroup worksheets after you are finished entering, moving, or copying common data.



​

 

[A M I R]

[h=2]Working with Multiple Worksheets

To Ungroup Worksheets:


Right-click on any of the selected sheet tabs.

Choose Ungroup Sheets from the shortcut menu.

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

[h=3]Copying and Moving Worksheets
Remember, when you copy a sheet, you are doing just that--making a

copy. When you move a sheet, you are moving it to a new location


To move a worksheet within the same workbook, drag the sheet tab to the new

location (a small black triangle appears) and drop it. To copy it, hold the Control key down while dragging the worksheet to its new location

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

To Move or Copy between Workbooks:

Select the worksheet you want to move/copy.

Choose Edit

Move or Copy.

In the Move or Copy dialog box, use the drop down boxes to select the name

of the workbook you are copying the sheet to, and where you want the sheet positioned in the workbook


Check Create a copy to copy it.

Click OK.

​

 

[A M I R]

[h=2]Working with Multiple Worksheets

[h=3]Challenge!
Open a new workbook and name each of the worksheets something

other than Sheet1, Sheet2, or Sheet3. Name your worksheets descriptively so you can remember what data each sheet contains


Group all three sheets.

Enter some information into the grouped worksheets.

Navigate your workbook and observe how your information was copied to all grouped worksheets.

Ungroup all three worksheets.

​

 

[A M I R]

[h=2]Creating Formulas

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


​

 

[A M I R]

[h=2]Creating Formulas

[h=3]Creating Formulas
In school, you may have had to memorize certain formulas in order to work

math problems. Microsoft Excel uses formulas to perform calculations

within a spreadsheet. In this lesson, you will learn how to use Excel’s formula features

[FONT=Arial, Helvetica, sans-serif]Addition	[FONT=Arial, Helvetica, sans-serif]+
[FONT=Arial, Helvetica, sans-serif]Subtraction	[FONT=Arial, Helvetica, sans-serif]-
[FONT=Arial, Helvetica, sans-serif]Multiplication	[FONT=Arial, Helvetica, sans-serif]*
[FONT=Arial, Helvetica, sans-serif]Division	[FONT=Arial, Helvetica, sans-serif]/
[FONT=Arial, Helvetica, sans-serif]Exponentiation (to the power of)	[FONT=Arial, Helvetica, sans-serif]^
[FONT=Arial, Helvetica, sans-serif]Precedence (do this operation first)	[FONT=Arial, Helvetica, sans-serif](put in parentheses)
[FONT=Arial, Helvetica, sans-serif]Equal to	[FONT=Arial, Helvetica, sans-serif]=
[FONT=Arial, Helvetica, sans-serif]Not equal to	[FONT=Arial, Helvetica, sans-serif]< >
[FONT=Arial, Helvetica, sans-serif]Greater than	[FONT=Arial, Helvetica, sans-serif]>
[FONT=Arial, Helvetica, sans-serif]Less than	[FONT=Arial, Helvetica, sans-serif]<

​

 

[A M I R]

[h=2]Creating Formulas

[h=3]Creating a Simple Formula
Let's start with a simple formula that contains one mathematical operation. All

formulas begin with the equal sign (=), whether the formula consists of

adding, subtracting, multiplying, or dividing. Here's an example of a simple formula: =B2-B3

​

 

[A M I R]

[h=2]Creating Formulas

[h=5]To Create a Simple Formula using the Point and Click Method:
Enter the numbers you want to calculate.

Click the cell where you want the result to appear.

Type =.

Click on the first cell to be included in the formula.

Type a mathematical operator (Ex: the addition symbol +). The operator displays in the cell and Formula bar.

Click on the next cell in the formula.

Repeat steps 4 and 5 until the entire formula is entered.

Very Important: Press Enter or click the Enter button on the Formula bar. This step ends the formula.

If you simply move to another cell, Excel will include that cell in the formula

Click the = sign button on the formula bar rather than the = sign on the keyboard

to open the Formula Palette. The Formula Palette lets you see the progress of a formula as you enter it.

​

 

[A M I R]

[h=2]Creating Formulas

[h=3]Challenge!
In cell A1, type 1,234.

In cell A2, type 15,865.

Click the cell where you want the result to appear.

Type =.

Click on A1.

Type the addition symbol (+). It displays in the cell and Formula bar.

Click on A2.

Very Important: Press Enter or click the Enter button

on the Formula bar. This step ends the formula and your result appears.

​

 

[A M I R]

[h=2]Complex Formulas

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

• Create complex formulas

• Fill a formula to another cell

• Copy and paste a formula to another cell

• Revise a formula

• Create an absolute reference

​