آموزش کامل Excel 2003 -EN

[A M I R]

[h=2]Enter, edit and delete 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.

​

 

[A M I R]

[h=2]Enter, edit and delete data

[h=3]Challenge!

• Open your Monthly Budget file.
• Type the following data in the spreadsheet:

• In cell A1, type Monthly Budget.

• In cell A2, type Rent or Mortgage.

• In cell A3, type Car Payment.

• In cell A4, type Cable.

• In cell A5, type Power.

• In cell A6, type Phone.

• In cell A7, type Insurance.

• In cell A8, type Credit Cards.

• In cell A9, type Groceries.
  

• Type your other monthly bills in Column A, cells A11-A14 (if you have any).

• Type Total Monthly Expenses in cell A15.

• Type Income in cell A16.

• Type Savings in cell A17

• .
  
• Save and close the Monthly Budget file.

​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

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

• Copy and paste cell contents

• Cut and paste cell contents

• Move cell contents using drag-and-drop

​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=3]Cut, copy, paste defined
Cut, Copy and Paste are very useful operations in Excel. You can quickly copy and/or cut

information in cells (text, numbers or formulas) and paste them into other cells. These

operations save you a lot of time from having to type and retype the same information



The Cut, Copy and Paste buttons are located on the Standard toolbar.

The Cut, Copy and Paste operations also appear as choices in the Edit menu:

The Cut, Copy and Paste operations can also be performed through shortcut keys:

Cut	Ctrl+X
Copy	Ctrl+C
Paste	Ctrl+V

​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=3]Copy and Paste Cell Contents


The Copy feature allows you to copy selected information from the spreadsheet and

temporarily place it on the Clipboard, which is a temporary storage file in your computer's

memory. The Paste feature allows you to select any of the collected items on the

Clipboard and paste it in a cell of the same or different spreadsheet.

​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=5]To Copy and Paste:

• Select a cell or cells to be duplicated.
• Click on the
  
  Copy button on the standard toolbar.

• The border of the copied cell(s) takes on the appearance of marching ants.
  
  
  
• Click on the cell where you want to place the duplicated information. The cell will be highlighted. If you
• are copying contents into more than one cell, click the first cell where you want to place the duplicated information.
  
  
  
• Press the Enter key. Your information is copied to the new location.

Be careful if you paste copied cell information into cells that already contain data. If you do, the existing data is overwritten.

You can copy information from many different sources including Web sites, emails or other

Office applications like Word and PowerPoint and paste it into an Excel spreadsheet.


​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=3]Cut and Paste Cell Contents

The Cut feature allows you to remove information from cells in the spreadsheet. Information

that is cut can be pasted in another cell, as long as the pasting occurs before you perform

another operation. If you don't paste the cut information immediately, it is removed from the Office clipboard.

​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=5]To Cut and Paste:

• Select a cell or cells to be cut.

• Click on the Cut
  
  button on the Standard toolbar.

• The information in the cell is deleted

• The border of the cut cell(s) take on the appearance of marching ants

• Click on the cell where you want to place the duplicated information. The cell
• will be highlighted. If you want to paste the contents into more than one cell, click the first cell where you want to place the duplicated information.

• Press the Enter key. Your information is pasted to the new location.

You do not have to paste information that has been cut. You can use Cut to delete information from a cell.


​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=3]Moving Information Using Drag-and-Drop
Another way to move information from one cell to another is to use the drag-and-drop method. You

use the cursor to point to the information to be moved and then drag the cell to its new location.



​

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=5]To Use Drag and Drop:


Highlight and select the cell(s) you want to move to a new location.


Position the mouse pointer near one of the outside edges of the selected cell(s). The mouse

pointer changes from a large, white cross and becomes a slender, black cross with arrows at all ends.

• 
• Keep the mouse pointer on the outer edge of the selected cell, click and hold the left mouse button and drag the cell(s) to a new location.
  
  
  
• Release the mouse button to move the information to its new location.

 

[A M I R]

[h=2]Moving, Copying and Deleting Cell Contents

[h=3]Challenge!

Open your Monthly Budget file.

Move the word Insurance from cell A7 to A4 and the word Cable from A4 to A7 using the

cut, copy, and paste, and drag and drop features you learned in this lesson.


Type January in C1.


Type the corresponding amounts for your monthly expenses and income in Column C.

• In cell C2, type your rent/mortgage bill amount.
• In cell C3, type your Car Payment amount.
• In cell C4, type your Insurance bill amount.
• In cell C5, type your Power bill amount.
• In cell C6, type your Phone bill amount.
• In cell C7, type your Cable bill amount.
• In cell C8, type your Credit Card bill amount.
• In cell C9, type your Grocery/Food bill estimate.
• In cell C10, type your Gas bill estimate.
• In cells C11 - C14, type the amount of any additional bills you have listed.
• In cell C16, type your Income.

Save and close the Monthly Budget file.


Note: Be sure to leave cells C15 and C17 blank.




​

 

[A M I R]

[h=2]Creating Simple Formulas

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

• Understand the parts of an Excel formula

• Create a simple addition formula

• Create a simple subtraction formula using the Point-and-Click Method

• Create simple multiplication formulas

• Create simple division formulas

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=3]About Formulas


In school, you learned formulas used to calculate math problems. Microsoft Excel uses these same formulas to perform calculations in a spreadsheet.


A formula can be a combination of values (numbers or cell references) and math operators (+, -, /, *, =) into an

algebraic expression. Excel requires every formula to begin with an equal sign (=).




The following table illustrates the mathematical operators learned in school and those represented in Excel 2003.

	School	Excel 2003
Addition	+	+
Subtraction	-	-
Multiplication	X	*
Division	/	/
Equals	=	=

The result of a formula-the answer to 2+3, for example-displays in the cell on the Excel worksheet. The formula is visible only in the formula bar. A formula's result will change as different numbers are entered into the cells included in the formula's definition.

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=3]Creating a Simple Addition Formula

A simple formula in Excel contains one mathematical operation only: one number plus a second

number equals a third number. Writing a simple formula is really no more difficult than that: 1+1. The

only difference in Excel is that all formulas must begin with the equal sign (=). It is not enough to

type 1+1 in Excel because what will appear in the cell is "1+1." You must begin the equation with

an equal sign, or =1+1. This holds true for any formula, simple or complicated, that adds, subtracts, multiplies or divides.


Let's add two numbers to create a third, 128+345=473. In Excel, this would be expressed by the formula, =128+345, as shown below.

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=5]To Create a Simple Formula that Adds Two Numbers:

• Click the cell where the formula will be defined.

• Type the equal sign (=) to let Excel know a formula is being defined.

• Type the first number to be added (128, for example)

• Type the addition sign (+) to let Excel know that an add operation is to be performed.

• Type the second number to be added (345, for example

• Press Enter or click the Enter button on the Formula bar to complete the formula.

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=3]Creating a Simple Addition Formula (continued)

But what if a column contains many numbers, each of which regularly changes? You don't want

to write a new formula each time a number is changed. Luckily, Excel 2003 lets you include cell references in formulas.


A formula can add the value of two cells-B2 and B3, for example. Type any two values in these two cells and the formula will adjust the answer accordingly.


Using this method to calculate two numbers-128 and 345, for example-requires that you type 128 in

cell B2, for example, and 345 in cell B3. The Excel formula, =B2+B3, would then be defined in cell B4.

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=5]To Create a Simple Formula that Adds the Contents of Two Cells:

• Type the numbers you want to calculate in separate cells (for example, type 128 in cell B2 and 345 in cell B3).

• Click the cell where the answer will appear (B4, for example).

• Type the equal sign (=) to let Excel know a formula is being defined.

• Type the cell number that contains the first number to be added (B2, for example).

• Type the addition sign (+) to let Excel know that an add operation is to be performed.

• Type the cell number that contains the first number to be added (B3, for example).

• Press Enter or click the Enter button on the Formula bar to complete the formula.

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=3]Creating a Simple Subtraction Formula Using the Point-and-Click Method

Formulas can be created by using either numbers or cell references in the definition. You can also

use the mouse to select the cells to be used in the formula instead of typing the cell number or

cell reference. Using this method, we are going to write a simple formula that subtracts one cell from another: =B3-B2.

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=5]To Create a Simple Formula using the Point and Click Method:

• Type the numbers you want to calculate in separate cells (for example, type 128 in cell B2 and 345 in cell B3).

• Click the cell where the answer will appear (B4, for example).

• Type the equal sign (=) to let Excel know a formula is being defined.

• Click on the first cell to be included in the formula (B3, for example).

• Type the subtraction sign (-) to let Excel know that a subtraction operation is to be performed.

• Click on the next cell in the formula (B2, for example).

• If you include multiple cells in the formula, repeat steps 4 and 5 until the entire formula is entered.

• Press Enter or click the Enter button on the Formula bar to complete the formula.

​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=3]Creating Simple Multiplication Formulas

Creating multiplication formulas is very similar to addition and subtraction formulas. To multiply two

cells the formula, B2 and B3, you would need to insert a multiplication operator * between them, =B2*B3.

​